|
|
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using System.Data.Common;
/// <summary>
/// OrderInfoConfiguration 的摘要說明
/// </summary>
public class OrderInfoConfiguration
{
private const string connectionString=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Program Files/TutorialSampleCodeProjects/xtreme.mdb";
private const string queryString="SELECT a.[Order Date] AS 訂單時間,a.[Order ID] AS 訂單號,b.[Last Name]+/" /"+b.[First Name] AS 員工姓名,c.[Customer Name] AS 客戶姓名,d.[Product Name] AS 產(chǎn)品名 FROM Orders a,Employee b,Customer c,Product d ,[Orders Detail] e WHERE a.[Employee ID]=b.[Employee ID] AND a.[Customer ID]=c.[Customer ID] AND a.[Order ID]=e.[Order ID] AND e.[Product ID]=d.[Product ID]";
public static DataSet OrderInfoDataSet
{
get
{
DataSet dataSet = new DataSet();
DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb"); //獲取工廠
DbConnection con = factory.CreateConnection();//創(chuàng)建連接
con.ConnectionString = connectionString;
DbCommand cmd = factory.CreateCommand();//創(chuàng)建命令
cmd.CommandText = queryString;
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
DbDataAdapter dapter = factory.CreateDataAdapter();//創(chuàng)建適配器
dapter.SelectCommand = cmd;
dapter.Fill(dataSet);//填充
return dataSet;
}
}
public OrderInfoConfiguration()
{
//
// TODO: 在此處添加構(gòu)造函數(shù)邏輯
//
}
}
DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb"); //獲取工廠 這句就可以獲得一個工廠，用這個工廠就可發(fā)生產(chǎn)該數(shù)據(jù)提供程序的各種對象了。
如果是連接
SqlServer：DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.SqlClient");
Oracle:DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OracleClient");
ODBC:DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.Odbc");
使用了這個，要是想換個數(shù)據(jù)庫，是不是很方便了呢？呵呵。
AspNet技術(shù)：asp.net DbProviderFactory的使用－示例，轉(zhuǎn)載需保留來源！
鄭重聲明：本文版權(quán)歸原作者所有，轉(zhuǎn)載文章僅為傳播更多信息之目的，如作者信息標(biāo)記有誤，請第一時間聯(lián)系我們修改或刪除，多謝。
