private void frmGenerate_Load(object sender, EventArgs e) { // Load previous settings if (!string.IsNullOrEmpty(Properties.Settings.Default.LastDropFolder)) { this.txtFolder.Text = Properties.Settings.Default.LastDropFolder; } this.chkCreateIndex.Checked = Properties.Settings.Default.LastIndexChoice; DataConnectionDialog dcd = new DataConnectionDialog(); DataConnectionConfiguration dcs = new DataConnectionConfiguration(null); dcs.LoadConfiguration(dcd); if (DataConnectionDialog.Show(dcd) == DialogResult.OK) { Globals.ConnectionString = dcd.ConnectionString; // Populate the table list LoadTableList(); } else { this.Close(); } }
static void Main(string[] args) { DataConnectionDialog dcd = new DataConnectionDialog(); DataConnectionConfiguration dcs = new DataConnectionConfiguration(null); dcs.LoadConfiguration(dcd); if (DataConnectionDialog.Show(dcd) == DialogResult.OK) { // load tables using (SqlConnection connection = new SqlConnection(dcd.ConnectionString)) { connection.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM sys.Tables", connection); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { Console.WriteLine(reader.HasRows); } } } } dcs.SaveConfiguration(dcd); }
/// <summary> /// Connection (and reconnection) to the database using Microsoft's native interface /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void connect(object sender, EventArgs e) { DataConnectionDialog dcd = new DataConnectionDialog(); DataConnectionConfiguration dcc = new DataConnectionConfiguration(null); dcc.LoadConfiguration(dcd); // Initialize connection string from current or previous (saved) connection string if (mySqlServer1.ConnectionPool.GetConnection(0) != null && mySqlServer1.ConnectionPool.GetConnection(0).State == ConnectionState.Open) { dcd.ConnectionString = mySqlServer1.ConnectionPool.GetConnection(0).ConnectionString; } else if (!string.IsNullOrEmpty(AppSettings.Default.LastConnectionString)) { dcd.ConnectionString = AppSettings.Default.LastConnectionString; } if (DataConnectionDialog.Show(dcd) == DialogResult.OK) { AppSettings.Default.LastConnectionString = dcd.ConnectionString; AppSettings.Default.Save(); dcc.SaveConfiguration(dcd); var succ = mySqlServer1.RefreshServers(dcd.ConnectionString); if (succ) { DatabaseBrowserDockForm.RefreshObjects(); } } }
public DataConnectionSourceDialog() { InitializeComponent(); DbWorkarounds.SNILoadWorkaround(); DataConnectionConfiguration config = new DataConnectionConfiguration(); _dataSources = config.DataSources; }
public CommonConnectionStringDialog() { this._connectionDialog = new DataConnectionDialog(); this._connectionDialog.DataSources.Add(DataSource.OdbcDataSource); this._connectionDialog.DataSources.Add(DataSource.SqlDataSource); this._connectionDialog.SelectedDataSource = DataSource.SqlDataSource; DataConnectionConfiguration dcs = new DataConnectionConfiguration(null); dcs.LoadConfiguration(_connectionDialog); }
/// <summary> /// Create connection string using Microsoft's ConnectionUI class /// </summary> /// <param name="DataSource">Default catalog</param> /// <param name="SaveConfiguration">true to save, false not to save</param> /// <returns></returns> public bool GetConnection(ref string DataSource, bool SaveConfiguration = false) { var success = false; var dcd = new DataConnectionDialog(); var dcs = new DataConnectionConfiguration(null); dcs.LoadConfiguration(dcd); if (DataConnectionDialog.Show(dcd) == DialogResult.OK) { DbProviderFactory factory = DbProviderFactories.GetFactory(dcd.SelectedDataProvider.Name); using (var connection = factory.CreateConnection()) { connection.ConnectionString = dcd.ConnectionString; ConnectionString = connection.ConnectionString; DataSource = connection.DataSource; connection.Open(); var cmd = connection.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT * FROM INFORMATION_SCHEMA.TABLES"; var dt = new DataTable(); dt.Load(cmd.ExecuteReader()); TableNames = dt.AsEnumerable() .Select(row => row.Field <string>("table_name")) .OrderBy(field => field) .ToList(); } var builder = new SqlConnectionStringBuilder() { ConnectionString = dcd.ConnectionString }; ServerName = builder.DataSource; InitialCatalog = builder.InitialCatalog; if (SaveConfiguration) { dcs.SaveConfiguration(dcd); } if (TableNames.Count > 0) { success = true; } } return(success); }
private void BuildConnStringBtn_Click(object sender, RoutedEventArgs e) { var connectionDialog = new DataConnectionDialog(); var connectionConfig = new DataConnectionConfiguration(null); connectionConfig.LoadConfiguration(connectionDialog); System.Windows.Forms.DialogResult result = DataConnectionDialog.Show(connectionDialog); if (result == System.Windows.Forms.DialogResult.OK) { _dataContext.ConnectionString = connectionDialog.ConnectionString; } }
private void browseButton_Click(object sender, EventArgs e) { var dcd = new DataConnectionDialog(); var dcs = new DataConnectionConfiguration(null); dcs.LoadConfiguration(dcd); if (DataConnectionDialog.Show(dcd) != DialogResult.OK) { return; } conTextBox.Text = dcd.ConnectionString; _setting.ConnectionString = dcd.ConnectionString; }
private DataConnectionDialog GetDataConnectionDialog() { DataConnectionDialog connectionDialog = new DataConnectionDialog(); connectionDialog.DataSources.Add(DataSource.OdbcDataSource); connectionDialog.DataSources.Add(DataSource.SqlDataSource); connectionDialog.SelectedDataSource = DataSource.SqlDataSource; DataConnectionConfiguration dcs = new DataConnectionConfiguration(null); dcs.LoadConfiguration(connectionDialog); return(connectionDialog); }
private void GetConnectionDetails() { DataConnectionDialog dcd = new DataConnectionDialog(); DataConnectionConfiguration dcs = new DataConnectionConfiguration(null); dcs.LoadConfiguration(dcd); DataConnectionDialog.Show(dcd); m_GuiDbProviderTextBox.Text = dcd.SelectedDataProvider.Name; m_GuiConnectionString.Text = dcd.ConnectionString; //m_DbConnectionType = dcd.SelectedDataProvider.TargetConnectionType.ToString(); miscSettingsModelBindingSource.EndEdit(); }
private string GetConnectionString() { string connectionString = null; DataConnectionDialog dcd = new DataConnectionDialog(); DataConnectionConfiguration dcs = new DataConnectionConfiguration(null); dcs.LoadConfiguration(dcd); if (DataConnectionDialog.Show(dcd) == DialogResult.OK) { connectionString = dcd.ConnectionString; } dcs.SaveConfiguration(dcd); return(connectionString); }
private void выборПодключенияToolStripMenuItem_Click(object sender, EventArgs e) { string connectionString = null; DataConnectionDialog dcd = new DataConnectionDialog(); DataConnectionConfiguration dcs = new DataConnectionConfiguration(null); dcs.LoadConfiguration(dcd); if (DataConnectionDialog.Show(dcd) == DialogResult.OK) { connectionString = dcd.ConnectionString; } dcs.SaveConfiguration(dcd); File.WriteAllText(@"connectionsString.connstr", connectionString); }
static void Main(string[] args) { DataConnectionDialog dcd = new DataConnectionDialog(); DataConnectionConfiguration dcs = new DataConnectionConfiguration(null); dcs.LoadConfiguration(dcd); if (DataConnectionDialog.Show(dcd) == DialogResult.OK) { DbProviderFactory factory = DbProviderFactories.GetFactory(dcd.SelectedDataProvider.Name); using (var connection = factory.CreateConnection()) { connection.ConnectionString = dcd.ConnectionString; connection.Open(); var command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "SELECT * FROM INFORMATION_SCHEMA.TABLES"; using (var reader = command.ExecuteReader()) { while (reader.Read()) { Console.WriteLine(reader["name"]); } } } // load tables //using (SqlConnection connection = new SqlConnection(dcd.ConnectionString)) //{ // connection.Open(); // SqlCommand cmd = new SqlCommand("SELECT * FROM sys.Tables", connection); // using (SqlDataReader reader = cmd.ExecuteReader()) // { // while (reader.Read()) // { // Console.WriteLine(reader.HasRows); // } // } //} } dcs.SaveConfiguration(dcd); }
private void DestButton_Click(object sender, EventArgs e) { _connection2 = null; DataConnectionDialog dialog = new DataConnectionDialog(); DataConnectionConfiguration dcs = new DataConnectionConfiguration(null); dcs.LoadConfiguration(dialog); if (DataConnectionDialog.Show(dialog) == DialogResult.OK) { _connection2 = new SqlConnection(dialog.ConnectionString); _connection2.Open(); toolTip1.SetToolTip(DestButton, _connection2.ConnectionString); RefreshTables(_connection2, lst2); } }
private void LoadConfiguration() { var config = ConfigurationManager.OpenExeConfiguration("ClearOffice.exe"); ConnectionStringsSection section = config.ConnectionStrings; var setting = section.ConnectionStrings["ClearOfficeEntities"]; var dcd = new DataConnectionDialog(); var dcs = new DataConnectionConfiguration(null); dcs.LoadConfiguration(dcd); if (DataConnectionDialog.Show(dcd) == DialogResult.OK) { var conString = "metadata=res://*/ClearOfficeModel.csdl|res://*/ClearOfficeModel.ssdl|res://*/ClearOfficeModel.msl;provider=System.Data.SqlClient;provider connection string=\""; conString += dcd.ConnectionString; conString += ";multipleactiveresultsets=True;App=EntityFramework\""; setting.ConnectionString = conString; config.Save(ConfigurationSaveMode.Modified); } }
public static bool Initialize() { ApplicationSettings.Initialize(); while (true) { //TODO: Get rid of this try. Not sure what I was doing originally. //This is completely broken and just (predictably) fails if it can't connect to the database or what have you. //Kinda makes it hard for someone to set this up if they don't know what I was doing, which if I'm being honest, I didn't. try { ParagonDataContext ctx = new ParagonDataContext(); //TODO: Pretty sure this fails everytime if the database doesn't exist so go me, this is very helpful. Idiot. if (!ctx.DatabaseExists()) { ctx.CreateDatabase(); } _userAccessor = new UserAccessor(); return(true); } catch (Exception) { //So I just spent like 3 hours trying to get a SQL Server running and this never popped up once. I have no idea what I was doing. using (DataConnectionDialog dialog = new DataConnectionDialog()) { DataConnectionConfiguration dcs = new DataConnectionConfiguration(null); dcs.LoadConfiguration(dialog); if (DataConnectionDialog.Show(dialog) != DialogResult.OK) { return(false); } string connectionString = dialog.ConnectionString; ApplicationSettings.ConnectionString = connectionString; } } } }
private void OnConnectionStringButtonClick(object sender, EventArgs e) { // Using the microsoft connection dialog as used in visual studio // http://archive.msdn.microsoft.com/Connection/Release/ProjectReleases.aspx?ReleaseId=3863 var dialogResult = DialogResult.Cancel; var connectionString = string.Empty; var dcd = new DataConnectionDialog(); try { var dcs = new DataConnectionConfiguration(null); dcs.LoadConfiguration(dcd, Connection.Type); CaptureConnection(); if (Connection.ConnectionString != GetDefaultConnectionStringForServerType(Connection.Type)) { dcd.ConnectionString = Connection.ConnectionString; } dialogResult = DataConnectionDialog.Show(dcd); connectionString = dcd.ConnectionString; } catch (ArgumentException) { dcd.ConnectionString = string.Empty; dialogResult = DataConnectionDialog.Show(dcd); } finally { if (dialogResult == DialogResult.OK) { Connection.ConnectionString = connectionString; BindData(); } } }
private void NewConnectionButton_Click(object sender, RoutedEventArgs e) { try { DataConnectionDialog dataConnectionDialog = new DataConnectionDialog(); DataConnectionConfiguration dataConnectionSetting = new DataConnectionConfiguration(null); dataConnectionSetting.LoadConfiguration(dataConnectionDialog); if (DataConnectionDialog.Show(dataConnectionDialog) == System.Windows.Forms.DialogResult.OK) { string connString = dataConnectionDialog.ConnectionString; string provName = dataConnectionDialog.SelectedDataProvider.Name; ModelItem.Properties["ConnectionString"].SetValue(new InArgument <string>(connString)); ModelItem.Properties["ProviderName"].SetValue(new InArgument <string>(provName)); if (ModelItem.Properties["ExistingDbConnection"] != null) { ModelItem.Properties["ExistingDbConnection"].SetValue(null); } } } catch { } }
private void btnConnectToDatabase_Click(object sender, EventArgs e) { DataConnectionConfiguration dcs = new DataConnectionConfiguration(null); dcs.LoadConfiguration(dcd); if (DataConnectionDialog.Show(dcd) == DialogResult.OK) { var tables = SqlUtils.GetAllTables(dcd.ConnectionString); SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.ConnectionString = dcd.ConnectionString; dbName = builder.InitialCatalog; serverName = builder.DataSource; connectionString = dcd.ConnectionString; TreeNode rootNode = new TreeNode(builder.InitialCatalog, 1, 1); TreeNode tablesNode = rootNode.Nodes.Add("Tables", "Tables", 2, 2); tablesNode.Tag = dcd.ConnectionString; foreach (string table in tables) { TreeNode tableNode = tablesNode.Nodes.Add(table, table, 3, 3); tableNode.Tag = "table"; } tvTables.Nodes.Add(rootNode); tvTables.ExpandAll(); } }
bool IObfuscationDocumentView.TryGetDatabaseConnection(ref Type connectionType, ref string connectionString) { return(DataConnectionConfiguration.TryGetDatabaseConnection(ref connectionType, ref connectionString)); }
private void chooseDatabaseBtn_Click(object sender, EventArgs e) { DataConnectionDialog dcd = new DataConnectionDialog(); DataConnectionConfiguration dcs = new DataConnectionConfiguration(null); dcs.LoadConfiguration(dcd); if (DataConnectionDialog.Show(dcd) == DialogResult.OK) { databaseTxt.Text = dcd.ConnectionString; connectionString = dcd.ConnectionString; dataSourceType = dcd.SelectedDataSource.DisplayName; Console.WriteLine("here it is :" + dataSourceType); switch (dataSourceType) { //case "Microsoft SQL Server Compact 3.5": // try // { // using (SqlCeConnection con = new SqlCeConnection(connectionString)) // { // tableTxt.Items.Clear(); // con.Open(); // using (SqlCeCommand command = new SqlCeCommand("SELECT table_name FROM INFORMATION_SCHEMA.Tables", con)) // { // SqlCeDataReader reader = command.ExecuteReader(); // while (reader.Read()) // { // tableTxt.Items.Add(reader.GetString(0)); // } // } // con.Close(); // } // dcs.SaveConfiguration(dcd); // tableTxt.Enabled = true; // } // catch (Exception ex) // { // MessageBox.Show("Unable to establish Connection..", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); // } // break; case "Microsoft SQL Server": try { using (SqlConnection con = new SqlConnection(connectionString)) { tableTxt.Items.Clear(); con.Open(); using (SqlCommand command = new SqlCommand("SELECT table_name FROM INFORMATION_SCHEMA.Tables", con)) { SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { tableTxt.Items.Add(reader.GetString(0)); } } con.Close(); } dcs.SaveConfiguration(dcd); tableTxt.Enabled = true; } catch (Exception ex) { MessageBox.Show("Unable to establish Connection..", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } break; default: MessageBox.Show("Not Implemented Yet..!!"); break; } } }
public static bool TryGetDatabaseConnection(ref Type connectionType, ref string connectionString) { DialogResult dialogResult; Type _connectionType = connectionType; using (DataConnectionDialog dataConnectionDialog = new DataConnectionDialog()) { DataConnectionConfiguration dataConnectionConfiguration; dataConnectionConfiguration = new DataConnectionConfiguration(null); dataConnectionConfiguration.LoadConfiguration(dataConnectionDialog); //dataConnectionDialog.ConnectionString = connectionString ?? string.Empty; /*var useThisOne = dataConnectionDialog.DataSources.Where(ds => (object)ds.DefaultProvider != null && ds.DefaultProvider.TargetConnectionType == _connectionType).Select(ds => new { DataSource = ds, DataProvider = ds.DefaultProvider }).SingleOrDefault(); if ((object)useThisOne != null) { dataConnectionDialog.SelectedDataProvider = useThisOne.DataProvider; dataConnectionDialog.SelectedDataSource = useThisOne.DataSource; dataConnectionDialog.ConnectionString = connectionString ?? string.Empty; }*/ dialogResult = DataConnectionDialog.Show(dataConnectionDialog); if (dialogResult == DialogResult.OK) { connectionString = dataConnectionDialog.ConnectionString; if ((object)dataConnectionDialog.SelectedDataSource != null && (object)dataConnectionDialog.SelectedDataSource.DefaultProvider != null) connectionType = dataConnectionDialog.SelectedDataSource.DefaultProvider.TargetConnectionType; } } return dialogResult == DialogResult.OK; }
private void OnConnectionStringButtonClick(object sender, EventArgs e) { var dialogResult = DialogResult.Cancel; var connectionString = string.Empty; var dcd = new DataConnectionDialog(); try { var dcs = new DataConnectionConfiguration(null); dcs.LoadConfiguration(dcd, Connection.Type); CaptureConnection(); if (Connection.ConnectionString != GetDefaultConnectionStringForServerType(Connection.Type)) { dcd.ConnectionString = Connection.ConnectionString; } dialogResult = DataConnectionDialog.Show(dcd); connectionString = dcd.ConnectionString; } catch (ArgumentException) { dcd.ConnectionString = string.Empty; dialogResult = DataConnectionDialog.Show(dcd); } finally { if (dialogResult == DialogResult.OK) { Connection.ConnectionString = connectionString; BindData(); } } }