1、在DataGrid窗体中修改的其实就是DataSet中的数据,用MessageBox.Show(Convert.ToString( ds.Tables["MainInfo"].Rows[0]["D_Connect"] )); 可以看到,无论绑定的是DataSet还是DataViewManager,都一样。
2、要对DataSet进行更新,需要OleDbCommandBuilder,例:OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter);
3、
2、要对DataSet进行更新,需要OleDbCommandBuilder,例:OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter);
3、
private void fBtnGetClass_Click(object sender, EventArgs e)
{
MessageBox.Show("Startfilter");
string strfilter = "D_PrintCollege = " + this.fCboxSearchCollege.Text + " and D_PrintClass = " + this.fCboxSearchClass.Text;
MessageBox.Show(strfilter);
//dvm.DataViewSettings["MainInfo"].RowFilter = "D_ID= 4";
dataGrid.SetDataBinding(dvm, "MainInfo");
//((DataView)dataGrid.DataSource).RowFilter = "D_PrintCollege = b ";
// ((DataView)dataGrid2.DataSource).RowStateFilter = state;
MessageBox.Show("Return");
dataGrid.SetDataBinding(dvm, null);
MessageBox.Show("NULL?");
dvm = new DataViewManager(ds);
dvm.DataViewSettings["MainInfo"].RowFilter = "D_ID= 4";
dataGrid.SetDataBinding(dvm, "MainInfo");
}
只能对DataViewManager进行一次RowFilter操作?需要再做一次操作需要再重新实例化一次?
{
MessageBox.Show("Startfilter");
string strfilter = "D_PrintCollege = " + this.fCboxSearchCollege.Text + " and D_PrintClass = " + this.fCboxSearchClass.Text;
MessageBox.Show(strfilter);
//dvm.DataViewSettings["MainInfo"].RowFilter = "D_ID= 4";
dataGrid.SetDataBinding(dvm, "MainInfo");
//((DataView)dataGrid.DataSource).RowFilter = "D_PrintCollege = b ";
// ((DataView)dataGrid2.DataSource).RowStateFilter = state;
MessageBox.Show("Return");
dataGrid.SetDataBinding(dvm, null);
MessageBox.Show("NULL?");
dvm = new DataViewManager(ds);
dvm.DataViewSettings["MainInfo"].RowFilter = "D_ID= 4";
dataGrid.SetDataBinding(dvm, "MainInfo");
}