1
Answer

Convert sqlquery to RowFilter DataTable Query

Shailesh Uke

Shailesh Uke

7y
677
1
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)