DataTable reference

[Marty]

I have created a DataSet (dsCurrent) and to it I have added 3
DataTables. Using the same DataTable variable (dtCurrent).
I am trying to get a reference to it by doing something like.
DataTable dt = dsCurrent.Tables("Table1");
but that obviously doesn't work.
How can I do this?

Thanks,

[Peter Bromberg [C# MVP]]

Marty,
It "obviously" should work, provided you gave your DataTable the .TableName
"Table1" before you added it to your DataSet. Otherwise, you would need to
get it out by ordinal (e.g. MyDataSet.Tables[2] ).

Hope that helps.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Marty" wrote:

I have created a DataSet (dsCurrent) and to it I have added 3
DataTables. Using the same DataTable variable (dtCurrent).
I am trying to get a reference to it by doing something like.
DataTable dt = dsCurrent.Tables("Table1");
but that obviously doesn't work.
How can I do this?

Thanks,

[Marty]

Well no it didn't until I read your post!
I needed
dsCurrent.Tables["Table1"];
not
dsCurrent.Tables("Table1");

Doh!
It's the simple things in life...
Thanks a bunch

[John Fullmer]

If you happen to be using the MS Data Application Block there is a
TableMappings property that lets you modify tablenames into something
more friendly. The whole "Table1" thing is ok if you only have 1 or 2
datatable.

- John Fullmer