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