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"]);
}