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