Loading

Convert sqlquery to RowFilter DataTable Query

Shailesh Uke

9y1.6k.NET

i want to convert query to RowFilter DataTable Query c#

my code is

string strSql = "SELECT TOP " + this.mintPageSize +      " * FROM tblEmp WHERE E_Id NOT IN " +      "(SELECT TOP " + intSkip + " E_Id FROM tblEmp)";

  DataView dv = new DataView(documentDataTable);
  //creating query 
  dv.RowFilter = strSql;

1 Reply

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

Manas Mohapatra9y ago
Use following link to get no of records :

http://sunnyhasan.blogspot.com/2009/05/how-to-get-top-n-rows-of-dataview-in-c.html

or

documentDataTable.AsEnumerable().Take(5).CopyToDataTable()

For filter, use below code:

DataView dv = new DataView(documentDataTable, "Id NOT IN (1, 2, 3)", "Product_Name", DataViewRowState.CurrentRows)
+1