protected void Page_Load(object sender, System.EventArgs e) { SqlServer server = SqlServer.CurrentServer; SqlAdmin.SqlLogin login; 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))); } SqlLoginCollection logins = server.Logins; server.Disconnect(); // Create DataSet from list of databases DataSet ds = new DataSet(); ds.Tables.Add(); ds.Tables[0].Columns.Add("Name"); ds.Tables[0].Columns.Add("LoginType"); ds.Tables[0].Columns.Add("NTLoginAccessType"); ds.Tables[0].Columns.Add("Database"); ds.Tables[0].Columns.Add("LanguageAlias"); for (int i = 0; i < logins.Count; i++) { login = logins[i]; ds.Tables[0].Rows.Add( new object[] { Server.HtmlEncode(login.Name), Server.HtmlEncode(login.LoginType.ToString()), Server.HtmlEncode(login.NTLoginAccessType.ToString()), Server.HtmlEncode(login.Database.ToString()), Server.HtmlEncode(login.LanguageAlias.ToString()), } ); } LoginDataGrid.DataSource = ds; LoginDataGrid.DataBind(); }
protected void Page_Load(object sender, System.EventArgs e) { SqlServer server = SqlServer.CurrentServer; SqlAdmin.SqlLogin login; server.Connect(); SqlLoginCollection logins = server.Logins; server.Disconnect(); // Create DataSet from list of databases DataSet ds = new DataSet(); ds.Tables.Add(); ds.Tables[0].Columns.Add("Name"); ds.Tables[0].Columns.Add("LoginType"); ds.Tables[0].Columns.Add("NTLoginAccessType"); ds.Tables[0].Columns.Add("Database"); ds.Tables[0].Columns.Add("LanguageAlias"); for (int i = 0; i < logins.Count; i++) { login = logins[i]; ds.Tables[0].Rows.Add( new object[] { Server.HtmlEncode(login.Name), Server.HtmlEncode(login.LoginType.ToString()), Server.HtmlEncode(login.NTLoginAccessType.ToString()), Server.HtmlEncode(login.Database.ToString()), Server.HtmlEncode(login.LanguageAlias.ToString()), }); } LoginDataGrid.DataSource = ds; LoginDataGrid.DataBind(); }