//摘要:用SqlDataAdapter对象添加数据主要是用到了,SqlCommandBuilder、DataSet、DataRow这几个对象,具体的实现方法,如下代码:
string Title_1 = this.Table_1.Text.Trim();
string Title_2 = this.Table_2.Text.Trim();
string Title_3 = this.Table_3.Text.Trim();
string Title_4 = this.Table_4.Text.Trim();
SqlDataAdapter dt = new SqlDataAdapter("SELECT * FROM Test_1",sqlconnection对象);
SqlCommandBuilder oBulider = new SqlCommandBuilder(dt);
DataSet ds = new DataSet();
dt.Fill(ds); //填充数据集
DataRow DR = null;
DR = ds.Tables[0].NewRow();
DR.BeginEdit();
DR["Title_1"] = Title_1;
DR["Title_2"] = Title_2;
DR["Title_3"] = Title_3;
DR["Title_4"] = Title_4;
DR.EndEdit();
ds.Tables[0].Rows.Add(DR);
dt.Update(ds);
ds.Dispose();
dt.Dispose();
用SqlDataAdapter向数据库添加数据
最新推荐文章于 2023-07-19 14:56:35 发布