private string GetConnectionString(string connectionString)
{
DataLinksClass dataLinks = new DataLinksClass();
_Connection connection = null;
if (String.IsNullOrEmpty(connectionString))
{
connection = dataLinks.PromptNew() as _Connection;
if (connection == null)
{
return("");
}
return(connection.ConnectionString);
}
connection = new ConnectionClass();
connection.ConnectionString = connectionString;
object objConnection = connection;
if (dataLinks.PromptEdit(ref objConnection))
{
return(connection.ConnectionString);
}
return(connectionString);
}
public static string PromptEdit(string connectionString)
{
var inputConnection = new ConnectionClass();
try
{
inputConnection.ConnectionString = connectionString;
var dataLinks = new DataLinksClass();
try
{
object connectionRef = inputConnection;
if (dataLinks.PromptEdit(ref connectionRef))
{
_Connection outputConnection = (_Connection)connectionRef;
try
{
return(outputConnection.ConnectionString);
}
finally
{
Marshal.ReleaseComObject(connectionRef);
}
}
return(null);
}
finally
{
Marshal.ReleaseComObject(dataLinks);
}
}
finally
{
Marshal.ReleaseComObject(inputConnection);
}
}
private static bool GetModifiedConnectionStringFromWizard(string existingConnectionString, out string modifiedConnectionString)
{
modifiedConnectionString = null;
try
{
DataLinks dataLinks = new DataLinksClass();
ADODB.Connection connection = new ADODB.ConnectionClass {
ConnectionString = existingConnectionString
};
object refObject = connection;
if (dataLinks.PromptEdit(ref refObject))
{
modifiedConnectionString = connection.ConnectionString;
return(true);
}
return(false);
}
catch
{
string newConnectionString;
if (GetNewConnectionStringFromWizard(out newConnectionString))
{
modifiedConnectionString = newConnectionString;
return(true);
}
return(false);
}
}
/// <summary>
/// Handles event when Edit Connection button is clicked
/// </summary>
/// <param name="param"></param>
/// <remarks></remarks>
private void EditConnCommandClick(object param)
{
try
{
object adoDbConn = (object)_connAdo;
DataLinks udl = new DataLinksClass();
udl.hWnd = _windowHandle != IntPtr.Zero ? _windowHandle.ToInt32() :
new WindowInteropHelper(App.Current.MainWindow).Handle.ToInt32();
if (udl.PromptEdit(ref adoDbConn))
{
if (TestConnection(_connAdo.ConnectionString))
{
_connStrBuilder.ConnectionString = _connAdo.ConnectionString;
OnPropertyChanged("ConnectionString");
OnPropertyChanged("SupportsSchemata");
}
}
}
catch { _connAdo = null; }
}
/// <summary>
/// Prompts the user for an OLE DB connection string using the Data Link Properties dialog.
/// </summary>
/// <param name="initialString">The initial connection string to display in the dialog. May be null.</param>
/// <param name="dialogParent">The control to be used as the parent of the Data Link Properties dialog or
/// null to show it as a non-modal dialog.</param>
/// <param name="allowedProviderProgID">If the user is only allowed to select one provider the ProgID of
/// that provider, otherwise null.</param>
/// <param name="allowedProviderDisplayName">The name of the allowed provider, as shown on the Providers
/// tab in the Data Link Properties dialog. This parameter is ignored if
/// <paramref name="allowedProviderProgID"/> is null.</param>
/// <returns>The new connection configured by the user or null if the user clicked Cancel in the dialog.</returns>
public static string PromptForConnectionString(string initialString, IWin32Window dialogParent,
string allowedProviderProgID, string allowedProviderDisplayName)
{
DataLinks datalinks = new DataLinksClass();
datalinks.hWnd = (dialogParent == null ? 0 : (int)dialogParent.Handle);
while (true)
{
Connection connection = new ConnectionClass();
if (initialString != null && initialString.Length > 0)
{
// If the string doesn't have a Provider specified, but we have allowedProviderProgID then
// set it.
if (allowedProviderProgID != null && CultureInfo.CurrentCulture.CompareInfo.IndexOf(
initialString, "provider", CompareOptions.IgnoreCase) < 0)
{
initialString = "Provider=" + allowedProviderProgID + ";" + initialString;
}
connection.ConnectionString = initialString;
}
else
{
// Default to MS SQL.
connection.ConnectionString = "Provider=" + Constants.OleDb.MsSqlProviderProgID;
}
object refConnection = connection;
if (datalinks.PromptEdit(ref refConnection))
{
connection = (Connection)refConnection;
if (allowedProviderProgID == null)
{
return(connection.ConnectionString);
}
// Check that the provider is the allowed one.
if (connection.Provider == allowedProviderProgID || connection.Provider.StartsWith(allowedProviderProgID + "."))
{
return(connection.ConnectionString);
}
// It's not - tell the user and prompt again.
string displayName = (allowedProviderDisplayName == null || allowedProviderDisplayName.Length == 0
? allowedProviderProgID : allowedProviderDisplayName);
MessageBox.Show(dialogParent, "You must select '" + displayName + "' on the Provider tab.",
"Edit database connection string", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
return(null);
}
}
}
/// <summary>
/// Handles event when Edit Connection button is clicked
/// </summary>
/// <param name="param"></param>
/// <remarks></remarks>
private void EditConnCommandClick(object param)
{
try
{
object adoDbConn = (object)_connAdo;
DataLinks udl = new DataLinksClass();
udl.hWnd = _windowHandle != IntPtr.Zero ? _windowHandle.ToInt32() :
new WindowInteropHelper(App.Current.MainWindow).Handle.ToInt32();
if (udl.PromptEdit(ref adoDbConn))
{
if (TestConnection(_connAdo.ConnectionString))
{
_connStrBuilder.ConnectionString = _connAdo.ConnectionString;
OnPropertyChanged("ConnectionString");
OnPropertyChanged("SupportsSchemata");
}
}
}
catch { _connAdo = null; }
}