VS2005自带在WinForm中配置数据库连接字符串

最新推荐文章于 2023-12-11 13:18:19 发布

weixin_33739646

最新推荐文章于 2023-12-11 13:18:19 发布

阅读量88

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/lunar1984/archive/2008/02/01/1061478.html

版权

引用C:\Program Files\Microsoft Visual Studio 8\Common7\IDE 里面的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/lunar1984/archive/2008/02/01/1061478.html