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(); }