By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,251 Members | 2,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,251 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.