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