private void addNewBookToolStripMenuItem1_Click(object sender, EventArgs e) { frmaddnewbook obj = new frmaddnewbook(); bool frmpresent = CheckForDuplicationForm(obj); if (frmpresent) { return; } else if (!frmpresent) { obj.MdiParent = this; obj.Show(); } }
private void button1_Click(object sender, EventArgs e) { string query = "select Registration_Id from tbl_registration where Registration_Id='" + txtregid.Text + "'"; try { con.DBOpenConnection(); SqlCommand cmd = new SqlCommand(query, DBConnect.DBConnection); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { //while (dr.Read()) //{ groupBox2.Visible = true; txtregid.ReadOnly = true; string NQuery = "select * from tbl_BooksInfo where Status='True'"; try { dr.Close(); con.OpenConnection(); SqlCommand ncmd = new SqlCommand(NQuery, DBConnect.Connection); SqlDataReader Ndr = cmd.ExecuteReader(); if (Ndr.HasRows) { //cbbookname.Items.Add("Select Book"); ////cbauthor.Items.Add("Select Author"); //cbedition.Items.Add("Select Edition"); //cbedition.SelectedText = "Select Edition"; //cbbookname.SelectedText = "Select Book"; ////cbauthor.SelectedText = "Select Author"; Ndr.Close(); //try //{ string myquery = "select distinct BookName from tbl_BooksInfo where Status='True' order by BookName"; //con.OpenConnection(); SqlDataAdapter adap = new SqlDataAdapter(myquery, DBConnect.Connection); DataTable newdt = new DataTable(); adap.Fill(newdt); DataRow row = newdt.NewRow(); row["BookName"] = "Select Book"; newdt.Rows.InsertAt(row, 0); cbbookname.DataSource = newdt; cbbookname.DisplayMember = "BookName"; cbbookname.ValueMember = "BookName"; //} //catch (SqlException ex) //{ // MessageBox.Show(ex.Message); //} //finally //{ // con.CloseConnection(); //} } else { MessageBox.Show("No Book Available \nPlease Add Book First"); frmaddnewbook obj = new frmaddnewbook(); obj.Show(); this.Dispose(); } } catch (SqlException ex) { MessageBox.Show(ex.Message); } finally { con.CloseConnection(); } //} } else { lblerror.Text = "Record Not Found \nPlease Register student First"; lblerror.ForeColor = Color.Red; txtregid.Focus(); } } catch (SqlException ex) { MessageBox.Show(ex.Message); } finally { con.DBCloseConnection(); } }