private void dataGridViewReturnbook_CellClick(object sender, DataGridViewCellEventArgs e) { // seting return ook table value to lables try { String issueid; issueid = dataGridViewReturnbook.SelectedCells[0].Value.ToString(); // issueid = labelissueid1.Text; MemberDB obj = new MemberDB(); SqlDataReader dr = obj.getissuebookdetil(issueid); DataTable dt = new DataTable(); dt.Columns.Add("IssueID"); dt.Columns.Add("BookName"); dt.Columns.Add("IssueDate"); dt.Columns.Add("ReturnDate"); while (dr.Read()) { DataRow row = dt.NewRow(); labelissueid1.Text = dr["IssueID"].ToString(); labelbookname.Text = dr["BookName"].ToString(); labelissuedate.Text = dr["IssueDate"].ToString(); labelReturndate.Text = dr["ReturnDate"].ToString(); dt.Rows.Add(row); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
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); } }