1、在vs(此处目录文件以vs2010为例)安装目录下(“%visual studio安装目录%/common10/ide/microsoft.data.connectionui.dialog.dll”)找到microsoft.data.connectionui.dll、microsoft.data.connectionui.dialog.dll和汉化资源文件microsoft.data.connectionui.dialog.resources.dll,注意汉化资源文件需要放在zh-chs文件夹下;
2、在工程文件中添加对以上二个dll文件的引用;
3、具体代码如下:
private void button1_click(object sender, eventargs e)
{
dataconnectiondialog dialog = new dataconnectiondialog();
dialog.datasources.add(datasource.accessdatasource);
dialog.datasources.add(datasource.odbcdatasource);
dialog.datasources.add(datasource.oracledatasource);
dialog.datasources.add(datasource.sqldatasource);
dialog.datasources.add(datasource.sqlfiledatasource);
dialog.selecteddatasource = datasource.sqldatasource;
dialog.selecteddataprovider = dataprovider.sqldataprovider;
if (dataconnectiondialog.show(dialog, this) == dialogresult.ok)
{
//conndlg.connectionstring;
}
}
运行效果:
重新打开时展示,之前选择的连接字符串:
dataconnectiondialog dialog = new dataconnectiondialog();
dialog.datasources.add(datasource.accessdatasource);
dialog.datasources.add(datasource.odbcdatasource);
dialog.datasources.add(datasource.oracledatasource);
dialog.datasources.add(datasource.sqldatasource);
dialog.datasources.add(datasource.sqlfiledatasource);
dialog.selecteddatasource = datasource.sqldatasource;
dialog.selecteddataprovider = dataprovider.sqldataprovider;
//之前 dataconnectiondialog 控件保存的连接字符串
dialog.connectionstring = str;
//connectionstring有值,则会显示出来
dataconnectiondialog.show(dialog, this);
以上就是使用visual studio的动态连接库创建通用数据库连接对话框的内容。
