RowFilter的使用.....

 后台:

public DataSet ds = new DataSet();
    DataView dv = new DataView();
string strDBPath = System.Configuration.ConfigurationSettings.AppSettings["DBPath"];
            string strConn = System.Configuration.ConfigurationSettings.AppSettings["Connection"] + Server.MapPath(strDBPath);
            OleDbConnection myConnection = new OleDbConnection(strConn);
dr = new OleDbDataAdapter( "Select * From Products", myConnection );
 dr.Fill( ds, "tableName" );
        dv = ds.Tables["tableName"].DefaultView;

        dv.RowFilter = "id='1'";
        DataGrid1.DataSource = dv;
        DataGrid1.DataBind();

        dv.RowFilter = "id='0'";
        DataGrid2.DataSource = dv;
        DataGrid2.DataBind();

前台:

两个DataGrid控件