Eip调用其它数据库链接字符串
更新时间:2019-03-08 09:32:10 访问量:
有的时候可能要对接一些接口,但用户直接提供的是数据库的链接字符串这时候需要用到以下方式调用:
protected void Page_Load(object sender, EventArgs e)
{
string SQL = "Select top 1 Dust,Date From DustRecord Where DeviceID=5559 Order By Date Desc";
/// SQL = " select top 1 Whir_U_Content_PID as Dust from Whir_U_Content ";
Database db = DB;
DataTable DustRecord = db.Query(SQL).Tables[0];
Response.Write(DustRecord.Rows[0]["Dust"].ToStr());
}
public static Database DB
{
get
{
// confing/ConnectionStrings.config 中定义链接字符串
return new Whir.Repository.Database(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["sqlserver_DustRecord"].ConnectionString, "System.Data.SqlClient");
}
}
自己根据需求相应的 做些调整即可!