注册 登录
编程论坛 ASP.NET技术论坛

哪出错了,修改不过来...?

swalia 发布于 2008-04-09 23:13, 816 次点击
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
        strcon.Open();
        string Phone = this.Phone.Text.ToString();
        string UserName = this.UserName.Text.ToString();
        string Sex = this.Sex.Text.ToString();
        string Tel = this.Tel.Text.ToString();
        string CidType = this.CidType.Text.ToString();
        string Cid = this.Cid.Text.ToString();
        string Zip = this.Zip.Text.ToString();
        string Addess = this.addess.Text.ToString();
        SqlCommand scd = new SqlCommand("update tb_User set Phone='" + Phone + "',UserName='" + UserName + "',Sex='" + Sex + "',Tel='" + Tel + "',CidType='" + CidType + "',Cid='" + Cid + "',Zip='" + Zip + "',Addess='" + Addess + "' where Userid='" + Session["Userid"].ToString() + "'", strcon);
        scd.ExecuteNonQuery();
        Response.Write("<script lanuage=javascript>alert('修改成功!');location='../Member/ManageMember.aspx'</script>");
    }
提交后原数据没办法修改过来.
1 回复
#2
残影留香2008-04-12 11:20
"update tb_User set Phone='" + Phone + "',UserName='" + UserName + "',Sex='" + Sex + "',Tel='" + Tel + "',CidType='" + CidType + "',Cid='" + Cid + "',Zip='" + Zip + "',Addess='" + Addess + "' where Userid=" + Userid

这样试一下!

[[it] 本帖最后由 残影留香 于 2008-4-12 11:23 编辑 [/it]]
1