datasetconfiguration.cs

水晶报表

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 System.Data.OleDb;

public class DataSetConfiguration
{
    private const string CONNECTION_STRING = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Visual Studio 8\Crystal Reports\Samples\en\Databases\xtreme.mdb";
    private const string QUERY_STRING = "SELECT * FROM CUSTOMER";
    private const string DATATABLE_NAME = "Customer";
    private const string DIRECTORY_FILE_PATH = "";

    public static DataSet CustomerDataSet
    {
        get
        {
            DataSet dataSet = new DataSet();
            dataSet.ReadXmlSchema(@"C:\Documents and Settings\dholmes\Desktop\CS_Web_Data_DataSets\XMLSchema.xsd");
            OleDbConnection oleDbConnection = new OleDbConnection(CONNECTION_STRING);
            OleDbDataAdapter oleDbDataAdapter = new OleDbDataAdapter(QUERY_STRING, oleDbConnection);
            oleDbDataAdapter.Fill(dataSet, DATATABLE_NAME);
            return dataSet;
        }
    }


}