protected void Page_Load(object sender, EventArgs e)
{
findUser();
if (!IsPostBack)
{
gridVIEWData();
GridViewback.DataSource = dt1;
GridViewback.DataBind();
}
}
protected void findback_Click(object sender, EventArgs e)
{
con.Open();
string sqlcus = "SELECT FirstName FROM Customer WHERE UserID ='" + UserIDback.Text + "'";
SqlCommand cmdcus = new SqlCommand(sqlcus, con);
SqlDataReader readercus = cmdcus.ExecuteReader();
readercus.Read();
namecus.Text = Convert.ToString(readercus[0]);
string sqladmin = "SELECT BookID,NameBook FROM Book WHERE BookID = '" + BookIDback.Text + "' ";
SqlCommand cmdAdmin = new SqlCommand(sqladmin, con);
SqlDataReader readerAdmin = cmdAdmin.ExecuteReader();
readerAdmin.Read();
if (readerAdmin.HasRows)
{
//ใส่ข้อมูลหนังสือในตาราง
//Label1.Text = readerAdmin[1].ToString();
//if (Session["dtInSession"] != null)
// dt1 = (DataTable)Session["dtInSession"]; //Getting datatable from session
//Int32 total = Convert.ToInt32(txt_quantity.Text) * Convert.ToInt32(txt_price.Text);
//DataRow dr = dt1.NewRow();
//dr["BookID"] = readerAdmin[0].ToString();
//dr["NameBook"] = readerAdmin[1].ToString();
//dr["totalPrice"] = total;
//dt1.Rows.Add(dr);
/* Session["dtInSession"] = dt1; */ //Saving Datatable To Session
GridViewback.DataSource = readerAdmin;
GridViewback.DataBind();
readerAdmin.Close();
}
con.Close();
}
