protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (Session["user"] != null)
                {
                    profile_lbl.Text = Session["user_name"].ToString();
                }

                bm.user_id = Session["user_id"].ToString();


                return_class rt = new return_class();

                SqlDataReader reader = rt.search_data_for_user(bm);

                if (reader.HasRows)
                {
                    History_Grid.DataSource = reader;
                    History_Grid.DataBind();
                }
                else
                {
                    this.msg_lbl.Text = "No history found";
                }
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (Session["user"] != null)
                {
                    profile_lbl.Text = Session["user_name"].ToString();
                }

                bm.user_id = Session["user_id"].ToString();

                
                return_class rt = new return_class();
                
                SqlDataReader reader = rt.search_data_for_user(bm);

                if (reader.HasRows)
                {
                    History_Grid.DataSource = reader;
                    History_Grid.DataBind();
                }
                else
                {
                    this.msg_lbl.Text = "No history found";
                }


            }
        }
        protected void databinding(string key)
        {
            return_class rt = new return_class();
            SqlDataReader rdr = rt.search_id_info(key);

            SqlDataReader reader = rt.search_borrow_tab(key);


            if (rdr.HasRows)
            {
                while (rdr.Read())
                {
                    this.name_lbl.Text = rdr.GetString(2).ToString();
                    this.ID_lbl.Text = rdr.GetString(1).ToString();
                    this.acc_lbl.Text = rdr.GetString(5).ToString();
                }
            }

            result_grid.DataSource = reader;
            result_grid.DataBind();
        }
        protected void databinding(string key)
        {
            return_class  rt  = new return_class();
            SqlDataReader rdr = rt.search_id_info(key);

            SqlDataReader reader = rt.search_borrow_tab(key);


            if (rdr.HasRows)
            {
                while (rdr.Read())
                {
                    this.name_lbl.Text = rdr.GetString(2).ToString();
                    this.ID_lbl.Text   = rdr.GetString(1).ToString();
                    this.acc_lbl.Text  = rdr.GetString(5).ToString();
                }
            }

            result_grid.DataSource = reader;
            result_grid.DataBind();
        }