获取VS.NET 自带的数据库连接对话框的数据库连接

引用 Microsoft.Data.ConnectionUI.Dialog.dll 文件即可

 1using System;
 2using System.Collections.Generic;
 3using System.Text;
 4using Microsoft.Data.ConnectionUI;
 5using System.Windows.Forms;
 6
 7namespace ConsoleApplication1
 8{
 9    class Api
10    {
11        /**//// <summary>
12        /// 获取VS.NET 自带的数据库连接对话框的数据库连接信息
13        /// </summary>
14        /// <returns>数据库连接</returns>
15        public string  GetDatabaseConnectionString()
16        {
17            string connString = "";
18            Microsoft.Data.ConnectionUI.DataConnectionDialog dialog = new Microsoft.Data.ConnectionUI.DataConnectionDialog();
19           
20            //  必须增加以下四项中任一一项
21            dialog.DataSources.Add(DataSource.AccessDataSource); // Access 
22            dialog.DataSources.Add(DataSource.OdbcDataSource);  // ODBC
23            dialog.DataSources.Add(DataSource.OracleDataSource); // Oracle 
24            dialog.DataSources.Add(DataSource.SqlDataSource);  // Sql Server
25
26            // 初始化
27            dialog.SelectedDataSource = DataSource.SqlDataSource;  
28            dialog.SelectedDataProvider = DataProvider.SqlDataProvider;
29
30            if (DataConnectionDialog.ShowDialog(dialog) == DialogResult.OK)    
31            {
32                connString = dialog.ConnectionString;
33            }
34
35            return connString;
36        }        
37        
38    }
39}