用SqlDataAdapter向数据库添加数据

来源:互联网 发布:小甲鱼c语言怎么样 编辑:程序博客网 时间:2024/04/29 03:45
//摘要:用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();