private void save_Click(object sender, EventArgs e) { try { String con = ConfigurationManager.ConnectionStrings["WindowsFormsApplication1.Properties.Settings.librarayManagementConnectionString"].ConnectionString; SqlConnection sqlCon = new SqlConnection(con); sqlCon.Open(); String query = "UPDATE book_registration SET book_name ='" + book_name.Text + "',author_name ='" + author_name.Text + "',publisher ='" + publisher.Text + "',publish_year ='" + pub_year.Text + "',isbn_no ='" + isbn.Text + "',pages ='" + page.Text + "',edition ='" + edition.Text + "' ,price ='" + price.Text + "',book_type ='" + book_type.Text + "',rank ='" + rank.Text + "',department ='" + department.Text + "',[cover_image]=@cover WHERE book_id='" + book_id.Text + "'"; SqlCommand cmd = new SqlCommand(query, sqlCon); SqlParameter param = cmd.Parameters.AddWithValue("@cover", img); param.DbType = DbType.Binary; cmd.ExecuteNonQuery(); MessageBox.Show("Record has been Saved"); sqlCon.Close(); view_book vb = (view_book)Application.OpenForms["view_book"]; vb.loadbook(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void viewAllBookToolStripMenuItem_Click(object sender, EventArgs e) { view_book viewBook = new view_book(account); viewBook.Show(); }