name="connectionstringname" connectionstring="data source=服务器名;initial
catalog=数据库名;user id=用户;password=密码"
providername="system.data.sqlclient"/></connectiionstring>直接连接数据库文件(1)在webconfig里配置
<connectionstrings><add name="connectionstringname"
connectionstring="data source=./sqlexpressintegrated
security=sspiAttachDBFilename=|DataDirectory|database.mdf
"providerName="system.data.sqlclient"</connectionsttrings>(2).直接引用SqlConnection
conn = new SqlConnection(Data Source=./SQLExpressIntegrated
Security=SSPIAttachDBFilename=|DataDirectory|database.mdfUser
Instance=true)DataDirectory默认是AppData文件夹,你把mdf文件放到里面,改一下文件名(database.mdf)和连接字符串的一样就行了
WinForm连接字符串app.config(基于.net2.0)首先在项目的属性文件夹下使用 Settings.settings 配置连接字符串,我这里配置了一个 Access数据库
连接保存后VS2005自动生成 app.config文件(修改 Settings.settings配置此文件会自动更新),内容如下:
<?xml version="1.0" encoding="utf-8" ?><configuration> <configSections> </configSections> <connectionStrings>
<add name="frmSignIn.Properties.Settings.DBConnString"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0DataSource=F:/kaifa/frmSignIn/appData/dbqx.mdbPersist
SecurityInfo=TrueJet OLEDB:Database Password=123"providerName="System.Data.OleDb" /> </connectionStrings></configuration>
你可以用i/o来实现。I/O很简单了。也可以用dom4j来实现
下面就是dom4j实现的,要用dom4j需要打俩个jar包
dom4j-1.6.1.jar、jaxen-1.1-beta-7.jar
XML文件的结构如下:
<?xml version="1.0" encoding="GB2312"?>
<value>
<user>
<username>aaaa</username>
<password>1111</password>
<email>2222</email>
<realname>3333</realname>
<sex>dsad</sex>
<nation>dasa</nation>
<province>fdsfsd</province>
<city>dfsd</city>
<postalcode>fsdsd</postalcode>
<telephone>fsdsfs</telephone>
</user>
<value>
你想向<value>节点下再添加一个<user>节点
添加节点的代码如下
public void addinfotoXML(){
try{
File f = new File("C://registerInfo.xml")
SAXReader reader = new SAXReader()
Document doc = reader.read(f)
List list = doc.selectNodes("value" )
Iterator iter = list.iterator()
iter = list.iterator()
if(iter.hasNext()){
Element valueElement = (Element)iter.next()
字串3
Element userElement = valueElement.addElement("user")
}
try{
XMLWriter writer = new XMLWriter(new FileWriter(new File("C://registerInfo.xml")))
writer.write(doc)
writer.close()
}
catch(Exception ex){ ex.printStackTrace()}
}
catch (Exception e) {e.printStackTrace()}
}
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)