SQLDatasource parameters

Question

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?

darth_phoenixx · Accepted Answer · 2011-02-09 21:38:34Z

5

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();

edited Feb 9, 2011 at 21:38

answered Feb 9, 2011 at 21:03

darth_phoenixx

96214 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

WillB3 Over a year ago

Should be SqlDataSourceArticole.SelectParameters.Add("id", id); with no @

Brian Mains · Accepted Answer · 2011-02-09 19:23:21Z

2

You can update the value by:

SqlDataSourceArticole.SelectParameters["id"].DefaultValue = id.ToString();

Using the default value can work in this case.

HTH.

answered Feb 9, 2011 at 19:23

Brian Mains

50.8k35 gold badges155 silver badges260 bronze badges

2 Comments

hhh3112 Over a year ago

i get 'System.NullReferenceException: Object reference not set to an instance of an object.'

Brian Mains Over a year ago

The ID parameter has to exist in markup; if you are programmably create the collection of parameters, then when you create the parameter, also set the default value.

Collectives™ on Stack Overflow

SQLDatasource parameters

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related