如何使用DBConnection方法从webconfig访问连接字符串 [英] how to access connection string from webconfig using DBConnection method

问题描述

使用网络应用程序

in Appcode-> DAL-> class DBbridge.cs

using web application
in Appcode->DAL-> class DBbridge.cs

public static string DBConnection()
       {
           try
           {
               return System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];

           }
           catch (Exception ce)
           {

              throw new ApplicationException("Unable to get DB Connection string from Config File. Contact Administrator" + ce);
           }
       }

在web.config中

while in web.config

<connectionStrings>
    <add name="ConnectionString" connectionString="Data Source=.;Integrated Security=true;Initial Catalog=szicExam" providerName="System.Data.SqlClient"/>
  </connectionStrings>

但我收到此错误

值不能为空。

参数名称：connectionString

but i am getting this error
Value cannot be null.
Parameter name: connectionString

Line 490:        public static DataSet ExecuteDataset(string connectionString, CommandType commandType, string commandText, params SqlParameter[] commandParameters)
Line 491:        {
Line 492:            if (connectionString == null || connectionString.Length == 0) throw new ArgumentNullException("connectionString");
Line 493:
Line 494:            // Create & open a SqlConnection, and dispose of it after we are done

Source File: f:\My Final Project with Data\MCQs Test System\MCQs Test System\App_Code\DAL\SQLHelper.cs    Line: 492 

推荐答案

使用此

use this

System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"];

代替

in place of

System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];

试试这个

Try this

string conStr = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

http://stackoverflow.com/questions/6134359/read-connection-string-from-web-config [<一个HREF =http://stackoverflow.com/questions/6134359/read-connection-string- from-web-configtarget =_ blanktitle =New Window> ^ ]



http://msdn.microsoft.com/en-us/library/ms178411.aspx [ ^ ]



< a href =https://www.google.co.in/search?q=how+to+access+connection+string+from+webconfig+using+DBConnection+method+Vote%3A++++++++++++++++ +参见+更多％3A + C％23ASP.NETArchitect&安培; OQ =如何+访问+使用+ DBConnection的+方法+投票％3A连接+字符串+从+ webconfig + ++++++++参见+更多％ 3A + C％23ASP.NETArchitect& aqs = chrome..69i57& sourceid = chrome& ie = UTF-8＃q = access + connection + string + in + web + config>点击此处获取更多信息





问候......：）

http://stackoverflow.com/questions/6134359/read-connection-string-from-web-config[^]

http://msdn.microsoft.com/en-us/library/ms178411.aspx[^]

Click here for more


regards...:)

这篇关于如何使用DBConnection方法从webconfig访问连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！