How to call store procedure by sqldatasource Programmatically to bind gridview

Question

how can we execute store procedure by using sqldatasource
Programmatically??

I want to bind it with gridview
i am using like this

Collapse | Copy Code
sqldsSiteList.SelectCommandType = SqlDataSourceCommandType.StoredProcedure sqldsSiteList.SelectCommand = "Stp_RmsAdmin_GetsitesBycustomization"

Collapse | Copy Code
sqldsSiteList.SelectParameters.Add("@CustomerID", TypeCode.Int32, ddlCustomer.SelectedValue) sqldsSiteList.SelectParameters(0).Direction = ParameterDirection.Input

Collapse | Copy Code
sqldsSiteList.SelectParameters.Add("@PageIndex", TypeCode.Int32, "1") sqldsSiteList.SelectParameters(1).Direction = ParameterDirection.Input GridView1.DataBind()

when i bind it to grid it gives me error

Collapse | Copy Code
"Procedure or Function 'Stp_RmsAdmin_GetsitesBycustomization' expects parameter '@CustomerID', which was not supplied."

mohammad qasim · Answer

I have done it my mistake was this sqldsSiteList.SelectParameters.Add(@CustomerID TypeCode.Int32 ddlCustomer.SelectedValue) just remove @ from paramter its working though i declared paramter in procedure like @CustomerID but we need to add parameter name without @ happy programing

Pravin More · Answer

Hi Mohamad use bolow code to call stored procedure........... SqlConnection spcon =new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[commonconnection].ToString()); spcon.Open(); SqlDataReader dr; SqlCommand spcmd; spcmd = new SqlCommand(Stp_RmsAdmin_GetsitesBycustomization spcon); spcmd.Parameters.Add(new SqlParameter(@CustomerID ddlCustomer.SelectedValue)); spcmd.Parameters.Add(new SqlParameter(@PageIndex 1)); spcmd.CommandType = CommandType.StoredProcedure; dr = spcmd.ExecuteReader(); Thanks Pravin.