设置断点,i的值是0,代码如下 protected void Button1_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
sb.Append("update userbase set mc=@mc and zyyw=@zyyw and dwadress=@address and tel=@tel and homeip=@website and emailadr=@email and qyjj=@comapnyinfor where userid=@userid");
SqlParameter[] parm = {new SqlParameter("@mc",SqlDbType.Char,34),
new SqlParameter("@zyyw",SqlDbType.Char,50),
new SqlParameter("@address",SqlDbType.Char,49),
new SqlParameter("@tel",SqlDbType.Char,34),
new SqlParameter("@website",SqlDbType.Char,38),
new SqlParameter("@email",SqlDbType.Char,34),
new SqlParameter("@comapnyinfor",SqlDbType.Char,34),
new SqlParameter("@userid",SqlDbType.Char,34)};
parm[0].Value = dwmc.Text.ToString().Trim();
parm[1].Value = zyyw.Text.ToString().Trim();
parm[2].Value = address.Text.ToString().Trim();
parm[3].Value = tel.Text.ToString().Trim();
parm[4].Value = website.Text.ToString().Trim();
parm[5].Value = email.Text.ToString().Trim();
parm[6].Value = companyinfor.Text.ToString().Trim();
parm[7].Value = Session["username"];
int i=SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction,CommandType.Text,sb.ToString(),parm);
if (i > 0)
{
Response.Write("<script>alert('编辑成功');window.location.href='Introduce.aspx';</script>");
}
}
{
StringBuilder sb = new StringBuilder();
sb.Append("update userbase set mc=@mc and zyyw=@zyyw and dwadress=@address and tel=@tel and homeip=@website and emailadr=@email and qyjj=@comapnyinfor where userid=@userid");
SqlParameter[] parm = {new SqlParameter("@mc",SqlDbType.Char,34),
new SqlParameter("@zyyw",SqlDbType.Char,50),
new SqlParameter("@address",SqlDbType.Char,49),
new SqlParameter("@tel",SqlDbType.Char,34),
new SqlParameter("@website",SqlDbType.Char,38),
new SqlParameter("@email",SqlDbType.Char,34),
new SqlParameter("@comapnyinfor",SqlDbType.Char,34),
new SqlParameter("@userid",SqlDbType.Char,34)};
parm[0].Value = dwmc.Text.ToString().Trim();
parm[1].Value = zyyw.Text.ToString().Trim();
parm[2].Value = address.Text.ToString().Trim();
parm[3].Value = tel.Text.ToString().Trim();
parm[4].Value = website.Text.ToString().Trim();
parm[5].Value = email.Text.ToString().Trim();
parm[6].Value = companyinfor.Text.ToString().Trim();
parm[7].Value = Session["username"];
int i=SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction,CommandType.Text,sb.ToString(),parm);
if (i > 0)
{
Response.Write("<script>alert('编辑成功');window.location.href='Introduce.aspx';</script>");
}
}
sb.Append("update userbase set mc=@mc,zyyw=@zyyw ,dwadress=@address,tel=@tel ,homeip=@website ,emailadr=@email
,tel=@tel,homeip=@website,emailadr=@email,qyjj=@comapnyinfor where userid=@userid
("update userbase set mc=@mc , zyyw=@zyyw , dwadress=@address , tel=@tel and homeip=@website,emailadr=@email , qyjj=@comapnyinfor where userid=@userid");
这样不就ok了 不能用and连接滴 换成','
update 表
set column1 = 值1
,column2 = 值2
,column3 = 值3
where (condition)
SQL语句的问题。update userbase set mc=@mc , zyyw=@zyyw , dwadress=@address , tel=@tel , homeip=@website , emailadr=@email , qyjj=@comapnyinfor where userid=@userid