AspDotNetAtoms.com provides daily updates on ASP.NET Tutorials, Programming Resources, .NET Articles, Authors and more.
Categories
Recent Posts
- Handling Files and Directories from your web applications. : Rockin J
Using C#, VB.NET, and ASP.NET to get all files of directory and subdirectory. Simply illustration of - Animated Popup Master/Detail using GridView, DetailsView and JQuery with jqModal & UpdatePanel : Muhammad Mosa
Demonstrate how to build master/details data presentation using GridView, DetailsView as animated pop - Understanding Script Injection Attacks : Sanjit Sil
This article helps to understand the concept of script injection attacks in detail using ASP.NET. Sanjit - Designing An Application Using Test Driven Development : Mohammad Azam
Application design is one of the most important aspects of creating the application. A design serves - Cross-Site Scripting in ASP.NET : SandeepReddy Pasham
Cross-site scripting attacks exploit vulnerabilities in Web page validation by injecting client-side
Search
ASP.NET Resources
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....Perform Database Administration Operations with SQL Server Management Objects : John Papa
Build a Multi-Provider Async Methods Search Page : Peter A Bromberg
Performing Batch Deletes from the Database : Scott Mitchell
Master/Detail Filtering With a DropDownList : Scott Mitchell
Using Parameterized Queries with the SqlDataSource : Scott Mitchell