private void NAddStaffBtn_Click(object sender, EventArgs e) { LibrarySearchBook lsbook = new LibrarySearchBook(); this.Hide(); lsbook.ShowDialog(); }
private void Button2_Click(object sender, EventArgs e) { i = Convert.ToInt32(dataGridView1.SelectedCells[0].Value.ToString()); try { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "update books_info set books_name='" + textBox2.Text + "',books_isbn='" + textBox3.Text + "',books_author='" + textBox4.Text + "',books_edition='" + textBox5.Text + "',books_publisher='" + textBox6.Text + "',books_quantity='" + textBox7.Text + "'where id =" + i + ""; cmd.ExecuteNonQuery(); con.Close(); display_books(); MessageBox.Show("Record updated Successfully"); panel4.Visible = false; LibrarySearchBook lib = new LibrarySearchBook(); this.Hide(); lib.ShowDialog(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Button2_Click(object sender, EventArgs e) { LibrarySearchBook libraryAddBook = new LibrarySearchBook(); this.Hide(); libraryAddBook.ShowDialog(); }
private void Button3_Click(object sender, EventArgs e) { i = Convert.ToInt32(dataGridView1.SelectedCells[0].Value.ToString()); con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "delete from books_info where Id=" + i + ""; cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("Record Deleted Successfully"); LibrarySearchBook lib = new LibrarySearchBook(); this.Hide(); lib.ShowDialog(); }