在软件中使用“连接字符串（ConnectionString）生成向导对话框”方法大全

一、通过udl文件建立（可集成于软件中）

新建一个文本文件，将扩展名改为“udl”，在window下双击，即可弹出向导。

一个 ADO 连接中使用在代码中的数据链接文件

数据链接文件用于 ADO 连接是相当简单。 以下是在使用绝对路径的语法：

cnPubs.ConnectionString = "File Name=C:/Path/To/Pubs.UDL;"


 

二、VS中ConnectionUI.Dialog

首先添加对Microsoft.Data.ConnectionUI.Dialog.dll的引用，这个assembly在VS2005的安装目录下，C:/Program Files/Microsoft Visual Studio 8/Common7/IDE下边，下面是代码：

// 添加引用 // using System.Data; private void btnCreateConnection(object sender, EventArgs e) { DataConnectionDialog dialog = new DataConnectionDialog(); //添加数据源列表，可以向窗口中添加自己程序所需要的数据源类型 dialog.DataSources.Add(DataSource.SqlDataSource); dialog.DataSources.Add(DataSource.OdbcDataSource); dialog.SelectedDataSource = DataSource.OdbcDataSource; dialog.SelectedDataProvider = DataProvider.OdbcDataProvider; //只能够通过DataConnectionDialog类的静态方法Show出对话框 //不同使用dialog.Show()或dialog.ShowDialog()来呈现对话框 if (DataConnectionDialog.Show(dialog, this) == DialogResult.OK) { txtConnectionString.Text = dialog.ConnectionString; } }

 

三、Data Link Properties dialog box

Requirements

The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need:

• Microsoft Windows 2000 Professional, Windows 2000 Server, Windows 2000 Advanced Server, or Windows NT 4.0 Server
• Microsoft Visual Studio .NET

This article assumes that you are familiar with the following topics:

• Visual Studio .NET
• ADO.NET fundamentals and syntax
• ActiveX Data Objects (ADO) fundamentals and syntax

Create an ADO Connection

For Component Object Model (COM) interoperability, you must declare the ADO Connection object as ADODB._Connection and cast the generic object that the data link returns to an ADODB._Connection.

1. Start Visual Studio .NET, and then create a new Visual C# Windows Application project. Form1 is added to the project by default.
2. From the Project menu, click Add Reference.
3. On the COM tab, select the following references:
   • Microsoft ActiveX Data Objects 2.7
   • Microsoft OLEDB Service Component 1.0 Type Library
4. If you are prompted to have a wrapper generated for you, click Yes.
5. Add a Button control to Form1.
6. Add the following code to the Button1_Click event:MSDASC.DataLinks mydlg = new MSDASC.DataLinks(); ADODB._Connection ADOcon; //Cast the generic object that PromptNew returns to an ADODB._Connection. ADOcon = (ADODB._Connection) mydlg.PromptNew(); ADOcon.Open("","","",0); if (ADOcon.State == 1) { MessageBox.Show("Connection Opened"); ADOcon.Close(); } else { MessageBox.Show("Connection Failed"); }
7. Press the F5 key to compile and run the project, and then click Button1.
8. Type the appropriate information in the Data Link Properties dialog box, and make sure that you select the Allow Saving Password check box.
9. Click Test Connection.
10. Click OK. If the connection test succeeded in the data link, a connection to the database is established, and a message box is displayed.

  

Create an OLE DB Connection

When you create an OLE DB connection with the OLE DB managed provider in .NET, you cannot use the data link to create connections to ODBC data sources. Because ODBC has its own managed provider in .NET, you receive an error if you use the Microsoft OLEDB provider for ODBC drivers option in the Data Link Properties dialog box. In addition, you must load ADO into the application because the data link creates an object, which you cast to an ADODB._Connection, that is not compatible with the OleDbConnection object. Thus, you must create an ADODB._Connection and assign its ConnectionString property to the ConnectionString property of the OleDbConnection object for this to work properly.

1. Start Visual Studio .NET, and then create a Visual C# Windows Application project. Form1 is added to the project by default.
2. From the Project menu, click Add Reference.
3. On the COM tab, select the following references:
   • Microsoft ActiveX Data Objects 2.7
   • Microsoft OLEDB Service Component 1.0 Type Library
4. Add a Button control to Form1.
5. Add the following code to the top of the Code window:

   using System.Data.OleDb;
   					

6. Add the following code in the Button1_Click event:

   MSDASC.DataLinks mydlg = new MSDASC.DataLinks();
   OleDbConnection OleCon = new OleDbConnection();
   ADODB._Connection ADOcon;
   
   //Cast the generic object that PromptNew returns to an ADODB._Connection.
   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");
   }
   					

7. Press F5 to compile and run the project, and then click Button1.
8. Type the appropriate information in the Data Link Properties dialog box, and make sure that you select the Allow Saving Password check box.
9. Click Test Connection.
10. Click OK. If the connection test succeeded in the data link, a connection to the database is established, and a message box is displayed

Additional Information

It requires additional effort to use this method to create an ODBC connection because the data link creates a connection string that is specific to OLE DB and is not compatible with the ODBC managed provider. For this to work, you must parse the ADODB connection string for the relevant information such as the user ID, password, and data source. After you obtain this information, you can use it to create a connection string that is specific to ODBC. Keep in mind that the data link only uses ODBC data source names (DSNs); thus, you cannot create a DSN-less connection through the data link.（src:http://support.microsoft.com/default.aspx?scid=kb;EN-US;310083）

 

四、VC建立 ADO 连接字符串对话框的例子

第一步：引入dll

#import "c:/program files/common files/system/ado/msado15.dll" no_namespace rename "EOF","adoEOF")

第二步：这里给出两个 建立ADO连接字符串对话框 的例子。
datalinks.cpp 建立和编辑ADO连接字符串
linktest.cpp 如果只是建立连接字符串，程序还可以这么写。

// datalinks.cpp文件的代码 #include "msdasc.h" // OLE DB Service Component header #include "stdio.h" #include <initguid.h> // Include only once in your application #include <adoid.h> #include <adoint.h> BSTR PromptEdit(BSTR connstr); BSTR PromptNew(); void main() { BSTR newstr=NULL,editstr; printf("PromatNew/n"); newstr=PromptNew(); printf("PromatEdit/n"); editstr=PromptEdit(newstr); SysFreeString(newstr); SysFreeString(editstr); } BSTR PromptEdit(BSTR connstr) { HRESULT hr; IDataSourceLocator* dlPrompt = NULL; ADOConnection* piTmpConnection; VARIANT vaResult; vaResult.vt=VT_BSTR; EXCEPINFO excepInfo; memset(&excepInfo, 0, sizeof excepInfo); BSTR _result=NULL; DISPPARAMS dispparams; memset(&dispparams, 0, sizeof dispparams); // no arguments dispparams.cArgs =0; UINT nArgErr = (UINT)-1; // initialize to invalid arg // Initialize COM ::CoInitialize( NULL ); hr = CoCreateInstance(CLSID_CADOConnection, NULL, CLSCTX_INPROC_SERVER, IID_IADOConnection, (LPVOID *)&piTmpConnection); piTmpConnection->put_ConnectionString(connstr); // Instantiate DataLinks object. hr = CoCreateInstance( CLSID_DataLinks, //clsid -- Data Links UI NULL, //pUnkOuter CLSCTX_INPROC_SERVER, //dwClsContext IID_IDataSourceLocator, //riid (void**)&dlPrompt //ppvObj ); VARIANT_BOOL pbSuccess; // Prompt for connection information. hr = dlPrompt->PromptEdit((IDispatch **)&piTmpConnection,&pbSuccess); piTmpConnection->get_ConnectionString(&_result); printf("Connectionstring:%S/n",_result); return _result; } BSTR PromptNew() { HRESULT hr; IDataSourceLocator* dlPrompt = NULL; //IDispatch* connID = NULL; ADOConnection * connID = NULL; VARIANT vaResult; vaResult.vt=VT_BSTR; EXCEPINFO excepInfo; memset(&excepInfo, 0, sizeof excepInfo); BSTR _result=NULL; DISPPARAMS dispparams; memset(&dispparams, 0, sizeof dispparams); // no arguments dispparams.cArgs =0; UINT nArgErr = (UINT)-1; // initialize to invalid arg // Initialize COM ::CoInitialize( NULL ); // Instantiate DataLinks object. hr = CoCreateInstance( CLSID_DataLinks, //clsid -- Data Links UI NULL, //pUnkOuter CLSCTX_INPROC_SERVER, //dwClsContext IID_IDataSourceLocator, //riid (void**)&dlPrompt //ppvObj ); // Prompt for connection information. hr = dlPrompt->PromptNew((IDispatch**)&connID); // If connection object is NULL, user cancelled. if ( NULL == connID ) return NULL; connID->get_ConnectionString(&_result); printf("Connectionstring:%S/n",_result); return _result; /* hr = connID->Invoke(0x0,IID_NULL,0,DISPATCH_PROPERTYGET,&dispparams,&vaResult,&excepInfo, &nArgErr); _result = vaResult.bstrVal; printf("Connectionstring:%S/n",_result); // Open hr = connID->Invoke(0xa,IID_NULL,0, DISPATCH_METHOD,&dispparams,NULL,&excepInfo, &nArgErr); // Close hr = connID->Invoke(0x5,IID_NULL,0, DISPATCH_METHOD,&dispparams,NULL,&excepInfo, &nArgErr); return vaResult.bstrVal; */ } // linktest.cpp文件的代码 // linktest.cpp : Defines the entry point for the console application. // #include "stdafx.h" #include "msdasc.h" // OLE DB Service Component header #include "stdio.h" void main() { HRESULT hr; IDataSourceLocator* dlPrompt = NULL; IDispatch* connID = NULL; VARIANT vaResult; vaResult.vt=VT_BSTR; EXCEPINFO excepInfo; memset(&excepInfo, 0, sizeof excepInfo); BSTR _result=NULL; DISPPARAMS dispparams; memset(&dispparams, 0, sizeof dispparams); // no arguments dispparams.cArgs =0; UINT nArgErr = (UINT)-1; // initialize to invalid arg // Initialize COM ::CoInitialize( NULL ); // Instantiate DataLinks object. hr = CoCreateInstance( CLSID_DataLinks, //clsid -- Data Links UI NULL, //pUnkOuter CLSCTX_INPROC_SERVER, //dwClsContext IID_IDataSourceLocator, //riid (void**)&dlPrompt //ppvObj ); // Prompt for connection information. hr = dlPrompt->PromptNew(&connID); // If connection object is NULL, user cancelled. if ( NULL == connID ) return; hr = connID->Invoke(0x0,IID_NULL,0,DISPATCH_PROPERTYGET,&dispparams,&vaResult,&excepInfo, &nArgErr); _result = vaResult.bstrVal; printf("Connectionstring:%S/n",_result); SysFreeString(vaResult.bstrVal); // Open hr = connID->Invoke(0xa,IID_NULL,0, DISPATCH_METHOD,&dispparams,NULL,&excepInfo, &nArgErr); // Close hr = connID->Invoke(0x5,IID_NULL,0, DISPATCH_METHOD,&dispparams,NULL,&excepInfo, &nArgErr); }

 

再贴一个实例：

HRESULT hr; IDataSourceLocatorPtr dlPrompt=NULL; _RecordsetPtr rs=NULL; try { // 初始化DataLinks对象 hr=dlPrompt.CreateInstance(__uuidof(DataLinks)); if(FAILED(hr)) throw(_com_error(hr,NULL)); // 建立连接 pConn=dlPrompt->PromptNew(); // 如果 conn 为 NULL if(pConn==NULL) return; // 打开连接 pConn->Open(pConn->ConnectionString,L"",L"",-1); // 清除列表框 while(m_tblList.GetCount()>0) m_tblList.DeleteString(0); // 获取数据库中表集 rs=pConn->OpenSchema(adSchemaTables); while(!rs->adoEOF) { m_tblList.AddString((char*)(_bstr_t)rs->Fields->Item[L"TABLE_NAME"]->Value); rs->MoveNext(); } rs=NULL; dlPrompt.Release(); } catch (_com_error &e) { AfxMessageBox(e.ErrorMessage()); } 需要注意的是，在建立工程时，要选上Automation选项， 在StdAfx.h中加入下面代码 #import "C:/program files/common files/System/ado/msado15.dll" no_namespace rename("EOF","adoEOF") //如果使用 ADO 2.0 加入下面代码 #import "C:/Program Files/Common Files/System/Ole DB/msdasc.dll" no_namespace //如果使用 ADO 2.1 加入下面代码 #import "C:/Program Files/Common Files/System/Ole DB/oledb32.dll" no_namespace 注：ADO2.0 或 ADO2.1 中，如果其中一个编译不成功，则用另一个

请下载源代码，结合代码可以更清楚源代码1:数据库连接演示

需要注意的是，在建立工程时，要选上Automation选项，

在StdAfx.h中加入下面代码

#import "C:/program files/common files/System/ado/msado15.dll" no_namespace rename("EOF","adoEOF")
//如果使用 ADO 2.0 加入下面代码
#import "C:/Program Files/Common Files/System/Ole DB/msdasc.dll" no_namespace 
//如果使用 ADO 2.1 加入下面代码
#import "C:/Program Files/Common Files/System/Ole DB/oledb32.dll" no_namespace

（src:http://www.vckbase.com/document/viewdoc/?id=755）