我在以前用delphi编程时,数据连接信息一般保存在IniFile中,其中密码(Password)进行加密。C#编程,我将连接参数则存放在XML文件中,并对密码加密。一个XML文件中可存放多个连接。
数据源连接参数存放XML文件如下:
<?
xml version="1.0" encoding="utf-8" standalone="yes"
?>
< Connections >
< Connection name ="kkerp" desc ="开开集团ERP数据库" type ="SQL" >
< Param name ="DataSource" caption ="Data Source" value ="(local)" />
< Param name ="UserID" caption ="User ID" value ="sa" />
< Param name ="DatabaseName" caption ="database" value ="kkerp" />
< Param name ="IntegratedSecurity" caption
< Connections >
< Connection name ="kkerp" desc ="开开集团ERP数据库" type ="SQL" >
< Param name ="DataSource" caption ="Data Source" value ="(local)" />
< Param name ="UserID" caption ="User ID" value ="sa" />
< Param name ="DatabaseName" caption ="database" value ="kkerp" />
< Param name ="IntegratedSecurity" caption