How to get data after DataView filtering?
11,891
Assign a Filtered DataView
to your DataTable
, then you can iterate your DataTable
.
dtbl = dvUnloadOpenAccounts.ToTable();
//Then iterate your DataTable
Author by
DmitryB
Updated on June 04, 2022Comments
-
DmitryB almost 2 years
I apply a filter to Dataview and after that I need to get the filtered data. before filtering I did:
dvUnloadOpenAccounts.RowFilter = "uso_id = '30640'"; foreach (DataRow row in dvUnloadOpenAccounts.Table.Rows) { HSSFRow dataRow = sheet.CreateRow(rowIndex); foreach (DataColumn column in dvUnloadOpenAccounts.Table.Columns) { dataRow.CreateCell(column.Ordinal).SetCellValue(row[column].ToString()); } rowIndex++; }
So I need do the same with filtered data.