AspNetAtoms.com daily updates on ASP.NET Tutorials, Articles, Authors and more. Subscribe to our newsletter and receive updates on ASP.NET resources on the Internet.

Categories

Recent Posts

Using Existing Stored Procedures for the Typed DataSet’s TableAdapters : Scott Mitchell

Thursday, April 30 2009

In this tutorial we learn how the same TableAdapter Wizard can work with existing stored procedures. We also learn how to manually add new stored procedures to our database. In the preceding tutorial we saw how the Typed DataSet’s TableAdapters could be configured to use stored procedures to access data rather than ad-hoc SQL statements. In particular, we examined how to have the TableAdapter wizard automatically create these stored procedures. When porting a legacy application to ASP.NET 2.0 or when building an ASP.NET 2.0 website around an existing data model, chances are that the database already contains the stored procedures we need. Alternatively, you may prefer to create your stored procedures by hand or through some tool other than the TableAdapter wizard that auto-generates your stored procedures. In this tutorial we will look at how to configure the TableAdapter to use existing stored procedures. Since the Northwind database only has a small set of built-in stored procedures, we will also look at the steps needed to manually add new stored procedures to the database through the Visual Studio environment. Let’s get started....

Read More:
Using Existing Stored Procedures for the Typed DataSet’s TableAdapters : Scott Mitchell
Also See:
Securing Applications in ASP.NET 2.0 : Uday Denduluri
Custom Http Handlers : Sandeep Karnik
Adding Multiple Rows in the GridView Control : Mohammad Azam
Review: ASP.NET 2.0 Web Parts in Action : Richard J. Dudley
Master Pages: Tips, Tricks, and Traps : K. Scott Allen

Post your comment

Comment