Click here to Skip to main content
15,394,479 members
Home / Discussions / C#
   

C#

 
GeneralRe: mysql delete code error Pin
Dave Kreskowiak19-Mar-22 17:54
mveDave Kreskowiak19-Mar-22 17:54 
GeneralRe: mysql delete code error Pin
N Mohamed rafi19-Mar-22 18:01
MemberN Mohamed rafi19-Mar-22 18:01 
GeneralRe: mysql delete code error Pin
Dave Kreskowiak19-Mar-22 18:39
mveDave Kreskowiak19-Mar-22 18:39 
GeneralRe: mysql delete code error Pin
N Mohamed rafi19-Mar-22 19:48
MemberN Mohamed rafi19-Mar-22 19:48 
AnswerRe: mysql delete code error Pin
OriginalGriff19-Mar-22 21:04
mveOriginalGriff19-Mar-22 21:04 
GeneralRe: mysql delete code error Pin
N Mohamed rafi19-Mar-22 23:05
MemberN Mohamed rafi19-Mar-22 23:05 
GeneralRe: mysql delete code error Pin
OriginalGriff19-Mar-22 23:35
mveOriginalGriff19-Mar-22 23:35 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 0:02
MemberN Mohamed rafi20-Mar-22 0:02 
Sir, i have heard and tried what you said, the below coding is here; if i run coding it shows record deleted successfully but still the record not deleting from database

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Configuration;
using System.Windows.Forms;
using System.Data;
using System.Drawing;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;
using System.Data.SqlClient;

private void DisplayData()
{
string connectionString;
MySqlConnection cnn;
connectionString = @"Data Source=localhost;Initial Catalog=testDB;User ID=root;Password=mysql";
cnn = new MySqlConnection(connectionString);
DataTable dt = new DataTable();
adapt = new MySqlDataAdapter("select * from employee", cnn);
adapt.Fill(dt);
dataGridView1.DataSource = dt;
cnn.Open();
cnn.Close();
}
private void ClearData()
{
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
ID = 0;
}
private void button9_Click(object sender, EventArgs e)
{
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);
string id = textBox6.Text;
string name = textBox7.Text;
string salary = textBox8.Text;
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
string query = "DELETE FROM employee WHERE employee_id=@employee_id AND employee_name=@employee_name AND employee_salary-@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();
DisplayData();
ClearData();
}
}
else
{
MessageBox.Show("Please Select Record to Delete");
}
}
GeneralRe: mysql delete code error Pin
OriginalGriff20-Mar-22 0:37
mveOriginalGriff20-Mar-22 0:37 
GeneralRe: mysql delete code error Pin
Richard MacCutchan20-Mar-22 2:13
mveRichard MacCutchan20-Mar-22 2:13 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 2:21
MemberN Mohamed rafi20-Mar-22 2:21 
GeneralRe: mysql delete code error Pin
Richard MacCutchan20-Mar-22 2:25
mveRichard MacCutchan20-Mar-22 2:25 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 1:58
MemberN Mohamed rafi20-Mar-22 1:58 
GeneralRe: mysql delete code error Pin
OriginalGriff20-Mar-22 2:33
mveOriginalGriff20-Mar-22 2:33 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 2:46
MemberN Mohamed rafi20-Mar-22 2:46 
GeneralRe: mysql delete code error Pin
OriginalGriff20-Mar-22 3:26
mveOriginalGriff20-Mar-22 3:26 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 3:46
MemberN Mohamed rafi20-Mar-22 3:46 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 2:47
MemberN Mohamed rafi20-Mar-22 2:47 
GeneralRe: mysql delete code error Pin
N Mohamed rafi20-Mar-22 3:09
MemberN Mohamed rafi20-Mar-22 3:09 
GeneralRe: mysql delete code error Pin
Dave Kreskowiak20-Mar-22 4:51
mveDave Kreskowiak20-Mar-22 4:51 
GeneralConnection string Error VS to Mysql Pin
N Mohamed rafi18-Mar-22 20:32
MemberN Mohamed rafi18-Mar-22 20:32 
GeneralRe: Connection string Error VS to Mysql Pin
OriginalGriff18-Mar-22 21:04
mveOriginalGriff18-Mar-22 21:04 
GeneralRe: Connection string Error VS to Mysql Pin
N Mohamed rafi18-Mar-22 21:08
MemberN Mohamed rafi18-Mar-22 21:08 
GeneralRe: Connection string Error VS to Mysql Pin
OriginalGriff18-Mar-22 21:17
mveOriginalGriff18-Mar-22 21:17 
GeneralRe: Connection string Error VS to Mysql Pin
N Mohamed rafi18-Mar-22 21:27
MemberN Mohamed rafi18-Mar-22 21:27 

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.