用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();