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

Question

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:

Answer 1

If your first form inserts to IP_Spools (not to RejReason) and IDTextbox is the ID of new row, then maybe try another statement:

string s = "update IP_Spools set RejectReason1 = @p1, RejectReason2 = @p2, RejectReason3 = @p3 where SpoolId = @p4";

Answer 2

Thank you so much it helped