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;