I have recently installed Visual Studio Community 2022 and started creating a .NET Windows Form (WinForms) app.
The application is being used to replace an Excel Workbook which contained a series of VBA macros.
I need to store a table of approximately 20 columns and 50 rows in my application. A combobox will be used to display a list based on the first column and a series of textboxes will be populated based on the combobox selection. The table will not be updated by any user inputs or selections; it will only be used to populate the combobox and textboxes based on existing entries.
The table values were previously stored in an Excel Sheet which made it simple to load into a combobox or textbox.
I would like to receive advise on the most efficient way to store the table of data in Visual Studio for my Windows Form. I have read a lot of information relating to data tables, databases etc., although am not sure i understand the best method to store my data table.
Can anyone recommend the best method for storing a table of approximately 20 columns and 50 rows? Is there a method to import the table from a spreadsheet or text file into my application?
Appreciate any advise which can be offered.