C#操作SQL Server数据库 Asp.net

时间:2016年08月16日17:54:03 星期二  ken

======================

C# 读取 appconfig文件配置数据库连接的方法

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