protected void RoleLogins_Changed(object sender, ItemPickerEventArgs e)
{
SqlServer server = SqlServer.CurrentServer;
server.Connect();
try
{
SqlServerRole role = server.Roles[Request["Role"]];
switch (e.Action)
{
case ItemAction.Add:
role.AddMember(e.Item.Value);
break;
case ItemAction.Remove:
role.DropMember(e.Item.Value);
break;
}
}
catch (Exception ex)
{
ErrorMessage.Text = ex.Message;
return;
}
finally
{
server.Disconnect();
}
}
protected void RoleLogins_Changed(object sender, ItemPickerEventArgs e)
{
SqlServer server = SqlServer.CurrentServer;
try
{
server.Connect();
}
catch (System.Exception ex)
{
//Response.Redirect("Error.aspx?errorPassCode=" + 2002);
Response.Redirect(String.Format("error.aspx?errormsg={0}&stacktrace={1}", Server.UrlEncode(ex.Message), Server.UrlEncode(ex.StackTrace)));
}
try
{
SqlServerRole role = server.Roles[Request["Role"]];
switch (e.Action)
{
case ItemAction.Add:
role.AddMember(e.Item.Value);
break;
case ItemAction.Remove:
role.DropMember(e.Item.Value);
break;
}
}
catch (Exception ex)
{
ErrorMessage.Text = ex.Message;
return;
}
finally
{
server.Disconnect();
}
}
