How thanhtin6008/accessdatabase works
This Windows Forms utility combines spreadsheet-to-SQL import with database-oriented code generation. The principal visible workflow starts at ImportData, where the user supplies a workbook, sheet, destination table, and connection details; Form2 also demonstrates reading Excel data, mapping ITEM_INFO records, and bulk-copying them to SQL. Form1 provides a separate schema/entity and mapping-code generation interface and can open Form2. ImportData.cs and several supporting files were not sampled, so links for their internal behavior are omitted where wiring cannot be confirmed.
Main entry points: Form1.cs Generator screen · Form2.cs Import dialog · ImportData.cs Import screen · ExcelReader.cs Excel reader
Components 13
Windows Forms UI
- Application entry
Program.cs - Import screen
ImportData.cs - Generator screen
Form1.cs - Import dialog
Form2.cs
Spreadsheet Import
- Excel reader
ExcelReader.cs
Code Generation
- Mapping metadata
MappingInfo.cs - Table metadata
TableInfo.cs - Column metadata
InfoColum.cs
Data Access
- Item model
DataClasses1.designer.cs - Shared helpers
Helper.cs
Other components
- User
- Excel workbook
- SQL Server
Connections 12
- User → Import screen: sets import inputs
- Application entry → Import screen: launches
- User → Generator screen: uses generator
- Generator screen → Import dialog: opens dialog
- Import dialog → Excel reader: reads workbook
- Excel workbook → Excel reader: provides sheets
- Import dialog → Item model: maps records
- Import dialog → SQL Server: bulk copies
- Generator screen → SQL Server: queries schema
- Generator screen → Mapping metadata: uses mappings
- Generator screen → Table metadata: uses table metadata
- Generator screen → Column metadata: uses column metadata