How can i set sql parameters for an sqlDatasource in the code behind?
I am trying like this:
int id=1;
SqlDataSource1.SelectCommand = "SELECT * FROM categ WHERE id=@id";
SqlDataSourceArticole.SelectParameters.Add("@id", id);
// and also like this:
SqlDataSourceArticole.SelectParameters.Add("id", id);
but it doesn't work? What am i doing wrong?
Make sure you add the select parameters before trying to set their default value.
i.e.
SqlDataSourceArticole.SelectParameters.Add("@id", id);
SqlDataSourceArticole.SelectParameters["id"].DefaultValue = id.ToString();
You can update the value by:
SqlDataSourceArticole.SelectParameters["id"].DefaultValue = id.ToString();
Using the default value can work in this case.
HTH.