protected void Button1_Click(object sender, EventArgs e)
{
//方法1
//DataAccess.Class1 dac = new DataAccess.Class1();
//string sql =string.Format("insert into conntect(UserName,Sex,QQ,Email,Talk) values('{0}','{1}','{2}','{3}','{4}')",this.TextBox1.Text,this.TextBox2.Text,this.TextBox3.Text,this.TextBox4.Text,this.TextBox5.Text);
//dac.ExecuteSql(sql); //方法2
DataAccess.Class1 dac = new DataAccess.Class1();
DataSet ds = dac.getConnect();
DataRow dr = ds.Tables[0].NewRow();
dr["UserName"] = this.TextBox1.Text;
dr["Sex"] = int.Parse(this.TextBox2.Text);
dr["QQ"] = Convert.ToInt16(this.TextBox3.Text.Trim());
dr["Email"] = this.TextBox4.Text;
dr["Talk"] = this.TextBox5.Text;
ds.Tables[0].Rows.Add(dr); ds.Tables[0].NewRow();
dr["UserName"] = "UserName1";
dr["Sex"] = "1";
dr["QQ"] = "123143";
dr["Email"] = "UserName22";
dr["Talk"] = "UserName11";
ds.Tables[0].Rows.Add(dr); dac.updataConntect(ds);
bindData(); }问题. 关于方法2 ,我想在表中连续插入2条记录..使用了两次
ds.Tables[0].Rows.Add(dr);
但是报错了, 不知道什么回事, 把第二条数据注释, 可以正常运行, 把第一条数据和第二条数据头部的 ds.Tables[0].NewRow();一起注释掉, 也能正常插入,不知道是什么回事? 看视频是可以正常插入,请各位帮我找找问题的根源!谢谢
{
//方法1
//DataAccess.Class1 dac = new DataAccess.Class1();
//string sql =string.Format("insert into conntect(UserName,Sex,QQ,Email,Talk) values('{0}','{1}','{2}','{3}','{4}')",this.TextBox1.Text,this.TextBox2.Text,this.TextBox3.Text,this.TextBox4.Text,this.TextBox5.Text);
//dac.ExecuteSql(sql); //方法2
DataAccess.Class1 dac = new DataAccess.Class1();
DataSet ds = dac.getConnect();
DataRow dr = ds.Tables[0].NewRow();
dr["UserName"] = this.TextBox1.Text;
dr["Sex"] = int.Parse(this.TextBox2.Text);
dr["QQ"] = Convert.ToInt16(this.TextBox3.Text.Trim());
dr["Email"] = this.TextBox4.Text;
dr["Talk"] = this.TextBox5.Text;
ds.Tables[0].Rows.Add(dr); ds.Tables[0].NewRow();
dr["UserName"] = "UserName1";
dr["Sex"] = "1";
dr["QQ"] = "123143";
dr["Email"] = "UserName22";
dr["Talk"] = "UserName11";
ds.Tables[0].Rows.Add(dr); dac.updataConntect(ds);
bindData(); }问题. 关于方法2 ,我想在表中连续插入2条记录..使用了两次
ds.Tables[0].Rows.Add(dr);
但是报错了, 不知道什么回事, 把第二条数据注释, 可以正常运行, 把第一条数据和第二条数据头部的 ds.Tables[0].NewRow();一起注释掉, 也能正常插入,不知道是什么回事? 看视频是可以正常插入,请各位帮我找找问题的根源!谢谢
DataAccess.Class1 dac = new DataAccess.Class1();
DataSet ds = dac.getConnect();
DataRow dr = ds.Tables[0].NewRow();
dr["UserName"] = this.TextBox1.Text;
dr["Sex"] = int.Parse(this.TextBox2.Text);
dr["QQ"] = Convert.ToInt16(this.TextBox3.Text.Trim());
dr["Email"] = this.TextBox4.Text;
dr["Talk"] = this.TextBox5.Text;
ds.Tables[0].Rows.Add(dr); dr = ds.Tables[0].NewRow();
dr["UserName"] = "UserName1";
dr["Sex"] = "1";
dr["QQ"] = "123143";
dr["Email"] = "UserName22";
dr["Talk"] = "UserName11";
ds.Tables[0].Rows.Add(dr);