// 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;
}
