private void btnSetConnect_Click(object sender, EventArgs e)
{
MSDASC.DataLinks datalinks = new MSDASC.DataLinksClass();
ADODB._Connection tmpconc = new ADODB.ConnectionClass();
if (TxtDbstr.Text == String.Empty)
{
tmpconc = (ADODB._Connection)datalinks.PromptNew();
if (tmpconc != null)
{
TxtDbstr.Text = tmpconc.ConnectionString;
}
}
else
{
Object oconc = tmpconc;
tmpconc.ConnectionString = TxtDbstr.Text;
try
{
if (datalinks.PromptEdit(ref oconc))
{
TxtDbstr.Text = tmpconc.ConnectionString;
}
}
catch
{
tmpconc = (ADODB._Connection)datalinks.PromptNew();
if (tmpconc != null)
{
TxtDbstr.Text = tmpconc.ConnectionString;
}
}
}
}
public static string GetBuiltConnectionString(string inputConnectionString)
{
MSDASC.DataLinks oDL = null;
string res = string.Empty;
try
{
oDL = new MSDASC.DataLinksClass();
ADODB.Connection conn = new ADODB.ConnectionClass();
conn.ConnectionString = inputConnectionString;
object oConn = (object)conn;
if (oDL.PromptEdit(ref oConn))
{
res = conn.ConnectionString;
}
}
catch
{
try
{
ADODB._Connection oConn = (ADODB._Connection)oDL.PromptNew();
if (oConn != null)
{
res = oConn.ConnectionString.ToString();
}
}
catch (Exception ex)
{
MyExceptionHandler.NewEx(ex);
}
}
return(string.IsNullOrEmpty(res) ? null : res);
}
/// <summary>
/// Displays a Connection String Builder (DataLinks) dialog.
///
/// Credits:
/// http://www.codeproject.com/cs/database/DataLinks.asp
/// http://www.codeproject.com/cs/database/DataLinks.asp?df=100&forumid=33457&select=1560237#xx1560237xx
///
/// Required COM references:
/// %PROGRAMFILES%\Microsoft.NET\Primary Interop Assemblies\adodb.dll
/// %PROGRAMFILES%\Common Files\System\Ole DB\OLEDB32.DLL
/// </summary>
/// <param name="currentConnectionString">Previous database connection string</param>
/// <returns>Selected connection string</returns>
private string PromptForConnectionString(string currentConnectionString)
{
MSDASC.DataLinks dataLinks = new MSDASC.DataLinksClass();
ADODB.Connection dialogConnection;
string generatedConnectionString = string.Empty;
if (currentConnectionString == String.Empty)
{
dialogConnection = (ADODB.Connection)dataLinks.PromptNew();
generatedConnectionString = dialogConnection.ConnectionString.ToString();
}
else
{
dialogConnection = new ADODB.Connection();
dialogConnection.Provider = "SQLOLEDB.1";
ADODB.Property persistProperty = dialogConnection.Properties["Persist Security Info"];
persistProperty.Value = true;
dialogConnection.ConnectionString = currentConnectionString;
dataLinks = new MSDASC.DataLinks();
object objConn = dialogConnection;
if (dataLinks.PromptEdit(ref objConn))
{
generatedConnectionString = dialogConnection.ConnectionString.ToString();
}
}
generatedConnectionString = generatedConnectionString.Replace("Provider=SQLOLEDB.1;", string.Empty);
if
(
!generatedConnectionString.Contains("Integrated Security=SSPI") &&
!generatedConnectionString.Contains("Trusted_Connection=True") &&
!generatedConnectionString.Contains("Password="******"Pwd=")
)
{
// BSG: Updated for null check on Value not only Password Property.
if (dialogConnection.Properties["Password"].Value != null)
{
generatedConnectionString += ";Password="******"Password"].Value.ToString();
}
}
return(generatedConnectionString);
}
public override object EditValue(ITypeDescriptorContext context, IServiceProvider provider, object value)
{
Cursor.Current = Cursors.WaitCursor;
string tmpReturn = string.Empty;
MSDASC.DataLinks dataLinks = new MSDASC.DataLinksClass();
ADODB._Connection connection = null;
if (value.ToString() == String.Empty)
{
try
{
connection = (ADODB._Connection)dataLinks.PromptNew();
if (connection != null) //if cancel is pressed connection is null
{
tmpReturn = connection.ConnectionString;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
else
{
connection = new ADODB.ConnectionClass();
connection.ConnectionString = value.ToString();
object oConnection = connection;
try
{
if ((bool)dataLinks.PromptEdit(ref oConnection))
{
tmpReturn = connection.ConnectionString;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
Cursor.Current = Cursors.Default;
return(tmpReturn);
}
/// <summary>
/// Get ConnectionString
/// </summary>
public string GetConnectionString()
{
/*
Reference DataLinks
NOTE: Reference
C:\Program Files\Common Files\System\Ole DB\OLEDB32.DLL
(Was MSDASC.dll)
SEE:
http://support.microsoft.com:80/support/kb/articles/Q225/1/32.asp
*/
MSDASC.DataLinks dataLinks = new MSDASC.DataLinksClass();
//note that a reference to:
// c:\Program Files\Microsoft.NET\Primary Interop Assemblies\adodb.dll
//is also required to read the ADODB._Connection result
ADODB._Connection connection;
// get a new connection string
//Prompt user for new connect string
connection = (ADODB._Connection)dataLinks.PromptNew();
//read result
return connection.ConnectionString.ToString();
}
private void button3_Click(object sender, System.EventArgs e)
{
MSDASC.DataLinks dataLinks = new MSDASC.DataLinksClass();
ADODB._Connection connection;
if (connectionString.Text == String.Empty)
{
try
{
connection = (ADODB._Connection)dataLinks.PromptNew();
connectionString.Text = connection.ConnectionString.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
else
{
connection = new ADODB.ConnectionClass();
connection.ConnectionString = connectionString.Text;
object oConnection = connection;
try
{
if (dataLinks.PromptEdit(ref oConnection))
{
connectionString.Text = connection.ConnectionString;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
private void button3_Click(object sender, System.EventArgs e)
{
MSDASC.DataLinks dataLinks = new MSDASC.DataLinksClass();
ADODB._Connection connection;
if (connectionString.Text == String.Empty)
{
try
{
connection = (ADODB._Connection) dataLinks.PromptNew();
connectionString.Text = connection.ConnectionString.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
else
{
connection = new ADODB.ConnectionClass();
connection.ConnectionString = connectionString.Text;
object oConnection = connection;
try
{
if (dataLinks.PromptEdit(ref oConnection))
{
connectionString.Text = connection.ConnectionString;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
private void btnConnectionString_Click(object sender, EventArgs e)
{
ADODB.Connection Conn = null;
String ConnectionString = tbConnectionString.Text;
MSDASC.DataLinks dataLinks = new MSDASC.DataLinksClass();
if (ConnectionString == string.Empty)
{
Conn = (ADODB.Connection)dataLinks.PromptNew();
}
else
{
Conn = new ADODB.Connection();
Conn.ConnectionString = tbConnectionString.Text;
object TempConn = Conn;
if (dataLinks.PromptEdit(ref TempConn))
ConnectionString = Conn.ConnectionString;
}
tbConnectionString.Text = Conn.ConnectionString;
}
/// <summary>
/// Displays a Connection String Builder (DataLinks) dialog.
///
/// Credits:
/// http://www.codeproject.com/cs/database/DataLinks.asp
/// http://www.codeproject.com/cs/database/DataLinks.asp?df=100&forumid=33457&select=1560237#xx1560237xx
///
/// Required COM references:
/// %PROGRAMFILES%\Microsoft.NET\Primary Interop Assemblies\adodb.dll
/// %PROGRAMFILES%\Common Files\System\Ole DB\OLEDB32.DLL
/// </summary>
/// <param name="currentConnectionString">Previous database connection string</param>
/// <returns>Selected connection string</returns>
private string PromptForConnectionString(string currentConnectionString)
{
MSDASC.DataLinks dataLinks = new MSDASC.DataLinksClass();
ADODB.Connection dialogConnection;
string generatedConnectionString = string.Empty;
if (currentConnectionString == String.Empty)
{
dialogConnection = (ADODB.Connection)dataLinks.PromptNew();
generatedConnectionString = dialogConnection.ConnectionString.ToString();
}
else
{
dialogConnection = new ADODB.Connection();
dialogConnection.Provider = "SQLOLEDB.1";
ADODB.Property persistProperty = dialogConnection.Properties["Persist Security Info"];
persistProperty.Value = true;
dialogConnection.ConnectionString = currentConnectionString;
dataLinks = new MSDASC.DataLinks();
object objConn = dialogConnection;
if (dataLinks.PromptEdit(ref objConn))
{
generatedConnectionString = dialogConnection.ConnectionString.ToString();
}
else
{
return currentConnectionString;
}
}
generatedConnectionString = generatedConnectionString.Replace("Provider=SQLOLEDB.1;", string.Empty);
if (
!generatedConnectionString.Contains("Integrated Security=SSPI")
&& !generatedConnectionString.Contains("Trusted_Connection=True")
&& !generatedConnectionString.Contains("Password="******"Pwd=")
)
{
if (dialogConnection.Properties["Password"] != null)
generatedConnectionString += ";Password="******"Password"].Value;
}
return generatedConnectionString;
}
