CODEWITHSUNDEEP
c#datatable
SuicideSheep
SuicideSheep

Reputation: 5550

How to get particular DataTable using TableName?

One DataSet usually has lots of DataTable, but I'm only to target a particular DataTable which I thought it's pretty normal but apparently failed to do it?
Below were the approaches I've tried:

//Could not find an implementation of the query pattern for source type.......
DataTable dt = from table in changesDataSet.Tables
               where table.TableName = "ABC"
               select table;

//Surprisingly there was no method "Where" in changesDataSet.Tables
DataTable dt = changesDataSet.Tables.Where(x=>x.TableName="ABC").First();

Below was the code that able to print each and every table. I know I can do it via a loop but please tell me loop isn't the only options

foreach(DataTable table in changesDataSet.Tables)
{
    Console.WriteLine(table.TableName);
}

Upvotes: 2

Views: 8554

Answers (1)

Eugene Pawlik
Eugene Pawlik

Reputation: 1190

You can access the table using an indexer on the collection of tables (DataTableCollection):

DataTable dt = changesDataSet.Tables["ABC"];

Upvotes: 5

Related Questions