Data Connection Dialog (直接调用内置数据源连接对话框)
来源:互联网 发布:北京加工中心编程招聘 编辑:程序博客网 时间:2024/04/29 14:14
winform程序,在发布时往往需要更改数据库连接字符串,而数据库采用附加的方式配置数据库连接字符串,可以使用VS2005的配置界面来处理
引用C:/Program Files/Microsoft Visual Studio 8/Common7/IDE 里面的Microsoft.Data.ConnectionUI.Dialog.dll。
<!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
-->using Microsoft.Data.ConnectionUI;
private void button1_Click(object sender, EventArgs e)
{
DataConnectionDialog dia=new DataConnectionDialog ();
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
-->using Microsoft.Data.ConnectionUI;
private void button1_Click(object sender, EventArgs e)
{
DataConnectionDialog dia=new DataConnectionDialog ();
dia.DataSources.Add(DataSource.SqlDataSource);
dia.SelectedDataProvider = DataProvider.SqlDataProvider;
if (DataConnectionDialog.Show(dia, this) == DialogResult.OK )
{
string myConnect = dia.ConnectionString;
MessageBox.Show(myConnect);
}
}
}
dia.SelectedDataProvider = DataProvider.SqlDataProvider;
if (DataConnectionDialog.Show(dia, this) == DialogResult.OK )
{
string myConnect = dia.ConnectionString;
MessageBox.Show(myConnect);
}
}
}
为了保存数据库字符串,我们需要更改VS的配置文档(程序的connectString在配置文件内)。.exe文件的配置文件为.exe.config;在同一目录下
<!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
-->XmlDocument myDoc = new XmlDocument();
XmlElement myXmlElement;
myDoc.Load(Application.ExecutablePath + ".config");
XmlNode myNode = myDoc.SelectSingleNode("//connectionStrings");
myXmlElement = (XmlElement)myNode.SelectSingleNode("//add [@name='NXY.Properties.Settings.nxyInfoConnectionString']");
myXmlElement.SetAttribute("connectionString", myConnect);
myDoc.Save(Application.ExecutablePath + ".config");
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
-->XmlDocument myDoc = new XmlDocument();
XmlElement myXmlElement;
myDoc.Load(Application.ExecutablePath + ".config");
XmlNode myNode = myDoc.SelectSingleNode("//connectionStrings");
myXmlElement = (XmlElement)myNode.SelectSingleNode("//add [@name='NXY.Properties.Settings.nxyInfoConnectionString']");
myXmlElement.SetAttribute("connectionString", myConnect);
myDoc.Save(Application.ExecutablePath + ".config");
相对应的XML文件
<!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--><?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="NXY.Properties.Settings.nxyInfoConnectionString" connectionString="Data Source=SC440;Initial Catalog=nxyInfo;Persist Security Info=True;User ID=sa;Password=sa"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--><?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="NXY.Properties.Settings.nxyInfoConnectionString" connectionString="Data Source=SC440;Initial Catalog=nxyInfo;Persist Security Info=True;User ID=sa;Password=sa"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
- Data Connection Dialog (直接调用内置数据源连接对话框)
- 直接调用内置数据源连接对话框(C#/VB.NET2005源码)
- 直接调用内置数据源连接对话框(C#/VB.NET2005源码)
- 对话框 data-rel=dialog
- 03-java连接数据库,直接连接,不配置DSN(Data Source Name)数据源名称
- Android对话框dialog大全(代码直接可用)
- 如何利用connection对象连接数据源
- 封装好的Android对话框Dialog,包含了丰富的dialog样式、点击事件数据回传接口。直接调用封装好的方法即可操作dialog
- 如何在weblogic中配置连接池和数据源以便在jsp中直接调用
- Android 对话框(Dialog)
- 对话框(Dialog box)
- 对话框(Dialog)
- Dialog(对话框)
- 对话框(Dialog):
- mui dialog(对话框)
- 3.dialog实现,直接可复制调用
- mms建立数据连接过程(data connection)
- activex ocx插入、调用dialog对话框
- 发布封装OTL的COM组件VC71的源码
- 在myEclipse中编程注意
- 请为sourceforge的社区选择大奖投票
- 关于这个blog
- extjs和servlet数据交互的例子
- Data Connection Dialog (直接调用内置数据源连接对话框)
- 《BREW进阶与精通——3G移动增值业务的运营、定制与开发》连载之6---移动增值业务概述
- 水
- oracle 格式化基础
- 设置网页快捷键原理
- Everyday GIT With 20 Commands Or So
- 《BREW进阶与精通——3G移动增值业务的运营、定制与开发》连载之7---WAP,SMS,MMS,移动电子邮件
- 有关C与C++的一些概念
- 35岁前的人生