读取.ini文件里面的连接数据库的代码、读取App.config文件的代码

最新推荐文章于 2022-03-18 17:41:44 发布

幻影cc

最新推荐文章于 2022-03-18 17:41:44 发布

阅读量697

点赞数

分类专栏： SQL数据库操作文章标签：数据库 database string sqlserver server sql

SQL数据库操作专栏收录该内容

2 篇文章 0 订阅

订阅专栏

.ini文件里面的代码：

[sql]
server= 192.168.1.13
uname=sa
pwd=
database=MengYe
[access]
database = weight.mdb
pwd=
[InStorage]
filepath = InStorage.xml

程序里面的代码：

[DllImport("kernel32")]
private static extern int GetPrivateProfileString(string section,string key,string def,StringBuilder retVal,int size,string filePath);

StringBuilder temp = new StringBuilder();
            string filepath = Application.StartupPath + @"\Config.ini";
            GetPrivateProfileString("sql","server","数据库配置出错!",temp,255,filepath);
            string ip = temp.ToString();
            GetPrivateProfileString("sql","uname","数据库配置出错!",temp,255,filepath);
            string uname = temp.ToString();
            GetPrivateProfileString("sql","pwd","数据库配置出错!",temp,255,filepath);
            string pwd = temp.ToString();
            GetPrivateProfileString("sql","database","数据库配置出错!",temp,255,filepath);
            string database = temp.ToString();
            String connString = String.Format("server={0};user id={1};pwd={2};database={3}",ip,uname,pwd,database);

            SqlConnection conn = new SqlConnection(connString);

读取App.config文件的代码

App.config文件的代码：

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add connectionString="server=192.168.1.13;user id=sa;pwd=;database=MengYe" name="sqlserver"/>
<add connectionString="provider=Microsoft.Jet.OLEDB.4.0;Data Source=WeightBill.mdb;Jet oledb:database password=;" name ="access"/>
</connectionStrings>
</configuration>

程序中代码；

加入引用：System.configuration

string connString = ConfigurationManager.ConnectionStrings["sqlServer"].ToString();