public void LoadCategory()
{
DBEntities db = new DBEntities();
//var data = db.ProductCategories.Select(x => new
//{
// x.ProductCategoryID,
// x.Title
//});
var data = from mc in db.ProductMainCategories
from c in mc.ProductCategories
orderby mc.Position, c.Position
select new
{
c.ProductCategoryID,
Title = mc.Title + " - " + c.Title
};
DropDownList_Category.DataValueField = "ProductCategoryID";
DropDownList_Category.DataTextField = "Title";
DropDownList_Category.DataSource = data.ToList();
DropDownList_Category.DataBind();
//thêm 1 item mặc định trong dropdown
ListItem defaultitem = new ListItem("Mời chọn thể loại", string.Empty);
DropDownList_Category.Items.Insert(0, defaultitem);
}
private void DDLCategoryBind()
{
DataSet ds = new CategoryManager().GetAllList();
DataRow dr = ds.Tables[0].NewRow();
dr["category"] = "— —请选择— —";
ds.Tables[0].Rows.InsertAt(dr, 0);
DropDownList_Category.DataTextField = "category";
DropDownList_Category.DataValueField = "categoryID";
DropDownList_Category.DataSource = ds;
DropDownList_Category.DataBind();
}
public void LoadCategory()
{
DBEntities db = new DBEntities();
var data = db.AccountCategories.OrderBy(x => x.Position)
.Select(x => new { x.AccountCategoryID, x.Title })
.ToList();
DropDownList_Category.DataValueField = "AccountCategoryID";
DropDownList_Category.DataTextField = "Title";
DropDownList_Category.DataSource = data;
DropDownList_Category.DataBind();
}
public void LoadCategory()
{
DBEntities db = new DBEntities();
var data = db.AccountCategories.Select(x => new { x.AccountCategoryID, x.Title });
DropDownList_Category.DataValueField = "AccountCategoryID";
DropDownList_Category.DataTextField = "Title";
DropDownList_Category.DataSource = data.ToList();
DropDownList_Category.DataBind();
//thêm 1 item mặc đinh ở trên đầu dropdown
ListItem defaultItem = new ListItem(".:Mời chọn thể loại:.", string.Empty);
DropDownList_Category.Items.Insert(0, defaultItem);
}
protected void CategoryDataBind()
{
Model.Category category1 = new Model.Category();
BLL.CategoryManager category2 = new BLL.CategoryManager();
DropDownList_Category.DataTextField = "category";
DropDownList_Category.DataValueField = "categoryID";
DataSet ds = new CategoryManager().GetAllList();
DataRow dr = ds.Tables[0].NewRow();
dr["categoryID"] = 0;
dr["category"] = "---请选择问题分类---";
ds.Tables[0].Rows.InsertAt(dr, 0);
DropDownList_Category.DataSource = ds;
DropDownList_Category.DataBind();
}
public void LoadCategory()
{
DBEntities db = new DBEntities();
var data = from mc in db.ArticleMainCategories
from c in mc.ArticleCategories
orderby mc.Position, c.Position
select new
{
c.ArticleCategoryID,
Title = mc.Title + " - " + c.Title
};
DropDownList_Category.DataValueField = "ArticleCategoryID";
DropDownList_Category.DataTextField = "Title";
DropDownList_Category.DataSource = data.ToList();
DropDownList_Category.DataBind();
}
public void LoadCategory()
{
DBEntities db = new DBEntities();
var data = from mc in db.PictureMainCategories
from c in mc.PictureCategories
orderby mc.Position, c.Position
select new
{
c.PictureCategoryID,
Title = mc.Title + " - " + c.Title
};
DropDownList_Category.DataValueField = "PictureCategoryID";
DropDownList_Category.DataTextField = "Title";
DropDownList_Category.DataSource = data.ToList();
DropDownList_Category.DataBind();
//thêm 1 item mặc đinh ở trên đầu dropdown
ListItem defaultItem = new ListItem("-------------:Mời chọn thể loại:-------------", string.Empty);
DropDownList_Category.Items.Insert(0, defaultItem);
}
