protected void Save_Click(object sender, EventArgs e) { SqlServer server = SqlServer.CurrentServer; server.Connect(); try { SqlDatabase database = SqlDatabase.CurrentDatabase(server); SqlDatabaseRole role = database.DatabaseRoles[Request["Role"]]; foreach (ListItem item in RoleUsers.Items) { SqlUser user = database.Users[item.Value]; if (user.IsMember(role.Name) && !item.Selected) { role.DropMember(user.Name); } else if (!user.IsMember(role.Name) && item.Selected) { role.AddMember(role.Name); } } } catch (Exception ex) { ErrorMessage.Text = ex.Message; return; } finally { server.Disconnect(); } Response.Redirect("DatabaseRoles.aspx?database=" + Request["database"]); }