<pre>if (dt.Rows.Count > 0) { MySqlCommand cmd = new MySqlCommand("UPDATE `locations` SET `lname`=@loca, `laddress`=@addr, `ltelephone`=@tele WHERE 'lcode'=@lcode", myDb.getConnection); cmd.Parameters.Add("@loca", MySqlDbType.VarChar).Value = txtName.Text; cmd.Parameters.Add("@addr", MySqlDbType.VarChar).Value = txtAddress.Text; cmd.Parameters.Add("@tele", MySqlDbType.VarChar).Value = txtTel.Text; cmd.Parameters.Add("@lcode", MySqlDbType.VarChar).Value = lCode; myDb.openConnection(); cmd.ExecuteNonQuery(); // if (cmd.ExecuteNonQuery() == 1) // { myDb.closeConnection(); // } //else //{ // MessageBox.Show("Update Error"); //} }
ExecuteNonQuery
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)