Wrox Programmer Forums
|
BOOK: Professional ASP.NET 3.5 : in C# and VB ISBN: 978-0-470-18757-9
This is the forum to discuss the Wrox book Professional ASP.NET 3.5: In C# and VB by Bill Evjen, Scott Hanselman, Devin Rader; ISBN: 9780470187579
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional ASP.NET 3.5 : in C# and VB ISBN: 978-0-470-18757-9 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 3rd, 2010, 02:01 PM
Authorized User
Points: 267, Level: 5
Points: 267, Level: 5 Points: 267, Level: 5 Points: 267, Level: 5
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2010
Posts: 56
Thanks: 17
Thanked 2 Times in 2 Posts
Default Chapter 7 - Data binding to stored procedures

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
 
Old February 7th, 2010, 08:55 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi Ken,

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

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
 
Old February 7th, 2010, 10:40 AM
Authorized User
Points: 267, Level: 5
Points: 267, Level: 5 Points: 267, Level: 5 Points: 267, Level: 5
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2010
Posts: 56
Thanks: 17
Thanked 2 Times in 2 Posts
Default

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
 
Old February 7th, 2010, 10:59 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!





Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 7 PTORequest Stored Procedures Issue tdewey BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio 1 February 28th, 2010 03:40 PM
Chapter 17-Data Binding Hotshotron25 BOOK: Beginning Microsoft Visual Basic 2008 ISBN: 978-0-470-19134-7 1 August 20th, 2009 04:10 PM
Excel 2007 data from parameterized stored procedures scott.smith BOOK: Excel 2007 VBA Programmer's Reference ISBN: 978-0-470-04643-2 0 August 13th, 2009 11:17 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.