Click here to Skip to main content
15,562,256 members
Home / Discussions / C#
   

C#

 
GeneralRe: Mysql Update Query Error Pin
OriginalGriff21-Mar-22 8:34
mvaOriginalGriff21-Mar-22 8:34 
GeneralRe: Mysql Update Query Error Pin
Dave Kreskowiak20-Mar-22 11:49
mveDave Kreskowiak20-Mar-22 11:49 
GeneralRe: Mysql Update Query Error Pin
N Mohamed rafi20-Mar-22 19:09
N Mohamed rafi20-Mar-22 19:09 
GeneralRe: Mysql Update Query Error Pin
Richard MacCutchan20-Mar-22 23:25
mveRichard MacCutchan20-Mar-22 23:25 
GeneralRe: Mysql Update Query Error Pin
N Mohamed rafi21-Mar-22 0:45
N Mohamed rafi21-Mar-22 0:45 
GeneralRe: Mysql Update Query Error Pin
Richard MacCutchan21-Mar-22 0:50
mveRichard MacCutchan21-Mar-22 0:50 
GeneralRe: Mysql Update Query Error Pin
Dave Kreskowiak21-Mar-22 3:29
mveDave Kreskowiak21-Mar-22 3:29 
Generalmysql delete code error Pin
N Mohamed rafi19-Mar-22 17:36
N Mohamed rafi19-Mar-22 17:36 
if (textBox6.Text!= "" && textBox7.Text != "" && textBox8.Text != "")
{
string connectionString;
MySqlConnection cnn;
connectionString = @"Data Source=localhost;Initial Catalog=testDB;User ID=root;Password=mysql";
cnn = new MySqlConnection(connectionString);
//cnn.Open();
//cnn.Close();
string id = textBox6.Text;
string name = textBox7.Text;
string salary = textBox8.Text;
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
string query = "delete employee where(@employee_id, @employee_name, @employee_salary)";
using (MySqlCommand cmd = new MySqlCommand(query))
{
cmd.Parameters.AddWithValue("@employee_id", id);
cmd.Parameters.AddWithValue("@employee_name", name);
cmd.Parameters.AddWithValue("@employee_salary", salary);
cmd.Connection = cnn;
cnn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Record Deleted Successfully");
cnn.Close();
}
}
else
{
MessageBox.Show("Please Select Record to Delete");
}
GeneralRe: mysql delete code error Pin
Dave Kreskowiak19-Mar-22 18:54
mveDave Kreskowiak19-Mar-22 18:54 
GeneralRe: mysql delete code error Pin
N Mohamed rafi19-Mar-22 19:01
N Mohamed rafi19-Mar-22 19:01 
GeneralRe: mysql delete code error Pin
Dave Kreskowiak19-Mar-22 19:39
mveDave Kreskowiak19-Mar-22 19:39 
GeneralRe: mysql delete code error Pin
N Mohamed rafi19-Mar-22 20:48
N Mohamed rafi19-Mar-22 20:48 
AnswerRe: mysql delete code error Pin
OriginalGriff19-Mar-22 22:04
mvaOriginalGriff19-Mar-22 22:04 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 0:05
N Mohamed rafi20-Mar-22 0:05 
GeneralRe: mysql delete code error Pin
OriginalGriff20-Mar-22 0:35
mvaOriginalGriff20-Mar-22 0:35 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 1:02
N Mohamed rafi20-Mar-22 1:02 
GeneralRe: mysql delete code error Pin
OriginalGriff20-Mar-22 1:37
mvaOriginalGriff20-Mar-22 1:37 
GeneralRe: mysql delete code error Pin
Richard MacCutchan20-Mar-22 3:13
mveRichard MacCutchan20-Mar-22 3:13 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 3:21
N Mohamed rafi20-Mar-22 3:21 
GeneralRe: mysql delete code error Pin
Richard MacCutchan20-Mar-22 3:25
mveRichard MacCutchan20-Mar-22 3:25 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 2:58
N Mohamed rafi20-Mar-22 2:58 
GeneralRe: mysql delete code error Pin
OriginalGriff20-Mar-22 3:33
mvaOriginalGriff20-Mar-22 3:33 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 3:46
N Mohamed rafi20-Mar-22 3:46 
GeneralRe: mysql delete code error Pin
OriginalGriff20-Mar-22 4:26
mvaOriginalGriff20-Mar-22 4:26 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 4:46
N Mohamed rafi20-Mar-22 4:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.