CODEWITHSUNDEEP
c#sqlwinforms
qrttttt
qrttttt

Reputation: 103

No errors in the code, but no changes occur in the table when trying to update it

I'm trying to update my data in C# Win Form. I created a button "update", but whenever I run it, I don't see any changes in the table and any occurring errors

void insertdata() {
    cmd = connection.CreateCommand();
    cmd.CommandText = "SELECT * FROM airport";
    adapter.SelectCommand = cmd;
    table.Clear();
    adapter.Fill(table);
    dgv.DataSource = table;
}

private void button_update_Click(object sender, EventArgs e)
{
    cmd = connection.CreateCommand();
    cmd.CommandText = "UPDATE airport SET  p_name = '"+textBox2.Text+ "',p_age = '" + textBox3.Text + "', c_name = '" + textBox4.Text + "', date = '" + textBox5.Text + "', city_t = '" + textBox6.Text + "', city_f ='" + textBox7.Text + "', trip_num = '" + textBox8.Text + "', plane_type = '" + textBox9.Text+"' WHERE p_id = '"+textBox1+"'";
    cmd.ExecuteNonQuery();
    insertdata();
}

I've tried to add

connection.Open();
connection.Close();

However, I keep getting: "System.InvalidOperationException: "The connection was not closed. The connection is open."

Could there be any change in my code for updating the rows in the table, as whenever I run it I don't get any errors.

Upvotes: 2

Views: 276

Answers (1)

M. G.
M. G.

Reputation: 44

Please note the you wrote

WHERE p_id = '"+textBox1+"'

Instead of

WHERE p_id = '"+textBox1.Text+"'

Probably you don't have an ID that equals to the textBox...

Upvotes: 2

Related Questions