How to get data after DataView filtering?

c# asp.net datatable dataview rowfilter
DmitryB picture DmitryB · May 19, 2011 · Viewed 11.4k times · Source

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.

Answer

Muhammad Akhtar picture Muhammad Akhtar · May 19, 2011

Assign a Filtered DataView to your DataTable, then you can iterate your DataTable.

dtbl = dvUnloadOpenAccounts.ToTable();
//Then iterate your DataTable

Related questions

Sorted dataview to datatable

I have the following method: private DataTable getsortedtable(DataTable dt) { dt.DefaultView.Sort = "Name desc"; //I would need to return the datatable sorted. } My issue is that I cannot change the return type of this method and I have to …

Read More
Read SQL Table into C# DataTable

I've read a lot of posts about inserting a DataTable into a SQL table, but is there an easy way to pull a SQL table into a .NET DataTable?

Read More
How I can filter a Datatable?

I use a DataTable with Information about Users and I want search a user or a list of users in this DataTable. I try it butit don't work :( Here is my c# code: public DataTable GetEntriesBySearch(string username,string location,…

Read More