如何用代码调用SQL连接配置向导?如下图:我知道Ole db 可以使用下面的方法调用,SqlConnection 应该怎用调用?
MSDASC.DataLinks mydlg = new MSDASC.DataLinks();
OleDbConnection OleCon = new OleDbConnection();
ADODB._Connection ADOcon;ADOcon = (ADODB._Connection) mydlg.PromptNew();OleCon.ConnectionString = ADOcon.ConnectionString;
OleCon.Open();if (OleCon.State.ToString() == "Open")
{
MessageBox.Show("Connection Opened");
OleCon.Close();
}
else
{
MessageBox.Show("Connection Failed");
}
MSDASC.DataLinks mydlg = new MSDASC.DataLinks();
OleDbConnection OleCon = new OleDbConnection();
ADODB._Connection ADOcon;ADOcon = (ADODB._Connection) mydlg.PromptNew();OleCon.ConnectionString = ADOcon.ConnectionString;
OleCon.Open();if (OleCon.State.ToString() == "Open")
{
MessageBox.Show("Connection Opened");
OleCon.Close();
}
else
{
MessageBox.Show("Connection Failed");
}
就可以调用SQL 了
{
string connString = "";
Microsoft.Data.ConnectionUI.DataConnectionDialog dialog = new Microsoft.Data.ConnectionUI.DataConnectionDialog();
// 必须增加以下四项中任一一项
dialog.DataSources.Add(DataSource.AccessDataSource); // Access
dialog.DataSources.Add(DataSource.OdbcDataSource); // ODBC
dialog.DataSources.Add(DataSource.OracleDataSource); // Oracle
dialog.DataSources.Add(DataSource.SqlDataSource); // Sql Server // 初始化
dialog.SelectedDataSource = DataSource.SqlDataSource;
dialog.SelectedDataProvider = DataProvider.SqlDataProvider; if (DataConnectionDialog.ShowDialog(dialog) == DialogResult.OK)
{
connString = dialog.ConnectionString;
} return connString;
}
if (DataConnectionDialog.ShowDialog(dialog) == DialogResult.OK)
{
connString = dialog.ConnectionString;
}
这里视乎应该改成if (DataConnectionDialog.Show(dialog) == DialogResult .OK )
{
connStr = dialog.ConnectionString;
}我的没有ShowDialog方法,只有Show方法.