I can't delete a field from a database (using query) when the database is empty and it contains just the field that I want to delete.
con.Connection = con; con.Open(); com.CommandText = "DELETE FROM tabel1 WHERE b3='" + textBox1.Text + "';"; com.ExecuteNonQuery(); com.CommandText = "SELECT b3 FROM tabel1"; com.ExecuteNonQuery(); dr = com.ExecuteReader(); while (dr.Read()) { textBox1.Text = dr.GetValue(0).ToString(); } con.Close();
The idea is that after the code is executed, textBox1 has the same value (dose not receive the null value resulted from deletion)
Help!