protected void gridview_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        DataTable dt = Select_Logic.load_order_remaining_amount();

        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (Session["username"] == "")
     {
         Response.Redirect("LoginPage.aspx");
     }
     else
     {
         DataTable dt = Select_Logic.load_order_remaining_amount();
         GridView1.DataSource = dt;
         GridView1.DataBind();
     }
 }