protected void Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
SqlServer server = SqlServer.CurrentServer;
server.Connect();
SqlDatabase database = SqlDatabase.CurrentDatabase(server);
Logins.DataSource = server.Logins;
Logins.DataBind();
// Remove existing users from the Logins selection
foreach (SqlUser user in database.Users)
{
ListItem item = Logins.Items.FindByValue(user.Login);
if (item != null)
{
Logins.Items.Remove(item);
}
}
if (Logins.Items.Count == 0)
{
CreateButton.Enabled = false;
ErrorMessage.Text = "All Logins are Users of this database.";
}
Username.Text = Logins.SelectedValue;
server.Disconnect();
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
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)));
}
SqlDatabase database = SqlDatabase.CurrentDatabase(server);
Logins.DataSource = server.Logins;
Logins.DataBind();
// Remove existing users from the Logins selection
foreach (SqlUser user in database.Users)
{
ListItem item = Logins.Items.FindByValue(user.Login);
if (item != null)
{
Logins.Items.Remove(item);
}
}
if (Logins.Items.Count == 0)
{
CreateButton.Enabled = false;
ErrorMessage.Text = "All Logins are Users of this database.";
}
Username.Text = Logins.SelectedValue;
server.Disconnect();
}
}