Chapter 7

ken evans · February 3rd, 2010, 02:01 PM

I have three stored procedures for one of my tables. (one each for Select, Insert, Update).

I am confused by the "Define Parameters" dialog box of the SqlDataSource- Configure Data Source procedure.

My problem is that I'm not sure what to do with the "Parameter Source" drop down box.
The "Parameters" box correctly lists all of the columns in my stored procedure.

So what do I put into the "Parameter source" drop down box?
When I choose "Control" in the drop down box, the next dialog box asks for the ControlID.

However, I have not yet added any UI controls to my aspx page.
- I was hoping to be able to use the ListView or DetailsView because they seem to offer lots of time saving. But I can't figure out how to do this.

So do I have to design a UI with lots of controls (each with an ID) on the aspx page before I can complete the "Define Parameters" dialog box?
Or am I missing something?

Thanks

Ken

Imar · February 7th, 2010, 08:55 AM

Hi Ken,

Maybe this tutorial helps? http://www.asp.net/learn/data-access...ial-48-cs.aspx

Cheers,

Imar

ken evans · February 7th, 2010, 10:40 AM

Thanks Imar,
What helps begins at step 3 of the tutorial that you referenced.
The next two tutorials are also very helpful.

I'm looking forward to your ASP.NET 4.0 book.
Ken

Imar · February 7th, 2010, 10:59 AM

Quote:

I'm looking forward to your ASP.NET 4.0 book.

Working on that as we speak; just finished chapter 11 on jQuery and 12 on databases....

Imar