Data Set Designer/Table Adapter Wizard Test with Existing Stored Procedures
The Data Set Designer/Table Adapter Wizard Test using existing stored procedures extends the Data Set Designer Drag-and-Drop Test by adding manipulation of existing stored procedures to data source objects dragged to the DataSet designer from the Visual Studio Server Explorer.
Test Procedure
Create a new Windows Application project.
Add a DataSet project item.
From the Toolbox, drag a TableAdapter to the Dataset designer. The TableAdapter Configuration Wizard appears.
On the Choose Your Data Connection page, add a connection to the database using the generic provider.
Make sure the connection is selected in the combo box and click Next.
On the Save the Connection String to the Application Configuration File page, click Next.
On the Choose a Command Type page, select Use existing stored procedures and click Next.
On the Bind Commands to Existing Stored Procedures page, choose existing stored procedures for each type of stored procedure and click Next.
On the Choose Methods to Generate page, keep the default values and click Next.
On the Wizard Results Page, click Finish.
A TableAdapter is created using the stored procedures selected. Verify the following in the designer:
Columns created for the DataTable
The CommandText property and the Parameters collection on the TableAdapter
Configuration of the Delete, Insert, Select, and Update commands for the CommandText property and Parameters collection
Repeat steps 3–11 with the following scenarios:
A single stored procedure for only the Select statement
Parameterized stored procedures for Delete, Insert, Select, and Update commands