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