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

  • Thread starter Thread starter Ravi Kumar12233
  • Start date Start date
R

Ravi Kumar12233

Guest
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:

2Obur.png


PwI4y.png

Continue reading...
 
Back
Top