host.UpdataDemo1(xm.Text.Trim(), dh.Text.Trim(), dz.Text.Trim(), zsheng.Text.Trim(), zshi.Text.Trim(), zqu.Text.Trim(), Session["dx"].ToString().Trim(), Request.QueryString["id"]);
Response.Write("<script>alert('编辑成功');window.parent.location.reload();</script>");
string constr = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("Usp_UpdateSsq", con))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
var parameters = new SqlParameter[] {
new SqlParameter("@sheng",sheng),
new SqlParameter("@shi",shi),
new SqlParameter("@qu",qu),
new SqlParameter("@dz",dz),
new SqlParameter("@dh",dh),
new SqlParameter("@xm",xm),
new SqlParameter("@xqah",xqah),
new SqlParameter("@id",id)
};
cmd.Parameters.AddRange(parameters);
con.Open();
int r = cmd.ExecuteNonQuery();
}
con.Close();
}
return 0;
![img](https://img-mid.csdnimg.cn/release/static/image/mid/ask/977032488436114.png?x-oss-process=image/auto-orient,1/resize,w_320,m_lfit)