// pick a new connection private void EhChooseConnection() { // release mouse capture to avoid wait cursor // _toolStrip.Capture = false; // get starting connection string // (if empty or no provider, start with SQL source as default) var connectionChoice = _connectionStringList.FirstSelectedNode; AltaxoOleDbConnectionString axoConnString = null != connectionChoice ? (AltaxoOleDbConnectionString)connectionChoice.Tag : AltaxoOleDbConnectionString.Empty; var connString = axoConnString.OriginalConnectionString; if (string.IsNullOrEmpty(connString) || connString.IndexOf("provider=", StringComparison.OrdinalIgnoreCase) < 0) { connString = "Provider=SQLNCLI11.1;"; } // let user change it var newConnString = OleDbConnString.EditConnectionString(connString); if (string.IsNullOrEmpty(newConnString)) { return; } ConnectionString = new AltaxoOleDbConnectionString(newConnString, null); }
private void connStringPick_button_Click(object sender, RoutedEventArgs e) { connStringText.Text = string.Empty; string strConnString = ""; //object _con = null; //MSDASC.DataLinks _link = new MSDASC.DataLinks(); //_con = _link.PromptNew(); //if (_con == null) // connStringText.Text = string.Empty; //strConnString = ((ADODB.Connection)_con).ConnectionString; //connStringText.Text = strConnString; ConnectionString = strConnString; //string connString = _cmbConnString.Text; if (string.IsNullOrEmpty(ConnectionString) || ConnectionString.IndexOf("provider=", StringComparison.OrdinalIgnoreCase) < 0) { ConnectionString = "Provider=SQLOLEDB.1;"; } // let user change it //var helper = new WindowInteropHelper(); //helper.Owner = win32Window.Handle; var parentWindow = ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow); ConnectionString = OleDbConnString.EditConnectionString(parentWindow, ConnectionString); connStringText.Text = ConnectionString; //IntPtr windowHandle = new WindowInteropHelper(parentWindow).Handle; }
private void connStringPick_button_Click(object sender, RoutedEventArgs e) { connectionStrText.Text = string.Empty; string strConnString = ""; ConnectionString = strConnString; if (string.IsNullOrEmpty(ConnectionString) || ConnectionString.IndexOf("provider=", StringComparison.OrdinalIgnoreCase) < 0) { ConnectionString = "Provider=SQLOLEDB.1;"; } var parentWindow = ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow); ConnectionString = OleDbConnString.EditConnectionString(parentWindow, ConnectionString); connectionStrText.Text = ConnectionString; }