asp.net DbProviderFactory的使用－示例

　　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 产品名 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();//创建连接

　　con.ConnectionString = connectionString;

　　DbCommand cmd = factory.CreateCommand();//创建命令

　　cmd.CommandText = queryString;

　　cmd.CommandType = CommandType.Text;

　　cmd.Connection = con;

　　DbDataAdapter dapter = factory.CreateDataAdapter();//创建适配器

　　dapter.SelectCommand = cmd;

　　dapter.Fill(dataSet);//填充

　　return dataSet;

　　}

　　}

　　public OrderInfoConfiguration()

　　{

　　//

　　// TODO: 在此处添加构造函数逻辑

　　//

　　}

　　}