首页 文章

我该怎么做才能解决这个错误？ [重复]

提问于
浏览 次
-3

这个问题在这里已有答案：

SqlCommand cmd = new SqlCommand();
        cmd.CommandText = "update member_reg_tbl set full_name='" + TextBox3.Text + "', gender ='" + RadioButtonList1.SelectedItem.Text + "', dob='" + TextBox4.Text + "', occupation='" + TextBox5.Text + "', education='" + TextBox6.Text + "', mobile_number='" + TextBox7.Text + "', landline_number='" + TextBox8.Text + "', country='" + DropDownList3.SelectedItem.Text + "', state='" + DropDownList4.SelectedItem.Text + "', district='" + TextBox14.Text + "', city='" + DropDownList6.SelectedItem.Text + "', email_id='" + TextBox9.Text + "', address='" + TextBox10.Text + "', password='" + TextBox12.Text + "', retype_password='" + TextBox13.Text + "',image='" + path + "' where user_id='"+Label22.Text+"'";
        cmd.Connection = con;
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
        Label21.Text = ""+Label22.Text+"Updated successfully..press cancel to login";
  • 错误 -

异常详细信息：System.NullReferenceException：未将对象引用设置为对象的实例 .

来源错误：

第102行：
第103行：SqlCommand cmd = new SqlCommand（）;第104行：cmd.CommandText = "update member_reg_tbl set full_name='" TextBox3.Text "', gender ='" RadioButtonList1.SelectedItem.Text "', dob='" TextBox4.Text "', occupation='" TextBox5.Text "', education='" TextBox6.Text "', mobile_number='" TextBox7.Text "', landline_number='" TextBox8.Text "', country='" DropDownList3.SelectedItem.Text "', state='" DropDownList4.SelectedItem.Text "', district='" TextBox14.Text "', city='" DropDownList6.SelectedItem.Text "', email_id='" TextBox9.Text "', address='" TextBox10.Text "',user_id='" Label22.Text "', password='" TextBox12.Text "', retype_password='" TextBox13.Text "',image='" path "' where user_id='" Label22.Text "'";第105行：cmd.Connection = con;第106行：con.Open（）;

c# asp.net sql-server

2 回答

  • 0

    调试代码并确保所有 TextBox ， RadioButtonList 和 DropDownList 都有值而不是null，

    using (SqlConnection con = new SqlConnection(connectionStr))
    {
        cmd = new SqlCommand("update member_reg_tbl full_name =@fullName, gender=@gender, dob =@dob, occupation=@oc,"+
        "education=@edu, mobile_number=@mobile, landline_number=@llNo, country =@country, state=@state"+
        "district=@dis, city=@city, email_id=@email, address=@address, password=@pass, retype_password=@rpass"+
        "image=@img where user_id =@uid", con);
        cmd.Parameters.AddWithValue("@full_name", TextBox3.Text);
        cmd.Parameters.AddWithValue("@gender", RadioButtonList1.SelectedItem.Text);
        cmd.Parameters.AddWithValue("@dob", TextBox4.Text);
        cmd.Parameters.AddWithValue("@oc", TextBox5.Tex);
        cmd.Parameters.AddWithValue("@edu", TextBox6.Tex);
        cmd.Parameters.AddWithValue("@mobile", TextBox7.Tex);
        cmd.Parameters.AddWithValue("@llNo", TextBox8.Tex);
        cmd.Parameters.AddWithValue("@country", DropDownList3.SelectedItem.Text);
        cmd.Parameters.AddWithValue("@state",  DropDownList4.SelectedItem.Text);
        cmd.Parameters.AddWithValue("@dis", TextBox14.Text);
        cmd.Parameters.AddWithValue("@city", DropDownList6.SelectedItem.Tex);
        cmd.Parameters.AddWithValue("@email", TextBox9.Tex);
        cmd.Parameters.AddWithValue("@address", TextBox10.Tex);
        cmd.Parameters.AddWithValue("@pass", TextBox12.Tex);
        cmd.Parameters.AddWithValue("@rpass", TextBox13.Tex);
        cmd.Parameters.AddWithValue("@img", path);
        cmd.Parameters.AddWithValue("@uid", Label22.Tex);

        con.Open();
        cmd.ExecuteNonQuery();

        con.Dispose();
        con.Close();

    }
    回复于
  • 0

    请确保 con 具有正确的连接字符串，并且选择了所有指定的 DropDownList 和 RadioButtonList ，它应该具有一些值 .

    回复于

相关问题