OleDbConnection Inst_SelectConn = new OleDbConnection (oleDbConnection1.ConnectionString);
string StrInst = "INSERT INTO PatientBasic_Test(PatientNo,HospitalCode,CreateDate,UpdateDate,UpdateOperator) ";
string StrValue = "VALUES('" + inst.PatientNo.Text+"','" + inst.HospitalCode.Text + "','"+inst.CreateDate.Value +"','" + inst.UpdateDate.Value + "','" + inst.UpdateOperator.Text + "')";
StrSql = StrInst + StrValue;
OleDbCommand Inst_Command = new OleDbCommand(StrSql,Inst_SelectConn);
Inst_SelectConn.Open();
Inst_Command.ExecuteNonQuery();
dataSet11.Clear();
oleDbDataAdapter1.Fill(dataSet11 , "Patientbasic_Test");
dataGrid1.Refresh();
dataGrid1.DataSource = dataSet11;
Inst_SelectConn.Close();
string StrInst = "INSERT INTO PatientBasic_Test(PatientNo,HospitalCode,CreateDate,UpdateDate,UpdateOperator) ";
string StrValue = "VALUES('" + inst.PatientNo.Text+"','" + inst.HospitalCode.Text + "','"+inst.CreateDate.Value +"','" + inst.UpdateDate.Value + "','" + inst.UpdateOperator.Text + "')";
StrSql = StrInst + StrValue;
OleDbCommand Inst_Command = new OleDbCommand(StrSql,Inst_SelectConn);
Inst_SelectConn.Open();
Inst_Command.ExecuteNonQuery();
dataSet11.Clear();
oleDbDataAdapter1.Fill(dataSet11 , "Patientbasic_Test");
dataGrid1.Refresh();
dataGrid1.DataSource = dataSet11;
Inst_SelectConn.Close();
这样试试
DataGrid1.DataBind();
为空的话,用commandbuilder来生成你的update语句。
如果是多表的话,就需要你自己手写生成了。
用DataGrid1.DataBind();应该可以。