public void ExplorerObjectDoubleClick(ExplorerObjectEventArgs e) { FormConnectionString dlg = new FormConnectionString(); dlg.ProviderID = "postgre"; dlg.UseProviderInConnectionString = false; if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK) { DbConnectionString dbConnStr = dlg.DbConnectionString; ConfigConnections connStream = new ConfigConnections("postgis", "546B0513-D71D-4490-9E27-94CD5D72C64A"); string connectionString = dbConnStr.ConnectionString; string id = ConfigTextStream.ExtractValue(connectionString, "database"); id = connStream.GetName(id); connStream.Add(id, dbConnStr.ToString()); e.NewExplorerObject = new PostGISExplorerObject(this.ParentExplorerObject, id, dbConnStr); //string connStr = dlg.ConnectionString; //ConfigTextStream stream = new ConfigTextStream("postgis_connections", true, true); //string id = ConfigTextStream.ExtractValue(connStr, "Database"); //id += "@" + ConfigTextStream.ExtractValue(connStr, "Server"); //if (id == "@") id = "PostGIS Connection"; //stream.Write(connStr, ref id); //stream.Close(); //e.NewExplorerObject = new PostGISExplorerObject(id, dlg.ConnectionString); } }
private void getConnectionString_Click(object sender, EventArgs e) { DbConnectionString dbConnStr = new DbConnectionString(); dbConnStr.FromString(txtConnectionString.Text); FormConnectionString dlg = new FormConnectionString(dbConnStr); dlg.UseProviderInConnectionString = true; if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK) { dbConnStr = dlg.DbConnectionString; txtConnectionString.Text = dbConnStr.ToString(); } }
async private void btnChangeConnectionString_Click(object sender, EventArgs e) { AccessFDB fdb = null; switch (_providerId) { case "mssql": fdb = new SqlFDB(); break; case "postgres": fdb = new pgFDB(); break; case "sqlite": fdb = new SQLiteFDB(); break; } if (fdb == null) { return; } await fdb.Open(_connectionString); DbConnectionString dbConnStr = new DbConnectionString(); dbConnStr.UseProviderInConnectionString = false; FormConnectionString dlg = (dbConnStr.TryFromConnectionString("mssql", fdb.ConnectionString) ? new FormConnectionString(dbConnStr) : new FormConnectionString()); dlg.ProviderID = _providerId; dlg.UseProviderInConnectionString = false; if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK) { dbConnStr = dlg.DbConnectionString; _connectionString = dbConnStr.ConnectionString; await BuildList(); } }
public void ExplorerObjectDoubleClick(ExplorerObjectEventArgs e) { FormConnectionString dlg = new FormConnectionString(); dlg.ProviderID = "oracle"; dlg.UseProviderInConnectionString = false; if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK) { DbConnectionString dbConnStr = dlg.DbConnectionString; ConfigConnections connStream = new ConfigConnections("oracle", "546B0513-D71D-4490-9E27-94CD5D72C64A"); string connectionString = dbConnStr.ConnectionString; string id = ConfigTextStream.ExtractOracleValue(connectionString, "service_name") + "@" + ConfigTextStream.ExtractOracleValue(connectionString, "host"); id = connStream.GetName(id); connStream.Add(id, dbConnStr.ToString()); e.NewExplorerObject = new OracleExplorerObject(this.ParentExplorerObject, id, dbConnStr); } }
/// <summary> /// Executes this command. /// </summary> /// <param name="parameter">The parameter.</param> public override void Execute(object parameter) { using (var f = new FormConnectionString()) { if (f.ShowDialog(AppCore.FormMain) != DialogResult.OK) { return; } try { var builder = DatabaseSchema.CreateBuilder(f.ProviderType); var schema = builder.BuildDatabaseSchema(f.ConnectionString); AppCore.FormMain.SchemaBrowser.ShowSchema(schema); } catch (Exception ex) { ExceptionForm.ShowException("Open file", "Error open file", ex); } } }
public void ExplorerObjectDoubleClick(ExplorerObjectEventArgs e) { FormConnectionString dlg = new FormConnectionString(); dlg.ProviderID = "arcsde"; dlg.UseProviderInConnectionString = true; if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK) { string connStr = dlg.ConnectionString; if (connStr.ToLower().StartsWith("sde:")) { connStr = connStr.Substring(4, connStr.Length - 4); } ConfigTextStream stream = new ConfigTextStream("sde_connections", true, true); string id = ConfigTextStream.ExtractValue(connStr, "server").Replace(":", "_").Replace(@"\", "_"); string instance = ConfigTextStream.ExtractValue(connStr, "instance").Replace(":", "_").Replace(@"\", "_"); string database = ConfigTextStream.ExtractValue(connStr, "database").Replace(":", "_").Replace(@"\", "_"); if (String.IsNullOrEmpty(id)) { id = "ArcSDE Connection"; } if (!String.IsNullOrEmpty(instance)) { id += "-" + instance; } if (!String.IsNullOrEmpty(database)) { id += "-" + database; } stream.Write(connStr, ref id); stream.Close(); e.NewExplorerObject = new SdeExplorerObject(this.ParentExplorerObject, id, dlg.ConnectionString); } }
void ConnectionProperties_Click(object sender, EventArgs e) { if (_connectionString == null) { return; } FormConnectionString dlg = new FormConnectionString(_connectionString); dlg.ProviderID = "oracle"; dlg.UseProviderInConnectionString = false; if (dlg.ShowDialog() == DialogResult.OK) { DbConnectionString dbConnStr = dlg.DbConnectionString; ConfigConnections connStream = new ConfigConnections("oracle", "546B0513-D71D-4490-9E27-94CD5D72C64A"); connStream.Add(_server, dbConnStr.ToString()); _connectionString = dbConnStr; } }
public void ExplorerObjectDoubleClick(ExplorerObjectEventArgs e) { FormConnectionString dlg = new FormConnectionString(); dlg.ProviderID = "mssql"; dlg.UseProviderInConnectionString = false; if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK) { string connStr = dlg.ConnectionString; ConfigTextStream stream = new ConfigTextStream("MsSql2008SpatialSde_connections", true, true); string id = ConfigTextStream.ExtractValue(connStr, "Database"); id += "@" + ConfigTextStream.ExtractValue(connStr, "Server"); if (id == "@") { id = "MsSql 2008 Spatial Connection"; } stream.Write(connStr, ref id); stream.Close(); e.NewExplorerObject = new MsSql2008SpatialSdeExplorerObject(this.ParentExplorerObject, id, dlg.ConnectionString); } }
private void btnChangeConnectionString_Click(object sender, EventArgs e) { AccessFDB fdb = (_providerId == "mssql" ? new SqlFDB() : new AccessFDB()); fdb.Open(_connectionString); DbConnectionString dbConnStr = new DbConnectionString(); dbConnStr.UseProviderInConnectionString = false; FormConnectionString dlg = (dbConnStr.TryFromConnectionString("mssql", fdb.ConnectionString) ? new FormConnectionString(dbConnStr) : new FormConnectionString()); dlg.ProviderID = _providerId; dlg.UseProviderInConnectionString = false; if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK) { dbConnStr = dlg.DbConnectionString; _connectionString = dbConnStr.ConnectionString; BuildList(); } }
private void btnGetConnectionString_Click(object sender, EventArgs e) { if (_domain == null) { return; } FormConnectionString dlg = new FormConnectionString(_domain.DbConnectionString); dlg.ProviderID = "mssql,oledb,oracle"; if (dlg.ShowDialog() == DialogResult.OK) { _domain.DbConnectionString = dlg.DbConnectionString; if (_domain.DbConnectionString != null) { txtConnection.Text = _domain.DbConnectionString.SchemaName; } else { txtConnection.Text = String.Empty; } } }
/// <summary> /// Edition of conncetion sttring /// </summary> static public void EditConnectionSrtring() { Form form = new FormConnectionString(); form.ShowDialog(); }