How to pass WHERE condition in Datatable.defaultview.totable()

[nidheessingh]

Hello,

Anyone can help about passing WHERE condition inside Datatable.defaultview.totable().

For example:

---

dt_Excel.defaultview.totable(false, “TransactionNumber”,“Status”).Select.CopyToDataTable

In the above query, how I can pass WHERE condition?

Please suggest…

Regards,
Nidhees

[Palaniyappan (Palaniyappan P)]

Hi @nidheessingh

Kindly have a view on this which could give you some insights on this

DataTable.DefaultView Property (System.Data)

Cheers @nidheessingh

[Palaniyappan (Palaniyappan P)]

Hi @nidheessingh

Kindly have a view on this which could give you some insights on this

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

DataTable.DefaultView Property (System.Data)

Cheers @nidheessingh