【asp】asp.net DbProviderFactory的使用－示例-net-DbProviderFactory

欢迎您访问我爱IT技术网，今天小编为你分享的编程技术是：【asp.net DbProviderFactory的使用－示例】，下面是详细的讲解！

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: 在此处添加构造函数逻辑
//
}
}

关于asp.net DbProviderFactory的使用－示例的用户互动如下：

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细