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

ravi kumar 331 Reputation points

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;  
            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();  

And the error i am getting :

{"Invalid column name 'SpoolId'."}  

but the server table has that column:



Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,467 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
3,151 questions
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
8,180 questions
0 comments No comments
{count} votes

Accepted answer
  1. Viorel 94,416 Reputation points

    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";
    0 comments No comments

1 additional answer

Sort by: Oldest
  1. ravi kumar 331 Reputation points

    Thank you so much it helped

    0 comments No comments