public static void Run()
        {
            //ExStart:GroupingData
            // The path to the documents directory.
            string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

            // Create a connection object, specify the provider info and set the data source.
            OleDbConnection con = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" + dataDir + "Northwind.mdb");

            // Open the connection object.
            con.Open();

            // Create a command object and specify the SQL query.
            OleDbCommand cmd = new OleDbCommand("Select * from [Order Details]", con);

            // Create a data adapter object.
            OleDbDataAdapter da = new OleDbDataAdapter();

            // Specify the command.
            da.SelectCommand = cmd;

            // Create a dataset object.
            DataSet ds = new DataSet();

            // Fill the dataset with the table records.
            da.Fill(ds, "Order Details");

            // Create a datatable with respect to dataset table.
            DataTable dt = ds.Tables["Order Details"];

            // Create WorkbookDesigner object.
            WorkbookDesigner wd = new WorkbookDesigner();

            // Open the template file (which contains smart markers).
            wd.Workbook = new Workbook(dataDir+ "TestSmartMarkers.xlsx");

            // Set the datatable as the data source.
            wd.SetDataSource(dt);

            // Process the smart markers to fill the data into the worksheets.
            wd.Process(true);

            // Save the excel file.
            wd.Workbook.Save(dataDir+ "output.xlsx");
            //ExEnd:GroupingData
            
        }
 public OleDbCommand(string p, OleDbConnection con)
 {
     // TODO: Complete member initialization
     this.p = p;
     this.con = con;
 }
예제 #3
0
 public OleDbCommand(string p, OleDbConnection con)
 {
     // TODO: Complete member initialization
     this.p   = p;
     this.con = con;
 }