467,888 Members | 1,528 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,888 developers. It's quick & easy.

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

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
  • viewed: 2453
Share:
1 Reply
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.

Similar topics

reply views Thread by Igor | last post: by
10 posts views Thread by Trevor | last post: by
7 posts views Thread by Serge Rielau | last post: by
9 posts views Thread by dba123 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.