private void button2_Click(object sender, EventArgs e)
{
string Fname, Lname, contact;
double gpa;
Fname = textBox2.Text;
Lname = textBox3.Text;
contact = textBox5.Text;
gpa = Convert.ToDouble(textBox4.Text);
try
{
Sql_Db_Connection connection = new Sql_Db_Connection(); // my db class
string query = "DELETE FROM crud_table WHERE ID = '" + textBox1.Text + "' ";
if (connection.insert_query(query))
{
MessageBox.Show("Data Deleted Successfully");
}
else
{
MessageBox.Show("Data could not be deleted");
}
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
string Id, Fname, Lname, contact;
double gpa;
Id = textBox5.Text;
Fname = textBox4.Text;
Lname = textBox3.Text;
contact = textBox1.Text;
gpa = Convert.ToDouble(textBox2.Text);
Sql_Db_Connection connection = new Sql_Db_Connection(); // my db class
string query = "INSERT INTO Crud_Table VALUES('" + Id + "','" + Fname + "','" + Lname + "','" + gpa + "','" +
contact + "') ";
if (connection.insert_query(query))
{
MessageBox.Show("Data Inserted Successfully");
}
}
private void button1_Click(object sender, EventArgs e)
{
string Fname, Lname, contact;
double gpa;
Fname = textBox2.Text;
Lname = textBox3.Text;
contact = textBox5.Text;
gpa = Convert.ToDouble(textBox4.Text);
try
{
Sql_Db_Connection connection = new Sql_Db_Connection(); // my db class
string query = "UPDATE crud_table SET Fname='" + Fname + "' , Lname = '" + Lname + "' , GPA = '" + gpa + "' , Contact ='" + contact + "' WHERE ID = '" + textBox1.Text + "' ";
MessageBox.Show(query);
if (connection.insert_query(query))
{
MessageBox.Show("Data Updated Successfully");
}
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
