从app config获取连接字符串 [英] Get connection string from app config

问题描述

如何从应用配置中检索连接字符串？



这是我的app配置：

 < ？xml version =   1.0？>  
< configuration> 
< configSections> 
 < /   configSections  >  
< connectionStrings> 
 
< add name =   SqlConnectionString connectionString =   Data Source =（local）; Initial Catalog = retriever; User ID = sa providerName =   System.Data.SqlClient /> 
 
 < /   connectionStrings   >  
< startup> 
 
< supportedRuntime version =   v2.0.50727 /> < span class =code-keyword>< /   startup  >  
 < /  配置 >  <这是我的代码：
 
 
 
 
  public  SqlConnection SQcon = System.Configuration.ConfigurationManager.ConnectionStrings [  SqlConnectionString]; 
  public  SqlCommand SQcmd; 
  public  SqlDataReader SQread; 
  public  SqlDataAdapter SQadapt; 
  public  SqlException SQexcept; 
  public   string  SQdatasource =   SELECT * FROM dbo.Tick_Inventory ORDER BY invoiceDate_time; 
  public   int  ProductCountHolder; 
  public   string 门票; 
 
 
 
 
 
 
 
然而我收到错误
 
 on < pre lang =c＃>  public  SqlConnection SQcon = System.Configuration.ConfigurationManager.ConnectionStrings [  SqlConnectionString]; 
 

如何解决这个问题？

解决方案

ConnectionStrings collection不返回SqlConnection对象。这是一个字符串。你需要的是：

 SqlConnection connection =  new  SqlConnection（ConfigurationManager） .ConnectionStrings [  SqlConnectionString]。ConnectionString）; 

试试这个..

 SqlConnection con = new SqlConnection（ConfigurationSettings.AppSettings [ConnectionString]。ToString（ ））; 

 SqlConnection con =  new  SqlConnection（ConfigurationManager） .AppSettings [  ConnectionString]。ToString（））; 

How can I retrieve my connection string from my app config?

here is my app config:

<?xml version="1.0"?>
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
     
        <add name="SqlConnectionString" connectionString="Data Source=(local);Initial Catalog=retriever;User ID=sa" providerName="System.Data.SqlClient"/>
     
    </connectionStrings>
    <startup> 
        
    <supportedRuntime version="v2.0.50727"/></startup>
</configuration>

here is my code:

public SqlConnection SQcon = System.Configuration.ConfigurationManager.ConnectionStrings["SqlConnectionString"];
       public SqlCommand SQcmd;
       public SqlDataReader SQread;
       public SqlDataAdapter SQadapt;
       public SqlException SQexcept;
       public string SQdatasource = "SELECT * FROM dbo.Tick_Inventory ORDER BY invoiceDate_time";
       public int ProductCountHolder;
       public string Tickets;

however im getting an error
on

public SqlConnection SQcon = System.Configuration.ConfigurationManager.ConnectionStrings["SqlConnectionString"];

how to fix this?

解决方案

ConnectionStrings collection does not return the SqlConnection object. It is a string. What you need is:

SqlConnection connection = new SqlConnection (ConfigurationManager.ConnectionStrings["SqlConnectionString"].ConnectionString);

try this..

SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"].ToString());

SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString());

这篇关于从app config获取连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！