 |
The Simple Table Listing Program Using a Data Grid in VB.NET Lists the Contents of glmaster Using a DataReader in SQL |
SELECT command: SELECT * FROM glmaster
| MAJOR | MINOR | SUB1 | SUB2 | ACCOUNT DESCRIPTION | BALANCE |
| 1000 | 1000 | 0 | 0 | Cash Operating Houston B and T AN 213-765-9 | 167953 |
| 1000 | 2000 | 0 | 0 | Cash Payroll Houston B and T AN 213-765-8 | 46178 |
| 1000 | 3000 | 0 | 0 | Cash Field Houston B and T AN 213-765-7 | 1260 |
| 1000 | 4000 | 0 | 0 | Cash Petty Houston B and T AN 213-765-6 | 700 |
| 1100 | 1 | 0 | 0 | CD 3456-8765-1 11-22-97 | 100000 |
| 1100 | 2 | 0 | 0 | CD 3456-8766-1 12-21-97 | 100000 |
| 1300 | 1000 | 0 | 0 | Acct Recv Credit Master Inc., Omaha Nebraska | 183765 |
| 1300 | 2000 | 0 | 0 | Acct Recv EuroCard, Ltd., London, England | 46320 |
| 1300 | 3000 | 0 | 0 | Acct Recv PacCard, Inc, Tokyo, Japan | 113232 |
| 1700 | 1000 | 0 | 0 | Furniture and Fixtures | 23450 |
| 1700 | 2000 | 0 | 0 | Copier Xerox 4455676-98f | 4530 |
| 1800 | 1000 | 0 | 0 | Accum Depreciation -- Furniture and Fixtures | -12543 |
| 1800 | 2000 | 0 | 0 | Accum Depreciation -- Copier | -1150 |
| 1900 | 1000 | 0 | 0 | Prepaid Rent | 0 |
| 1900 | 2000 | 0 | 0 | Prepaid Insurance | 0 |
| 1900 | 3000 | 0 | 0 | Prepaid Interest | 0 |
| 1900 | 9000 | 0 | 0 | Other Assets | 4760 |
| 2000 | 1000 | 0 | 0 | Accounts Payable | -3240 |
| 2000 | 2000 | 0 | 0 | Notes Payable | -148532 |
| 2400 | 1000 | 0 | 0 | FIT Payable | 0 |
| 2400 | 4000 | 0 | 0 | FICA Payable | 0 |
| 2400 | 5000 | 0 | 0 | Federal Withholding Payable | 0 |
| 2500 | 1000 | 0 | 0 | Texas Sales Tax Payable | -9000 |
| 2600 | 1000 | 0 | 0 | Insurance Withholding | 0 |
| 2600 | 2000 | 0 | 0 | Credit Union Withholding | 0 |
| 2600 | 3000 | 0 | 0 | Union Dues Withholding | 0 |
| 3000 | 1000 | 0 | 0 | Common Stock | -500000 |
| 3000 | 2000 | 0 | 0 | Preferred Stock | 0 |
| 3000 | 3000 | 0 | 0 | Treasury Stock | 0 |
| 3000 | 4000 | 0 | 0 | Capital Contributions | 0 |
| 3000 | 5000 | 0 | 0 | Paid in Capital in excess of Par | -20000 |
| 3000 | 6000 | 0 | 0 | Earnings | -96708 |
| 4000 | 1000 | 0 | 0 | Fees | 0 |
| 4000 | 2000 | 0 | 0 | Claims | 0 |
| 4000 | 3000 | 1000 | 0 | Capt Webb Internet Store Revenues | 0 |
| 4000 | 3000 | 2000 | 0 | Houston Walk-in Store Reevnues | 0 |
| 4000 | 3000 | 3000 | 0 | Catalog Revenues | 0 |
| 5000 | 1000 | 1000 | 0 | Direct Labor - Internet Store Operations | 0 |
| 5000 | 1000 | 2000 | 0 | Direct Labor - Walkin Store Operations | 0 |
| 5000 | 1000 | 3000 | 0 | Direct Labor - Catalog Operations | 0 |
| 6000 | 1000 | 1000 | 0 | Direct Labor - Maintenance Internet Store | 0 |
| 6000 | 1000 | 2000 | 0 | Direct Labor - Maintenance Walk-in Store | 0 |
| 6000 | 1000 | 3000 | 0 | Direct Labor - Maintenance Catalog | 0 |
| 7000 | 1000 | 1000 | 0 | Direct Labor - Supervisory Internet Store | 0 |
| 7000 | 1000 | 2000 | 0 | Direct Labor - Supervisory Walk-in Store | 0 |
| 7000 | 1000 | 3000 | 0 | Direct Labor - Supervisory Catalog | 0 |
| 8000 | 1000 | 1000 | 0 | Direct Labor - Parttime Internet Store | 0 |
| 8000 | 1000 | 2000 | 0 | Direct Labor - Parttime Walk-in Store | 0 |
| 8000 | 1000 | 3000 | 0 | Direct Labor - Parttime Catalog Store | 0 |
| 9000 | 1000 | 0 | 0 | Office Lease | 0 |
| 9000 | 2000 | 0 | 0 | Auto and Travel Expenses | 0 |
| 9000 | 3000 | 0 | 0 | Dues and Subscriptions | 0 |
| 9000 | 4000 | 0 | 0 | Insurace Exepnse | 0 |
| 9000 | 5000 | 0 | 0 | Office Supplies | 0 |
| 9000 | 6000 | 0 | 0 | Telephone Expenses | 0 |
| 9000 | 7000 | 0 | 0 | Electrical Expenses | 0 |
| 9000 | 8000 | 0 | 0 | Water and Garbage | 0 |
| 9000 | 9000 | 0 | 0 | Gas | 0 |
| 9100 | 1000 | 0 | 0 | Interest Expense | 0 |
| 9999 | 9999 | 0 | 0 | SUSPENSE | -975 |
Sum of Balances=0
Row Count=60
Normal Termination 11/23/2009 6:10:04 AM