Filter a table or view

DataView DV = New DataView ();

DV.TABLE = TH_ROLE.GETTABLE ();

DV.ROWFILTER = "ID = '1'";

//dv.sort = "ID DESC";

this.dataGrid1.datasource = DV;

THIS.DATAGRID1.DATABIND ();