Internal Supply Chain, Visibility via 200 plus 3D Chart Reports - Part II

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Data;


namespace ISCMS.DataAccess.Order
{
    class Sales : ISCMS.DataAccess.Access
    {
        public System.Data.DataSet GetList()
        {
            System.Data.DataSet data = new DataSet();
            con = new OleDbConnection(connection);
            dsCommand = new OleDbCommand();
            dsCommand.Connection = con;

            try
            {
                con.Open();
                dsCommand.CommandText = "select * from Goods";
                IDataReader dr = dsCommand.ExecuteReader();
                data.Tables.Add("List");
                data.Load(dr, LoadOption.OverwriteChanges, "List");
                dr.Close();
            }
            catch
            {
                throw new ApplicationException("Data error.");
            }
            finally
            {
                con.Close();
            }
            return data;
        }
    }
}