insert不能写入数据库。
请看代码。protected void Button2_Click(object sender, EventArgs e)
{
SqlConnection conn = zong.createcon();
conn.Open();
string str1 = "select xm,gh,jz,lb from bsperson";
SqlDataAdapter sda1 = new SqlDataAdapter(str1, conn);
DataSet ds1 = new DataSet();
sda1.Fill(ds1);
GridView1.DataSource = ds1;
GridView1.DataBind();
for(int i =0;i<GridView1.Rows.Count;i++)
{
string value1 = (this.GridView1.Rows[i].FindControl("TextBox1") as TextBox).Text.Trim();
DropDownList ddl = (this.GridView1.Rows[i].FindControl("DropDownList") as DropDownList);
if (ddl.SelectedValue != "")
{
string value2 = ddl.SelectedValue;
}
}
SqlConnection con = zong.createcon();
string sql = "insert into qqyy (xm,gh,jz,lb) select (xm,gh,jz,lb) from bsperson ";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
con.Close();
DataBind();
}
用bspersony调了xm,gh,jz,lb这几个数。
现在需要写到表B中就不行了 --------------------编程问答-------------------- insert into qqyy (xm,gh,jz,lb) select (xm,gh,jz,lb) from bsperson
没这样写过。
那你的循环干嘛用的
你不取循环里的值来进行插入么 --------------------编程问答-------------------- string sql = "insert into qqyy (xm,gh,jz,lb) select xm,gh,jz,lb from bsperson ";
select 多个字段,不能加括号的吧 --------------------编程问答-------------------- 错误1.
insert into qqyy (xm,gh,jz,lb) select (xm,gh,jz,lb) from bsperson
语句不对 应去掉select语句中的括弧
2.根据逻辑,你似乎想把界面上的一些数据提交到bsperson,但是又没有调用SqlDataAdapter的update方法将数据集中的数据写入到数据库。 --------------------编程问答-------------------- 不想看了 自己卸载掉
补充:.NET技术 , ASP.NET