protected void displayUsers() { DataSet ds = new DataSet(); ds = this.ConnSQL.getUsersList(); UsersList.DataSource = ds.Tables["userslist"].DefaultView; UsersList.DataBind(); }
private void BindUsers() { UsersList.DataSource = repo.GetAllUsers(); UsersList.DataTextField = "FullName"; UsersList.DataValueField = "EntityID"; UsersList.SelectedIndex = 0; UsersList.DataBind(); BindDetails(); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } UsersList.DataSource = DataBaseConnectionRoot.Instance.SelectQueryExecuter("select * from users"); UsersList.DataBind(); }
private void BindUsers() { UsersList.Items.Clear(); DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("UserId", typeof(string))); // 0 dt.Columns.Add(new DataColumn("UserName", typeof(string))); // 1 DataRow dr; using (IDataReader reader = SecureGroup.GetListAllUsersInGroup(int.Parse(GroupsList.SelectedValue))) { while (reader.Read()) { if ((byte)reader["Activity"] == (byte)Mediachase.IBN.Business.User.UserActivity.Active) { dr = dt.NewRow(); dr[0] = reader["UserId"].ToString(); dr[1] = reader["LastName"].ToString() + " " + reader["FirstName"].ToString(); dt.Rows.Add(dr); } } } if (dt.Rows.Count == 0) // no users in group { dr = dt.NewRow(); dr[0] = "-1"; dr[1] = GetGlobalResourceObject("IbnFramework.Project", "NoUsers").ToString(); dt.Rows.Add(dr); } DataView dv = dt.DefaultView; UsersList.DataSource = dv; UsersList.DataTextField = "UserName"; UsersList.DataValueField = "UserId"; UsersList.DataBind(); //Saved Value ListItem li = UsersList.Items.FindByValue(UserId); if (li != null) { li.Selected = true; } else { UsersList.SelectedIndex = 0; UserId = UsersList.SelectedValue; } BindData(); }
private void BindUsers(int GroupId) { UsersList.Items.Clear(); DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("UserId", typeof(string))); // 0 dt.Columns.Add(new DataColumn("UserName", typeof(string))); // 1 DataRow dr; dr = dt.NewRow(); dr[0] = allUsers; dr[1] = LocRM.GetString("All"); dt.Rows.Add(dr); if (GroupId > 0) { using (IDataReader reader = SecureGroup.GetListAllUsersInGroup(GroupId)) { while (reader.Read()) { if ((byte)reader["Activity"] == (byte)Mediachase.IBN.Business.User.UserActivity.Active) { dr = dt.NewRow(); dr[0] = reader["UserId"].ToString(); dr[1] = reader["LastName"].ToString() + " " + reader["FirstName"].ToString(); dt.Rows.Add(dr); } } } } DataView dv = dt.DefaultView; UsersList.DataSource = dv; UsersList.DataTextField = "UserName"; UsersList.DataValueField = "UserId"; UsersList.DataBind(); //Saved Value if (_pc["MV_User"] != null) { UsersList.ClearSelection(); try { UsersList.SelectedValue = _pc["MV_User"]; } catch { UsersList.SelectedIndex = 0; _pc["MV_User"] = UsersList.SelectedValue; } } }
private void LoadUsers() { State state = new State(); UserController userController = new UserController(); List <UserModel> users = userController.LoadUsers(); //We want to find the user we are logged in as, and remove it from the list //so we don't accidently remove administrator rights to it. foreach (UserModel user in users) { if (user.Id == state.Cache().GetUser().Id) { users.Remove(user); break; } } UsersList.DataSource = users; UsersList.DataBind(); }
protected void users_PageIndexChanging(object sender, GridViewPageEventArgs e) { UsersList.PageIndex = e.NewPageIndex; UsersList.DataSource = DataBaseConnectionRoot.Instance.SelectQueryExecuter("select * from users"); UsersList.DataBind(); }