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 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;
}
private void main_category_query()
{
sql_object sql_obj = new sql_object();
SqlDataReader dataReader = sql_obj.get_category_query();
main_category.DataSource = dataReader;
main_category.DataValueField = "id";
main_category.DataTextField = "Category";
main_category.DataBind();
sql_obj.close_connection();
}
private void sub_Category_query(int IdCategory)
{
int IdCatLoc = IdCategory;
sql_object sql_obj = new sql_object();
if (IdCategory == 0)
IdCatLoc = sql_obj.GetFirstCat();
SqlDataReader dataReader = sql_obj.get_sub_cat_query(IdCatLoc);
sub_category.DataSource = dataReader;
sub_category.DataValueField = "id";
sub_category.DataTextField = "Cat_sub";
sub_category.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();
}
}