protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
        {
            sql_object sql_obj = new sql_object();
            dataReader = sql_obj.get_offer_query();

            GridView1.DataSource = dataReader;
            GridView1.DataBind();
            sql_obj.close_connection();
        }
        protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
        {
            GridView1.EditIndex = e.NewEditIndex;
            sql_object sql_obj = new sql_object();
            dataReader = sql_obj.get_offer_query();

            GridView1.DataSource = dataReader;
            GridView1.DataBind();
            sql_obj.close_connection();
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                sql_object sql_obj = new sql_object();
                dataReader = sql_obj.get_offer_query();

                GridView1.DataSource = dataReader;
                GridView1.DataBind();
                sql_obj.close_connection();
            }
        }
        protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            GridView1.EditIndex = -1;
            sql_object sql_obj = new sql_object();
            dataReader = sql_obj.get_offer_query();

            GridView1.DataSource = dataReader;
            GridView1.DataBind();
            sql_obj.close_connection();
            //string test1 = GridView1.Rows[e.RowIndex].Cells[1].Text;
            //GridView1.EditIndex = -1;
        }