private void dataGridViewReturnbook_CellClick(object sender, DataGridViewCellEventArgs e) { try {// in this code use to selected book details(datagird view) set to text filed String issueid; issueid = dataGridViewReturnbook.SelectedCells[0].Value.ToString(); MemberDB obj = new MemberDB(); SqlDataReader dr = obj.getissuebookdetil(issueid); DataTable dt = new DataTable(); // dt.Columns.Add("IssueID"); dt.Columns.Add("BookName"); dt.Columns.Add("MemberName"); dt.Columns.Add("IssueDate"); dt.Columns.Add("ReturnDate"); dt.Columns.Add("MemberID"); while (dr.Read()) { DataRow row = dt.NewRow(); textBoxBookNAME.Text = dr["BookName"].ToString(); textBoxMemberName.Text = dr["BookName"].ToString(); textBoxIssueDate.Text = dr["IssueDate"].ToString(); textBoxReturndate.Text = dr["ReturnDate"].ToString(); textBoxMembeerid.Text = dr["MemberID"].ToString(); dt.Rows.Add(row); } } catch (Exception ex) { MessageBox.Show(ex.Message); } try { String Memberid; Memberid = dataGridViewReturnbook.SelectedCells[5].Value.ToString(); MemberDB obj = new MemberDB(); SqlDataReader dr = obj.getMemberInfo(Memberid); // DataTable dt = new DataTable(); while (dr.Read()) { textBoxEMAIL.Text = dr["Email"].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void MemberForm_Load(object sender, EventArgs e) { // get member id login form textBoxMemberid.Text = LoginForm.passingtext; //get member name try { MemberDB obj = new MemberDB(); SqlDataReader dtr = obj.getMemberInfo(textBoxMemberid.Text); SqlCommand cmd = new SqlCommand(); while (dtr.Read()) { textBoxMemberName.Text = dtr["FristName"].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } //auto genaratd id try { MemberDB obj = new MemberDB(); SqlDataReader DR = obj.getAutogenaratedid(); SqlCommand cmd = new SqlCommand(); while (DR.Read()) { textBoxIssueid.Text = DR["IssueID"].ToString(); } int i = int.Parse(textBoxIssueid.Text); i = i + 1; textBoxIssueid.Text = i.ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message); } // get booktble details try { MemberDB objt = new MemberDB(); SqlDataReader dr = objt.getbooklist(); DataTable dt = new DataTable(); dt.Columns.Add("ISBNNumber"); dt.Columns.Add("BookName"); dt.Columns.Add("Quantity"); dt.Columns.Add("Avalableqty"); while (dr.Read()) { DataRow row = dt.NewRow(); row["ISBNNumber"] = dr["ISBNNumber"]; row["BookName"] = dr["BookName"]; row["Quantity"] = dr["Quantity"]; row["Avalableqty"] = dr["Avalableqty"]; dt.Rows.Add(row); } dataGridViewBookname.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message); } //get issue table details try { MemberDB obj = new MemberDB(); SqlDataReader dr = obj.getissueBooktable(); DataTable dt = new DataTable(); dt.Columns.Add("IssueID"); dt.Columns.Add("BookName"); dt.Columns.Add("MemberName"); dt.Columns.Add("IssueDate"); dt.Columns.Add("ReturnDate"); dt.Columns.Add("MemberID"); while (dr.Read()) { DataRow row = dt.NewRow(); row["IssueID"] = dr["IssueID"]; row["BookName"] = dr["BookName"]; row["MemberName"] = dr["MemberName"]; row["IssueDate"] = dr["IssueDate"]; row["ReturnDate"] = dr["ReturnDate"]; row["MemberID"] = dr["MemberID"]; dt.Rows.Add(row); } dataGridViewReturnbook.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message); } }