protected void Page_Load(object sender, EventArgs e)
    {
        int        sid = Convert.ToInt32(Session["loginid"]);
        LibraryDAL dal = new LibraryDAL();

        gv_books.DataSource = dal.ShowIssuedBook(sid);
        gv_books.DataBind();
    }
    protected void gv_books_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gv_books.PageIndex = e.NewPageIndex;
        int        sid = Convert.ToInt32(Session["loginid"]);
        LibraryDAL dal = new LibraryDAL();

        gv_books.DataSource = dal.ShowIssuedBook(sid);
        gv_books.DataBind();
    }