直接调用VS.net2005中的配置界面

以前做Winform程序,居然专门做一个界面来配置连接字符串。今天无意中发现:竟然可以直接调用VS.net2005中的配置界面来处理。

使用方法也非常简单:

引用C:Program FilesMicrosoft Visual Studio 8Common7IDE 里面的Microsoft.Data.ConnectionUI.Dialog.dll。

using Microsoft.Data.ConnectionUI;

DataConnectionDialog dialog = new DataConnectionDialog();

            dialog.DataSources.Add(DataSource.SqlDataSource);
            dialog.SelectedDataProvider = DataProvider.SqlDataProvider;

            //dialog.DataSources.Add(DataSource.OdbcDataSource);

            //dialog.SelectedDataSource = DataSource.OdbcDataSource;
            //dialog.SelectedDataProvider = DataProvider.OdbcDataProvider;

            dialog.StartPosition = FormStartPosition.CenterScreen;
            dialog.Title = "Connect to SqlServer";
            dialog.ConnectionString = "server=127.0.0.1;database=YarnNew;user id=sa;password=aaa;";


            if (DataConnectionDialog.Show(dialog, this) == DialogResult.OK)
            {
                MessageBox.Show(dialog.ConnectionString);
            }

原文地址:https://www.cnblogs.com/wwwzzg168/p/3569029.html