在dataset中添加新行

 

 SqlConnection SqlConn;

 DataSet objDataSet=new DataSet();

 string Connstr=ConfigurationSettings.AppSettings["strConn"];

 string SQLstr="select * from khxx";

 SqlConn=new SqlConnection(Connstr);

 SqlDataAdapter objAdapter=new SqlDataAdapter(SQLstr,SqlConn);

 objAdapter.Fill(objDataSet,"khxx");

 

 DataRow row=objDataSet.Tables[0].NewRow();

 row["khbh"]=TextBox3.Text;

 row["khjc"]=TextBox4.Text;

 row["dh"]=TextBox5.Text;

 row["cjri"]=TextBox6.Text;

 row["bycgl"]=TextBox7.Text;

 

 objDataSet.Tables[0].Rows.Add(row);

 SqlCommandBuilder cb=new SqlCommandBuilder(objAdapter);

 objAdapter.Update(objDataSet,objDataSet.Tables[0].ToString());

 BindGrid();