时间:2016年08月16日17:54:03 星期二 ken
======================
APP。config配置如下:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings >
<add name="strCon" connectionString="server=127.0.0.1;user id=root; password=cms1005; database=uestc_infosoft; pooling=false;port=8500"/>
</connectionStrings>
<appSettings>
<add key="ConnectionString" value="server=127.0.0.1;user id=root; password=cms1005; database=uestc_infosoft; pooling=false;port=8500"/>
<add key="ConStringEncrypt" value="true"/>
</appSettings>
</configuration>
主要是数据库操作:
方法一: string _connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["strCon"].ToString();
方法二: string _connectionString = ConfigurationManager.AppSettings["ConnectionString"];
==================================================
2、检查连接字符串是否可以连接数据库
SqlConnection _connection;
if (_connection == null)
{
_connection = new SqlConnection(ConnectionString);
_connection.Open();
}
else if (_connection.State == System.Data.ConnectionState.Closed)
{
_connection.Open();
}
else if (_connection.State == System.Data.ConnectionState.Broken)
{
_connection.Close();
_connection.Open();
}
return _connection;
-------------------------------------------------------
5、执行查询语句,返回DataSet
DataSet ds = new DataSet();
SqlDataAdapter command = new SqlDataAdapter(SQLString, Connection);
command.Fill(ds, "ds");
Connection.Close();
========================================
http://www.cnblogs.com/rainman/archive/2012/03/13/2393975.html
http://www.cnblogs.com/shenchao/p/3779983.html