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