GridView with stored procedure

I have stored procedure to fill Gridview:

       SqlDataSource SqlDataSource1 = new SqlDataSource();
SqlDataSource1.ID = "SqlDataSource1";
this.Page.Controls.Add(SqlDataSource1);
SqlDataSource1.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["XYZ"].ConnectionString;

SqlDataSource1.SelectParameters.Add("@OrganizationID", "1");

SqlDataSource1.SelectCommand = "Execute JVonTheFLY";

DataView dvProducts = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
DataTable dtProducts = dvProducts.Table;
BoundField boundField = null;

It is woking if i don't use parameters, but when i use patameter is not send to sql server procedure

"Procedure or function 'JVonTheFLY' expects parameter '@OrganizationID', which was not supplied."

1 Reply

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

Sachin Singh4y ago
either do this
SqlDataSource1.SelectParameters.Add("@OrganizationID", "1");
SqlDataSource1.SelectCommand = "Execute JVonTheFLY @OrganizationID";
or
SqlDataSource1.SelectCommand = "JVonTheFLY";
SqlDataSource1.SelectCommand.CommandType = CommandType.StoredProcedure;
SqlDataSource1.SelectParameters.AddWithValue("@OrganizationID", "1");
SqlDataSource1.DataBind();