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

[Guest Ravi Kumar12233]

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:

 

 

 

 

Continue reading...