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);
}
}
