protected void Button1_Click(object sender, EventArgs e)
{
//存入订单信息表
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dyConnectionString"].ToString());
String sql = "insert 订单信息表(userid,address,tel,status) values(" + TextBox2.Text + ",'" + TextBox3.Text + "','" + TextBox4.Text + "','未处理')";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
//查询出来生成的订单号
sql = "select top 1 id from 订单信息表 where userid=" + TextBox2.Text + " order by id desc";
cmd.CommandText = sql;
int orderid = (int)cmd.ExecuteScalar();
//存入订单明细表
foreach (GridViewRow r in GridView1.Rows)
{
if (((CheckBox)r.FindControl("CheckBox1")).Checked)
{
cmd.CommandText = "insert 订单明细表 values(" + orderid + "," + r.Cells[1].Text + "," + r.Cells[5].Text + ")";
cmd.ExecuteNonQuery();
}
}
conn.Close();
//提示订单生产完毕!
}
}
怎么回事?