How to call store procedure by sqldatasource Programmatically to bind gridview

mohammad qasim

14y6.3k.NET

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."

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

mohammad qasim14y ago
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 More14y ago
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.