Table Adapter Configuration Wizard replaces data table name with stored procedure's

J

John

Hi

When using Table Adapter Configuration Wizard if 'Use SQL Statements' is
selected as Command Type, the data table's name in dataset is retained and
only its data adapter's select statements are replaced. If however 'Create
new stored procedures' is selected as Command Type, the data table name in
replaced by the name of the newly created select stored procedure. Problem
with this is that the data table's name needs to be put back manually.

Is there a way to keep the data table name the same and just stored
procedures are assigned to the data table's data adapter?

Thanks

Regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Adapter Configuration Wizard 1
getting table adapter return values from stored procedures? 1
Problems getting the result fields to show up in a Table Adapter 2
Populate Dataset with Parameterized Stored Procedure 1
ms sql # temp table - invalid object name in data source 4
basic dataset/table question 1
Multiple select statements in a single stored procedure. 2
CommandType = TEXT vs Stored Procedure. 4

Top