从app config获取连接字符串 [英] Get connection string from app config
本文介绍了从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屋!
查看全文