private void button2_Click(object sender, EventArgs e) { this.Hide(); var fr = new ManageCat(); fr.Show(); }
private void button2_Click(object sender, EventArgs e) { string connectionstring; SqlConnection conn; connectionstring = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\jak78\Desktop\OnlineFoodOrder\OnlineFoodOrder\Database1.mdf;Integrated Security=True"; conn = new SqlConnection(connectionstring); try { string query = "DELETE FROM Category where catid=@cid"; SqlCommand cmd = new SqlCommand(query, conn); cmd.Parameters.AddWithValue("@cid", textBox4.Text); conn.Open(); int j = cmd.ExecuteNonQuery(); if (j == -1) { MessageBox.Show("Error!"); } else { MessageBox.Show("Category deleted successfully"); this.Hide(); var fr = new ManageCat(); fr.Show(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } }