예제 #1
0
        public DataSet GetAllItems()
        {
            DataSet ds = null;

            _objDatabaseGateway = new DatabaseGateway(_dbType);

            try
            {
                var query = "SELECT ItemId,ItemName,Quantity FROM TB_ITEMS";
                ds = _objDatabaseGateway.ExecuteDataset(query);
            }
            catch (Exception ex)
            {
                _objLogGateway.Fatal(ex);
            }
            return(ds);
        }