SQLDatasource parameters problem

Question

Why if i use the following instruction in the code behind:

SqlDataSource1.SelectParameters["page"].DefaultValue = "0";

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

'?

Is SqlDataSource1.SelectParameters valid (!= null)?? Is SqlDataSource1.SelectParameters["page"] valid (!= null)?? This is just very basic debugging.... — marc_s
– marc_s, Commented Feb 9, 2011 at 20:18

RichardTheKiwi · Accepted Answer · 2011-02-09 20:19:02Z

5

The only two objects involves in that single statement are (bold)

SqlDataSource1.SelectParameters["page"].DefaultValue

SqlDataSource1.SelectParameters["page"].DefaultValue

So one of them must be null. When looking at this together with your previous question, it is because you have not yet added the "page" parameter to SqlDataSource1.

answered Feb 9, 2011 at 20:19

RichardTheKiwi

108k28 gold badges206 silver badges269 bronze badges

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

Comments

Kevin Babcock · Accepted Answer · 2011-02-09 20:20:44Z

1

Either your SqlDataSource object is null or its SelectParameters collection doesn't have an entry for "page". Check that you have defined that select parameter appropriately.

answered Feb 9, 2011 at 20:20

Kevin Babcock

10.2k20 gold badges72 silver badges90 bronze badges

1 Comment

Nate Over a year ago

Parameter must be one of Control, Cookie, Form, Profile, QueryString, Session or Route. Since I didn't create a session variable or a cookie I didn't try those. I tried the others and they all failed. How do I create the parameter?

Collectives™ on Stack Overflow

SQLDatasource parameters problem

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related