AspDotNetAtoms.com provides daily updates on ASP.NET Tutorials, Programming Resources, .NET Articles, Authors and more.

Categories

Recent Posts

Updating the TableAdapter to Use JOINs : Scott Mitchell

Tuesday, September 09 2008

When working with a database it is common to request data that is spread across multiple tables. To retrieve data from two different tables we can use either a correlated subquery or a JOIN operation. In this tutorial we compare correlated subqueries and the JOIN syntax before looking at how to create a TableAdapter that includes a JOIN in its main query. With relational databases the data we are interested in working with is often spread across multiple tables. For example, when displaying product information we likely want to list each product’s corresponding category and supplier’s names. The Products table has CategoryID and SupplierID values, but the actual category and supplier names are in the Categories and Suppliers tables, respectively....

Read More:
Updating the TableAdapter to Use JOINs : Scott Mitchell
Also See:
Changing GridView Column Color : AzamSharp
Wrapping Database Modifications within a Transaction : Scott Mitchell
Master/Detail Part 2: Filtering With Two DropDownLists : Scott Mitchell
Accessing data using Language Integrated Query (LINQ) in ASP.NET WebPages – Part 1 : Balamurali Balaji
Integrate Windows Live ID Authentication with ASP.NET Membership, Profiles and Roles : Peter A Bromberg

Post your comment

Comment