protected override void OnLoad(EventArgs e) { if (!Page.IsPostBack) { SqlServer server = SqlServer.CurrentServer; server.Connect(); SqlDatabase database = SqlDatabase.CurrentDatabase(server); SqlUser user = null; if (Request["User"] != null) { user = database.Users[Request["User"]]; } if (user == null) { Response.Redirect("DatabaseUsers.aspx"); } UsernameLabel.Text = user.Name.ToUpper(); LoginLabel.Text = user.Login; SqlDatabaseRoleCollection dbRoles = database.DatabaseRoles; Roles.DataSource = dbRoles; Roles.DataBind(); foreach (string roleName in user.ListMembers()) { ListItem roleItem = Roles.Items.FindByValue(roleName); if (roleItem != null) { roleItem.Selected = true; } } server.Disconnect(); } base.OnLoad(e); }