How to check particular table in datatable in c#

Priyanka Singh

6y1.1k.NET

Suppose I have values in the dataset, I have to use it using the data table and I have to check and apply the condition in table1 of the dataset using a data table.

private void generateResult_paid(DataTable dt, IXLWorksheet worksheet, string sheetname)
{
if(table1 of dataset)
lineNum = 11;
else
lineNum = 1;
}

I have to used value in the data table, not in the data set.

How I get table1 of the dataset using a data table.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty6y ago
You can check with the following if statement.
if(dataSet.Tables.Contains("TableName"))

// OR

int flag = 0;
try
{
    if (dataSet.Tables["tablename"].Rows.Count > 0)
    {
        // execute something
    }
}
catch (Exception ex)
{
    flag = 1;
}

if (flag == 1)
{
    //Table does not exists
}
Jignesh Kumar6y ago
Hi Priayanka,

I think you can have multiple tables inside dataset not in datatable. If you want to check datatable inside dataet then you can check first condition on dataset has at list one table. Table[0] means your first table inside dataset. you can change this number based on select statement.
dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0
Please try below link,

https://codereview.stackexchange.com/questions/6841/checking-datasets-for-tables-and-rows
Laxmidhar Sahoo6y ago
hi
I can not understand why you want to comape with the same tables .What is the logic behind it.
Or
You want to compare to worksheet data with the data table ?
Priyanka Singh6y ago
1. //In method 1
3. for (int j = 0; j < ds.Tables.Count; j++)
4. {
5. // Generate Excel sheet for Table[0]
6. if (j == 0)
7. generateResult_paid(ds.Tables[j], worksheet, sheet_name[i]);
8. }
1. //Now I have to call in method-2
2. private void generateResult_paid(DataTable dt, IXLWorksheet worksheet, string sheetname)
3. {
4. if(table1 of dataset) //how I know it belongs to table1 using datatable
5. lineNum = 11;
6. else
7. lineNum = 1;
8. }

Laxmidhar Sahoo6y ago

You did not display any field for join .I jist take a example

List lstEmployee = dataset.Tables[0].AsEnumerable().Select(
dataRow => new Employe
{
EmpID = dataRow.Field<int>("EmpID"),
EmpCode = dataRow.Field<int>("EmpCode"),
EmpName = dataRow.Field<string>("EmpName")
}).ToList();
publc class Employee
{
public int EmpId {get;set;}
.
.
.
}
var finallist = (from l in lstEmployee
join d in table1.AsEnumerable()
on l.EmpID equals d.Field<int>("EmpID")
select d.ItemArray.ToList());
//minimum one row compare
if(finallist != null && finallist.count() > 0)
//whole table compare
if(finallist != null && finallist.count() == table1.rows,count)

Priyanka Singh6y ago

I already define it.. I post only that code where I need to still work...I have to apply condition in if statement that if datatable contains table1 then if condition execute.Dataset contain two table and in data table value comes one by one like table and then table 1.

Laxmidhar Sahoo6y ago

Here you did not define any dataset.

generaly dataset contains a single or multiple of tables(query results).

Whether you want to convert the dataset table to a datatable or something else?