asp.net如何在web.config文件中设置连接到oracle的连接字符串?并取出?

[procedure123]

asp.net如何在web.config文件中设置连接到oracle的连接字符串?并在后台取出?

[laowang134]

<appSettings>
		<!-- 连接字符串是否加密 -->
		<add key="ConStringEncrypt" value="false"/>
		<!-- 连接字符串,(可以扩展支持不同数据库)如果是加密方式，上面一项要设置为true，如果是明文server=127.0.0.1;database=codematic;uid=sa;pwd=,上面设置为false -->
		<add key="ConnectionString" value="server=127.0.0.1;database=codematic;uid=sa;pwd="/><!--8618B53C32BF8E0B6CD3BDFF59B9F24BE1C6D586A5915C8B6DC69A09ABB2DF60A4026BDE8E76B6FDE2BFCEA3FA8E06CB-->
		<add key="ConnectionString2" value="server=127.0.0.1;database=codematic2;uid=sa;pwd="/>
	</appSettings>

using System;
using System.Configuration;
namespace Maticsoft.DBUtility
{
    
    public class PubConstant
    {        
        /// <summary>
        /// 获取连接字符串
        /// </summary>
        public static string ConnectionString
        {           
            get 
            {
                string _connectionString = ConfigurationManager.AppSettings["ConnectionString"];       
                string ConStringEncrypt = ConfigurationManager.AppSettings["ConStringEncrypt"];
                if (ConStringEncrypt == "true")
                {
                    _connectionString = DESEncrypt.Decrypt(_connectionString);
                }
                return _connectionString; 
            }
        }

        /// <summary>
        /// 得到web.config里配置项的数据库连接字符串。
        /// </summary>
        /// <param name="configName"></param>
        /// <returns></returns>
        public static string GetConnectionString(string configName)
        {
            string connectionString = ConfigurationManager.AppSettings[configName];
            string ConStringEncrypt = ConfigurationManager.AppSettings["ConStringEncrypt"];
            if (ConStringEncrypt == "true")
            {
                connectionString = DESEncrypt.Decrypt(connectionString);
            }
            return connectionString;
        }


    }
}

[syb1045]

在AppSetting下增一个
<add key="OracleStr" value="data source=wzd;user=wzd;password=wzd;"/>
string constring =ConfigurationManager.AppSettings["OracleStr"].ToString();
OracleConnection conn = new OracleConnection(constring);//进行连接

[子夜__]

写在web.config中

后台获取的时候用

configurationManager.connectionString["SYXTConnectionString"].ToString()

Web.config中加入

<connectionStrings> <add name="SYXTConnectionString" connectionString="provider=OraOLEDB.Oracle.1;Persist   Security   Info=False;User   ID=UserName;Data   Source=DataBaseName;Extended   Properties='';Password=Password
" /> </connectionStrings>