private void btnDelete_Click(object sender, EventArgs e) { DatabaseLibrary Obj = new DatabaseLibrary(); DialogResult Diag = new DialogResult(); Diag = MessageBox.Show("Do you want to Remove this data?", "Confirmation", MessageBoxButtons.YesNo); if (Diag == DialogResult.Yes) { Obj.Connection(); Obj.Delete(@"DELETE FROM tblndc WHERE TripNum='" + int.Parse(lblTrip.Text) + "'"); Obj.Delete(@"DELETE FROM tbldocu WHERE TripNum='" + int.Parse(lblTrip.Text) + "'"); Obj.Delete(@"DELETE FROM tblsd WHERE TripNum='" + int.Parse(lblTrip.Text) + "'"); Obj.CloseConnection(); frm1.RefreshRDD(); this.Close(); } else if (Diag == DialogResult.No) { } }
private void listView1_DoubleClick(object sender, EventArgs e) { DatabaseLibrary Obj = new DatabaseLibrary(); DialogResult Diag = new DialogResult(); Diag = MessageBox.Show("Do you want to Remove this data?", "Confirmation", MessageBoxButtons.YesNo); if (Diag == DialogResult.Yes) { Obj.Connection(); Obj.Delete(@"DELETE FROM tblaudit WHERE AuditNum='" + int.Parse(lblAuditNum.Text) + "'"); Obj.CloseConnection(); FillAuditData(); } else if (Diag == DialogResult.No) { FillAuditData(); } }
private void btnDelete_Click(object sender, EventArgs e) { DialogResult dr = MessageBox.Show(this, "Are you sure to Delete this data?", "Confimation", MessageBoxButtons.YesNo, MessageBoxIcon.Stop); if (dr == DialogResult.Yes) { Obj.Connection(); Obj.Delete(@"DELETE FROM tbltruck WHERE BodyNum = '" + lblBNum.Text + "'"); Obj.CloseConnection(); btnDelete.Visible = false; FillListView(); } else { btnDelete.Visible = false; FillListView(); } }
private void listView1_DoubleClick(object sender, EventArgs e) { DialogResult Diag = new DialogResult(); Diag = MessageBox.Show("Do you want to Remove this data?", "Confirmation", MessageBoxButtons.YesNo); if (Diag == DialogResult.Yes) { Obj.Connection(); Obj.Delete(@"DELETE FROM tbluser WHERE UserName='******'"); Obj.CloseConnection(); txtUser.Text = string.Empty; txtPass.Text = string.Empty; lblUserPost.Text = string.Empty; FillListData(); } else if (Diag == DialogResult.No) { FillListData(); } }