Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 4 > BOOK: Beginning ASP.NET 4 : in C# and VB
|
BOOK: Beginning ASP.NET 4 : in C# and VB
This is the forum to discuss the Wrox book Beginning ASP.NET 4: in C# and VB by Imar Spaanjaars; ISBN: 9780470502211
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 4 : in C# and VB 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 November 28th, 2011, 02:21 PM
Friend of Wrox
 
Join Date: Apr 2010
Posts: 125
Thanks: 20
Thanked 3 Times in 3 Posts
Default Retrieving Joined table using SqlDataSource

Hi there,
If my question is not relevant to book please excuse me.
In the book we use SqlDataSource to retrieve only one table data. However if we want to retrieve Joined table how we can?Is there a way in VS? Or I Should change the markup which generated by SqlDataSource SelectCommand.
Thank's
__________________
Please excuse me for poor and bad English.
 
Old November 28th, 2011, 02:28 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi there,

In the SqlDataSource wizard choose Specify a custom SQL statement or stored procedure and then click Query Builder to define complex queries such as JOINs.

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!
The Following User Says Thank You to Imar For This Useful Post:
morteza (November 28th, 2011)
 
Old November 28th, 2011, 02:36 PM
Friend of Wrox
 
Join Date: Apr 2010
Posts: 125
Thanks: 20
Thanked 3 Times in 3 Posts
Default

Great,
Thanks
__________________
Please excuse me for poor and bad English.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieving data from a table given a PK value galaxy3 VB Databases Basics 1 June 22nd, 2006 12:12 PM
retrieving multiple rows from table blackbeauty SQL Language 1 August 8th, 2005 03:55 AM
Retrieving items from a table - Immediate Help badprogrammer Access VBA 2 May 4th, 2005 02:39 PM
Having problems retrieving an array to a table! penta Access 2 September 27th, 2004 07:23 AM
UPDATE with joined tables DanKent SQL Server 2000 4 July 6th, 2004 08:30 AM





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