public void LoadDataToGrid() //Use DAL,Class Create Const,Enum { try { SqlCommand cmd = new SqlCommand("spLoadBookDataToGrid", con.ActiveCon()); SqlDataAdapter ad = new SqlDataAdapter(cmd); // ad.Fill(dt); for (int i = 0; i < dt.Rows.Count; i++) { dataGridView1.Rows.Add(); dataGridView1["BookId", i].Value = dt.Rows[i]["Book_Id"]; dataGridView1["BookName", i].Value = dt.Rows[i]["Book_Name"]; dataGridView1["BookStatus", i].Value = dt.Rows[i]["Book_Status"]; } } catch (Exception ex) { BookMasterBL objbook = new BookMasterBL(); objbook.InserToErrorLog("Book", ex.Message.ToString(), "LoadDataToGrid"); } finally { con.CloseCon(); } }
private void btnSave_Click(object sender, EventArgs e) { BookMasterBL objbook = new BookMasterBL(); try { BookMaster b = new BookMaster(); //b--->>bookmaster b.BookId = Convert.ToInt32(txtBookId.Text); b.BookName = txtBookName.Text; b.BookStatus = Convert.ToString(cmbStatus.SelectedItem); objbook.SaveBookMasterdata(b); MessageBox.Show("Record is Saved..."); } catch (Exception ex) { MessageBox.Show("Record is Not Saved..."); objbook.InserToErrorLog("Book", ex.Message.ToString(), "btnSave_Click"); } finally { } }
private void btnDelete_Click(object sender, EventArgs e) { BookMasterBL objbook = new BookMasterBL(); try { BookMaster b = new BookMaster(); b.BookId = Convert.ToInt32(txtBookId.Text); objbook.DeleteBookMasterData(b); MessageBox.Show("Record is Deleted..."); } catch (Exception ex) { MessageBox.Show("Record is Not Deleted..."); objbook.InserToErrorLog("Book", ex.Message.ToString(), "btnDelete_Click"); } }
public void LoadBookId() { int count = 0; try { SqlCommand cmd = new SqlCommand("spCntBookRecords", con.ActiveCon()); count = Convert.ToInt32(cmd.ExecuteScalar()); txtBookId.Text = Convert.ToString(++count); } catch (Exception ex) { BookMasterBL objbook = new BookMasterBL(); objbook.InserToErrorLog("Book", ex.Message.ToString(), "LoadBookId"); } finally { con.CloseCon(); } }