ข้ามไปที่เนื้อหาหลัก
Windows Dev Center
ลงชื่อเข้าใช้

 locked
saving data from 2nd form to the same master table in win form application RRS feed

  • คำถาม

  • I have two winforms where form 1 is used to enter data from first seven fields and other forms is used to enter for last three fields , where i have the table stored in MSSQL server ,Now when i try to save the last three fields i am getting below " invalid column error , but actually it is present in my sql table , i am very new to C# , kindly help me :

    Code for saving data in second form:

    private void Btnrejsave_Click(object sender, EventArgs e)
            {
    
                SqlConnection con = new SqlConnection(cs);
                SqlCommand cmd;
                con.Open();
                string s = "select * from RejReason where SpoolId = (@p4) insert into IP_Spools(RejectReason1,RejectReason2,RejectReason3) values(@p1,@p2,@p3)";
                cmd = new SqlCommand(s, con);
                cmd.Parameters.AddWithValue("@p1", rejectReason1ComboBox.Text);
                cmd.Parameters.AddWithValue("@p2", rejectReason2ComboBox.Text);
                cmd.Parameters.AddWithValue("@p3", rejectReason3ComboBox.Text);
                cmd.Parameters.AddWithValue("@p4", IDtextbox.Text);
                cmd.CommandType = CommandType.Text;
                int i = cmd.ExecuteNonQuery();
                con.Close();
    
            }

    And the error i am getting :

    {"Invalid column name 'SpoolId'."}

    but the server table has that column:


    Error

    12 ธันวาคม 2563 6:37

คำตอบ