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

[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

[Sahil Malik [MVP]]

AFAIK No, but .NET 2.0 is so new so I could be incorrect.

Also in this case you can't even use partial class extensibility to modify
this behavior, you can however inherit and then use a TableMappings to get
around this issue.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.ma.../13/63199.aspx
----------------------------------------------------------------------------
---------------

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:ep**************@TK2MSFTNGP09.phx.gbl...

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