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;
}
}
winform中C#调用数据库连接选择对话框
最新推荐文章于 2023-02-23 13:30:50 发布