How to check particular table in datatable in c#

Question

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.

Amit Mohanty · Answer

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 Kumar · Answer

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 Sahoo · Answer

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 Singh · Answer

//In method 1 for ( int j = 0; j { // Generate Excel sheet for Table[0] if (j == 0) generateResult_paid(ds.Tables[j], worksheet, sheet_name[i]); } //Now I have to call in method-2 private void generateResult_paid(DataTable dt, IXLWorksheet worksheet, string sheetname) { if (table1 of dataset) //how I know it belongs to table1 using datatable lineNum = 11; else lineNum = 1; }

Laxmidhar Sahoo · Answer

hi 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 Singh · Answer

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 Sahoo · Answer

hi 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?