protected void cbo_chuyenmuc_SelectedIndexChanged(object sender, EventArgs e) { NguoidungDAL _Obj = new NguoidungDAL(); int catid = 0; try { catid = int.Parse(cbo_chuyenmuc.SelectedValue); } catch {; } DataTable dt = _Obj.GetAllUser_By_CatID(catid); drop_User.DataSource = null; drop_User.DataBind(); if (dt != null) { if (dt.Rows.Count > 0) { drop_User.DataSource = dt; drop_User.DataTextField = "Fullname"; drop_User.DataValueField = "Ma_Nguoidung"; drop_User.DataBind(); drop_User.Items.Add(new ListItem(CommonLib.ReadXML("lblTatca"), "0")); drop_User.SelectedValue = "0"; } } }
public void LoadTacgia() { NguoidungDAL _Obj = new NguoidungDAL(); DataTable dt = _Obj.GetAllUser_By_CatID(0); Drop_Tacgia.DataSource = null; Drop_Tacgia.DataBind(); if (dt != null) { if (dt.Rows.Count > 0) { Drop_Tacgia.Items.Add(new ListItem("<<-----Tác giả----->>", "0", true)); for (int i = 0; i <= dt.Rows.Count - 1; i++) { this.Drop_Tacgia.Items.Add(new ListItem(dt.Rows[i]["Fullname"].ToString(), dt.Rows[i]["Ma_Nguoidung"].ToString())); } } } }
private void LoadCombox() { NguoidungDAL _Obj = new NguoidungDAL(); UltilFunc.BindCombox(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", string.Format(" HoatDong = 1 and HienThi_BDT = 1 "), CommonLib.ReadXML("lblTatca"), "Ma_Chuyenmuc_Cha", " Order by ThuTuHienThi ASC"); drop_User.Items.Clear(); DataTable dt = _Obj.GetAllUser_By_CatID(0); if (dt != null) { if (dt.Rows.Count > 0) { drop_User.Items.Add(new ListItem(CommonLib.ReadXML("lblTatca"), "0", true)); for (int i = 0; i <= dt.Rows.Count - 1; i++) { this.drop_User.Items.Add(new ListItem(dt.Rows[i]["Fullname"].ToString(), dt.Rows[i]["Ma_Nguoidung"].ToString())); } } } }