110,502
社区成员
发帖
与我相关
我的任务
分享
private void BtnConnectSetup_Click(object sender, EventArgs e)
{
IniFile INI = new IniFile(CONFIG_FILE_FULLNAME);
MSDASC.DataLinks datalinks = new MSDASC.DataLinksClass();
ADODB._Connection tmpconc = new ADODB.ConnectionClass();
try
{
String OldConnectionString = String.Empty, ConnectionString = String.Empty, OrgConnectionString;
Connection.Close();
OldConnectionString = "Provider=SQLOLEDB.1;" + Connection.ConnectionString;
OrgConnectionString = Connection.ConnectionString;
if (OldConnectionString == String.Empty)
{
tmpconc = (ADODB._Connection)datalinks.PromptNew();
ConnectionString = tmpconc.ConnectionString;
}
else
{
Object oconc = tmpconc;
tmpconc.ConnectionString = OldConnectionString;
if (datalinks.PromptEdit(ref oconc))
ConnectionString = tmpconc.ConnectionString;
}
try
{
ConnectionString = ConnectionString.Remove(0, ConnectionString.IndexOf(";") + 1);
ConnectionString = "Provider=SQLOLEDB.1;" + ConnectionString;
INI.WriteValue("Connect", "ConnectionString", ConnectionString);
Connection.Close();
Connection.ConnectionString = CSharpSQLConnectionString(ConnectionString);
Connection.Open();
Connection.Close();
}
catch
{
if (OrgConnectionString == String.Empty)
INI.WriteValue("Connect", "ConnectionString", OrgConnectionString);
else
INI.WriteValue("Connect", "ConnectionString", "Provider=SQLOLEDB.1;" + OrgConnectionString);
Connection.Close();
Connection.ConnectionString = OrgConnectionString;
}
tabControl.SelectTab(0);
}
finally
{
((IDisposable)INI).Dispose();
}
}
Microsoft.Data.ConnectionUI.DataConnectionDialog dcDialog = new Microsoft.Data.ConnectionUI.DataConnectionDialog();
try
{
dcDialog.DataSources.Add(((DataSource)this.dsCbo.SelectedItem));
dcDialog.SelectedDataProvider = ((DataSource)this.dsCbo.SelectedItem).DefaultProvider;
if (DataConnectionDialog.Show(dcDialog) == DialogResult.OK)
{
this.connStrTxtBox.Text = _ecaDataSource.ConnectionString = dcDialog.ConnectionString;
_ecaDataSource.Provider = dcDialog.SelectedDataProvider.Name;
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message.ToString());
}
finally
{
dcDialog = null;
}