[RESOLVED] Help with Design please

I am rewriting a program originally created in VB6. I have data that was originally displayed in an MSFlexGrid (see attachment). The highlighted rows are user input and the others are calculated based on input. Under the "Fixed Expenses" heading, the user can insert as many rows as needed and the bottom rows are calculated based on the combined sections.

I am struggling with the best way to do this in VB.NET. My initial thought was to do in a DataGridView and just create placeholders in the database for the rows so they show correctly when populated. Although not 100% sure that will work like I want it to.

I am new to VB.NET, so any suggestions would be greatly appreciated.

Attachment 181770

Thank you,
Chrissy

You can certainly use a DataGridView. You'd use it unbound so you can control each cell and its formatting and whether it can be edited. You would populate a DataTable from the database and then copy the data across to those expense rows in the grid. After the user makes the desired modifications, you can copy the changes back to the DataTable and then save to the database. You can insert or remove rows in the grid as desired as expenses change.

Quote:

---

Originally Posted by jmcilhinney

You can certainly use a DataGridView. You'd use it unbound so you can control each cell and its formatting and whether it can be edited. You would populate a DataTable from the database and then copy the data across to those expense rows in the grid. After the user makes the desired modifications, you can copy the changes back to the DataTable and then save to the database. You can insert or remove rows in the grid as desired as expenses change.

---

Thanks for the response... I will move ahead using the DataGridView.
Chrissy :)