protected void Page_Load(object sender, System.EventArgs e)
{
SqlServer server = SqlServer.CurrentServer;
SqlAdmin.SqlServerRole serverRole;
server.Connect();
SqlServerRoleCollection serverRoles = server.Roles;
server.Disconnect();
// Create DataSet from list of databases
DataSet ds = new DataSet();
ds.Tables.Add();
ds.Tables[0].Columns.Add("FullName");
ds.Tables[0].Columns.Add("Name");
ds.Tables[0].Columns.Add("Description");
for (int i = 0; i < serverRoles.Count; i++)
{
serverRole = serverRoles[i];
ds.Tables[0].Rows.Add(
new object[] {
Server.HtmlEncode(serverRole.FullName),
Server.HtmlEncode(serverRole.Name),
Server.HtmlEncode(serverRole.Description),
});
}
RoleDataGrid.DataSource = ds;
RoleDataGrid.DataBind();
}
protected void Page_Load(object sender, System.EventArgs e)
{
SqlServer server = SqlServer.CurrentServer;
SqlAdmin.SqlServerRole serverRole;
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)));
}
SqlServerRoleCollection serverRoles = server.Roles;
server.Disconnect();
// Create DataSet from list of databases
DataSet ds = new DataSet();
ds.Tables.Add();
ds.Tables[0].Columns.Add("FullName");
ds.Tables[0].Columns.Add("Name");
ds.Tables[0].Columns.Add("Description");
for (int i = 0; i < serverRoles.Count; i++)
{
serverRole = serverRoles[i];
ds.Tables[0].Rows.Add(
new object[] {
Server.HtmlEncode(serverRole.FullName),
Server.HtmlEncode(serverRole.Name),
Server.HtmlEncode(serverRole.Description),
}
);
}
RoleDataGrid.DataSource = ds;
RoleDataGrid.DataBind();
}
protected override void OnLoad(EventArgs e)
{
if (Request["Login"] == null)
Response.Redirect("CreateLogin.aspx");
LoginLabel.Text = Request["Login"].ToUpper();
if (!Page.IsPostBack)
{
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)));
}
sqlLogin = server.Logins[Request["Login"]];
if (sqlLogin == null)
Response.Redirect("CreateLogin.aspx");
if (sqlLogin.LoginType == SqlLoginType.NTUser || sqlLogin.LoginType == SqlLoginType.NTGroup)
{
SecurityAccess.Enabled = true;
SecurityAccessLabel.Enabled = true;
if (sqlLogin.NTLoginAccessType == SqlNtAccessType.Deny)
{
SecurityAccess.Items[1].Selected = true;
}
else
{
SecurityAccess.Items[0].Selected = true;
}
}
databases = server.Databases;
DefaultDatabase.DataSource = databases;
DefaultDatabase.DataBind();
DatabaseAccessGrid.DataSource = databases;
DatabaseAccessGrid.DataBind();
// Select default database
ListItem databaseItem = DefaultDatabase.Items.FindByValue(sqlLogin.Database);
if (databaseItem != null)
{
databaseItem.Selected = true;
}
else
{
databaseItem = DefaultDatabase.Items.FindByValue("master");
if (databaseItem != null)
databaseItem.Selected = true;
}
allRoles = server.Roles;
ServerRoles.DataSource = allRoles;
ServerRoles.DataBind();
// Select member roles
foreach (ListItem item in ServerRoles.Items)
{
if (sqlLogin.IsMember(item.Value))
{
item.Selected = true;
}
}
DefaultLanguage.DataSource = server.Languages;
DefaultLanguage.DataBind();
// Select default language
ListItem languageItem = DefaultLanguage.Items.FindByValue(sqlLogin.Language);
if (languageItem != null)
{
languageItem.Selected = true;
}
else
{
languageItem = DefaultLanguage.Items.FindByValue("English");
if (languageItem != null)
languageItem.Selected = true;
}
server.Disconnect();
focusPanel(GeneralPanel);
}
base.OnLoad(e);
}
protected override void OnLoad(EventArgs e)
{
if (Request["Login"] == null)
{
Response.Redirect("CreateLogin.aspx");
}
LoginLabel.Text = Request["Login"].ToUpper();
if (!Page.IsPostBack)
{
SqlServer server = SqlServer.CurrentServer;
server.Connect();
sqlLogin = server.Logins[Request["Login"]];
if (sqlLogin == null)
{
Response.Redirect("CreateLogin.aspx");
}
if (sqlLogin.LoginType == SqlLoginType.NTUser || sqlLogin.LoginType == SqlLoginType.NTGroup)
{
SecurityAccess.Enabled = true;
SecurityAccessLabel.Enabled = true;
if (sqlLogin.NTLoginAccessType == SqlNtAccessType.Deny)
{
SecurityAccess.Items[1].Selected = true;
}
else
{
SecurityAccess.Items[0].Selected = true;
}
}
databases = server.Databases;
DefaultDatabase.DataSource = databases;
DefaultDatabase.DataBind();
DatabaseAccessGrid.DataSource = databases;
DatabaseAccessGrid.DataBind();
// Select default database
ListItem databaseItem = DefaultDatabase.Items.FindByValue(sqlLogin.Database);
if (databaseItem != null)
{
databaseItem.Selected = true;
}
else
{
databaseItem = DefaultDatabase.Items.FindByValue("master");
if (databaseItem != null)
{
databaseItem.Selected = true;
}
}
allRoles = server.Roles;
ServerRoles.DataSource = allRoles;
ServerRoles.DataBind();
// Select member roles
foreach (ListItem item in ServerRoles.Items)
{
if (sqlLogin.IsMember(item.Value))
{
item.Selected = true;
}
}
DefaultLanguage.DataSource = server.Languages;
DefaultLanguage.DataBind();
// Select default language
ListItem languageItem = DefaultLanguage.Items.FindByValue(sqlLogin.Language);
if (languageItem != null)
{
languageItem.Selected = true;
}
else
{
languageItem = DefaultLanguage.Items.FindByValue("English");
if (languageItem != null)
{
languageItem.Selected = true;
}
}
server.Disconnect();
focusPanel(GeneralPanel);
}
base.OnLoad(e);
}
