protected void Page_Load(object sender, System.EventArgs e) { 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))); } SqlDatabaseCollection databases = server.Databases; server.Disconnect(); // Clear out list and populate with database names if (!IsPostBack) { ExportDatabaseList.Items.Clear(); for (int i = 0; i < databases.Count; i++) { ExportDatabaseList.Items.Add(new ListItem(databases[i].Name)); } } }
protected void Page_Load(object sender, System.EventArgs e) { 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))); } SqlDatabaseCollection databases = server.Databases; 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("encodedname"); ds.Tables[0].Columns.Add("size"); for (int i = 0; i < databases.Count; i++) { SqlDatabase database = databases[i]; ds.Tables[0].Rows.Add(new object[] { Server.HtmlEncode(database.Name), Server.UrlEncode(database.Name), database.Size == -1 ? "Unknown" : String.Format("{0}MB", database.Size) }); } DatabasesDataGrid.DataSource = ds; DatabasesDataGrid.DataBind(); }
private void txtPassword_TextChanged(object sender, System.EventArgs e) { SqlServer server = new SqlServer(this.txtServer.Text, this.txtUserName.Text, this.txtPassword.Text); server.Connect(); SqlDatabaseCollection databases = server.Databases; server.Disconnect(); // Clear out list and populate with database names for (int i = 0; i < databases.Count; i++) { ExportDatabaseList.Items.Add(databases[i].Name); } }
protected void Page_Load(object sender, System.EventArgs e) { SqlServer server = SqlServer.CurrentServer; server.Connect(); SqlDatabaseCollection databases = server.Databases; server.Disconnect(); // Clear out list and populate with database names if (!IsPostBack) { ExportDatabaseList.Items.Clear(); for (int i = 0; i < databases.Count; i++) { ExportDatabaseList.Items.Add(new ListItem(databases[i].Name)); } } }
protected void Page_Load(object sender, EventArgs e) { SqlServer server = SqlServer.CurrentServer; server.Connect(); SqlDatabaseCollection databases = server.Databases; 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("encodedname"); ds.Tables[0].Columns.Add("size"); for (int i = 0; i < databases.Count; i++) { SqlDatabase database = databases[i]; ds.Tables[0].Rows.Add(new object[] { Server.HtmlEncode(database.Name), Server.UrlEncode(database.Name), database.Size == -1 ? "Unknown" : String.Format("{0}MB", database.Size) }); } DatabasesDataGrid.DataSource = ds; DatabasesDataGrid.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); }
private bool Save() { 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))); } try { // Save Login settings sqlLogin = server.Logins[Request["Login"]]; if (SecurityAccess.Enabled) { sqlLogin.DenyNTLogin = SecurityAccess.SelectedValue == "Deny" ? true : false; } sqlLogin.Database = DefaultDatabase.SelectedValue; sqlLogin.Language = DefaultLanguage.SelectedValue; // Save server roles foreach (ListItem item in ServerRoles.Items) { if (sqlLogin.IsMember(item.Value) && !item.Selected) { server.Roles[item.Value].DropMember(sqlLogin.Name); } else if (!sqlLogin.IsMember(item.Value) && item.Selected) { server.Roles[item.Value].AddMember(sqlLogin.Name); } } databases = server.Databases; // Save database access foreach (DataGridItem item in DatabaseAccessGrid.Items) { SqlDatabase database = databases[(string)DatabaseAccessGrid.DataKeys[item.ItemIndex]]; CheckBox cb = item.FindControl("DatabaseAccess") as CheckBox; if (database != null && cb != null) { string dbName = sqlLogin.GetUserName(database.Name); if (dbName != null && !cb.Checked) { database.Users[dbName].Remove(); } else if (dbName == null && cb.Checked) { database.Users.Add(sqlLogin.Name, sqlLogin.Name); } } } } catch (Exception ex) { ErrorMessage.Text = ex.Message; return false; } finally { server.Disconnect(); } return true; }
internal static async Task <SqlDatabaseResource> CreateSqlDatabase(string name, AutoscaleSettings autoscale, SqlDatabaseCollection collection) { SqlDatabaseCreateUpdateData sqlDatabaseCreateUpdateOptions = new SqlDatabaseCreateUpdateData(AzureLocation.WestUS, new Models.SqlDatabaseResource(name)) { Options = BuildDatabaseCreateUpdateOptions(TestThroughput1, autoscale), }; var databaseLro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, name, sqlDatabaseCreateUpdateOptions); return(databaseLro.Value); }
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); }
private bool Save() { SqlServer server = SqlServer.CurrentServer; server.Connect(); try { // Save Login settings sqlLogin = server.Logins[Request["Login"]]; if (SecurityAccess.Enabled) { sqlLogin.DenyNTLogin = SecurityAccess.SelectedValue == "Deny"?true:false; } sqlLogin.Database = DefaultDatabase.SelectedValue; sqlLogin.Language = DefaultLanguage.SelectedValue; // Save server roles foreach (ListItem item in ServerRoles.Items) { if (sqlLogin.IsMember(item.Value) && !item.Selected) { server.Roles[item.Value].DropMember(sqlLogin.Name); } else if (!sqlLogin.IsMember(item.Value) && item.Selected) { server.Roles[item.Value].AddMember(sqlLogin.Name); } } databases = server.Databases; // Save database access foreach (DataGridItem item in DatabaseAccessGrid.Items) { SqlDatabase database = databases[(string)DatabaseAccessGrid.DataKeys[item.ItemIndex]]; CheckBox cb = item.FindControl("DatabaseAccess") as CheckBox; if (database != null && cb != null) { string dbName = sqlLogin.GetUserName(database.Name); if (dbName != null && !cb.Checked) { database.Users[dbName].Remove(); } else if (dbName == null && cb.Checked) { database.Users.Add(sqlLogin.Name, sqlLogin.Name); } } } } catch (Exception ex) { ErrorMessage.Text = ex.Message; return(false); } finally { server.Disconnect(); } return(true); }
public async Task WebAppSqlConnectionCRUD() { string resourceGroupName = Recording.GenerateAssetName("SdkRg"); string webAppName = Recording.GenerateAssetName("SdkWeb"); string sqlServerName = Recording.GenerateAssetName("SdkSql"); string sqlDatabaseName = Recording.GenerateAssetName("SdkSql"); string sqlUserName = Recording.GenerateAssetName("SdkSql"); string sqlPassword = Recording.GenerateAssetName("SdkPa5$"); string linkerName = Recording.GenerateAssetName("SdkLinker"); // create resource group await ResourceGroups.CreateOrUpdateAsync(WaitUntil.Completed, resourceGroupName, new Resources.ResourceGroupData(DefaultLocation)); ResourceGroupResource resourceGroup = await ResourceGroups.GetAsync(resourceGroupName); // // create web app WebSiteCollection webSites = resourceGroup.GetWebSites(); await webSites.CreateOrUpdateAsync(WaitUntil.Completed, webAppName, new WebSiteData(DefaultLocation)); WebSiteResource webapp = await webSites.GetAsync(webAppName); // create sql database SqlServerCollection sqlServers = resourceGroup.GetSqlServers(); SqlServerData sqlServerData = new SqlServerData(DefaultLocation) { AdministratorLogin = sqlUserName, AdministratorLoginPassword = sqlPassword, }; await sqlServers.CreateOrUpdateAsync(WaitUntil.Completed, sqlServerName, sqlServerData); SqlServerResource sqlServer = await sqlServers.GetAsync(sqlServerName); SqlDatabaseCollection sqlDatabases = sqlServer.GetSqlDatabases(); await sqlDatabases.CreateOrUpdateAsync(WaitUntil.Completed, sqlDatabaseName, new SqlDatabaseData(DefaultLocation)); SqlDatabaseResource sqlDatabase = await sqlDatabases.GetAsync(sqlDatabaseName); // create service linker LinkerResourceCollection linkers = webapp.GetLinkerResources(); var linkerData = new LinkerResourceData { TargetService = new Models.AzureResource { Id = sqlDatabase.Id, }, AuthInfo = new SecretAuthInfo { Name = sqlUserName, SecretInfo = new ValueSecretInfo { Value = sqlPassword, }, }, ClientType = ClientType.Dotnet, }; await linkers.CreateOrUpdateAsync(WaitUntil.Completed, linkerName, linkerData); // list service linker var linkerResources = await linkers.GetAllAsync().ToEnumerableAsync(); Assert.AreEqual(1, linkerResources.Count); Assert.AreEqual(linkerName, linkerResources[0].Data.Name); // get service linker LinkerResource linker = await linkers.GetAsync(linkerName); Assert.IsTrue(linker.Id.ToString().StartsWith(webapp.Id.ToString(), StringComparison.InvariantCultureIgnoreCase)); Assert.AreEqual(sqlDatabase.Id.ToString(), (linker.Data.TargetService as AzureResource).Id); Assert.AreEqual(AuthType.Secret, linker.Data.AuthInfo.AuthType); // get service linker configurations SourceConfigurationResult configurations = await linker.GetConfigurationsAsync(); foreach (var configuration in configurations.Configurations) { Assert.IsNotNull(configuration.Name); Assert.IsNotNull(configuration.Value); } // delete service linker var operation = await linker.DeleteAsync(WaitUntil.Completed); Assert.IsTrue(operation.HasCompleted); }