62,268
社区成员
发帖
与我相关
我的任务
分享public class Location : ConfigurationElement
{
[ConfigurationProperty("computer",
IsRequired = true)]
public string Computer
{
get { return (string)base["computer"]; }
set { base["computer"] = value; }
}
[ConfigurationProperty("port",
IsRequired = true)]
public int Port
{
get { return (int)base["port"]; }
set { base["port"] = value; }
}
[ConfigurationProperty("location",
IsRequired = true)]
public Location Location
{
get { return (Location)base["location"]; }
set { base["location"] = value; }
}
[ConfigurationProperty("endpoint",
IsRequired = true)]
public string Endpoint
{
get { return (string)base["endpoint"]; }
set { base["endpoint"] = value; }
}
}
//web.config 里的连接方法1:
<connectionStrings>
<add name="sqlConn" connectionString="Server=(local);DataBase=SmartWeb;User ID=sa;Password=" providerName="System.Data.SqlClient"/>
</connectionStrings>
//读取方法:
using System.Data.SqlClient; //引入此命名空间
using System.Collections;
string strConn = ConfigurationManager.ConnectionStrings["sqlConn"].ToString();
SqlConnection conn = new SqlConnection(strConn);
//----------------------------------------------------------------------------------------------------------
//web.config 里的连接方法2:
<appSettings>
<add key="sqlConn" value="server=(local);database=smartweb;uid=sa;pwd="/>
</appSettings>
//读取方法:
using System.Data.SqlClient; //引入此命名空间
using System.Collections;
string strConn = System.Web.Configuration.WebConfigurationManager.AppSettings["sqlConn"].ToString();
SqlConnection conn = new SqlConnection(strConn);
//====================================================================
//ACCESS连接方法:
<appSettings>
<add key="accessConn" value="provider=microsoft.jet.oledb.4.0;data source="/>
<add key="dbPath" value="~/App_Data/SmartWeb.mdb"/>
</appSettings>
//读取方法:
using System.Data.OleDb; //引入此命名空间
string strconn = System.Configuration.ConfigurationManager.AppSettings["accessConn"].ToString()
+ System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"]) + ";";
OleDbConnection conn = new OleDbConnection(strconn);
try
{
conn.Open();
Response.Write("连接成功");
conn.Close();
}
catch (Exception ex)
{
Response.Write("数据库连接失败:错误信息: <br/>" + ex.ToString());
}