DataAdapter Table Names

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christopher Weaver - 12 May 2005 22:55 GMT

Using the VS 2003 IDE, How do I specify the name that I want associated with
the table returned by the DataAdapter? It defaults to Table. I want a
DataSet to include more than one table and, of course, I can't do that if
they're both named Table.

Reply to this Message

Sunder Thondamuthur - 10 Jun 2005 20:07 GMT

Hello Christopher
I am not sure how you are filling your datset . Are you using Typed Dataset ? There are couple of ways to change the tableName .
a) You can use TableMappings Dialog , This is a property on DataAdapter
b) You can use SqlDataAdapter1.Fill(ds,"TableName") , You can give your tableName

Thanks
Sunder
Vb.Net

--------------------

>Reply-To: "Christopher Weaver" <we.aver@nospamVerizon.net>
>From: "Christopher Weaver" <we.aver@verizon.net>
[quoted text clipped - 17 lines]
>DataSet to include more than one table and, of course, I can't do that if
>they're both named Table.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...