winform中C#调用数据库连接选择对话框

来源:互联网 发布:怎样修改游戏数据 编辑:程序博客网 时间:2024/06/05 02:55
1.首先需要添加引用“%Visual Studio安装目录%/Common7/IDE/Microsoft.Data.ConnectionUI.Dialog.dll”命名空间为:using Microsoft.Data.ConnectionUI;2.调用        private void btnCreateConnection(object sender, EventArgs e)        {            DataConnectionDialog dialog = new DataConnectionDialog();            //添加数据源列表,可以向窗口中添加自己程序所需要的数据源类型            dialog.DataSources.Add(DataSource.SqlDataSource);            dialog.DataSources.Add(DataSource.OdbcDataSource);            dialog.DataSources.Add(DataSource.AccessDataSource);            //Sql Server            dialog.SelectedDataSource = DataSource.SqlDataSource;            dialog.SelectedDataProvider = DataProvider.SqlDataProvider;            //mdb            //dialog.SelectedDataProvider = DataProvider.OleDBDataProvider;            //dialog.SelectedDataSource = DataSource.AccessDataSource;            //Oracle            //dialog.SelectedDataSource = DataSource.OracleDataSource;            //dialog.SelectedDataProvider = DataProvider.OracleDataProvider;            //只能够通过DataConnectionDialog类的静态方法Show出对话框            //不能使用dialog.Show()或dialog.ShowDialog()来呈现对话框            if (DataConnectionDialog.Show(dialog, this) == DialogResult.OK)            {                txtConnectionString.Text = dialog.ConnectionString;            }        }
0 0
原创粉丝点击