Shailesh Uke

Shailesh Uke

  • 971
  • 807
  • 17k

Convert sqlquery to RowFilter DataTable Query

May 29 2017 10:05 PM
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;

Answers (1)