How to Save Datagridview Items within a Column?

Question

I’m creating a Budget Form, similar to the one in the photo:

As you can see, on the New button, I have a new line in the bank with the budget number in the field Código and the customer in the field NomeCliente. But when it comes to adding the parts and services, I have no idea how I do it. They’re on datagrid with various fields Part code, Name, units, unit value, Discount and total value.

When finished adding all the items in datagrid through the products and services form, I can not insert the lines within the bank, so when consult again the budget they appear in the datagrid.

Can someone give me a hand with an idea of how to do it? I’m still about to start the project.

then comes the doubt:

Which database to use? Would you have any way to do this with Access 2003, or some newer version? Or should I insert a database into SQL Server?

Grateful.

Answer 1

This is a classic case of master-detail. There’s a pretty rich explanation for how to do this here, but we can dig a little deeper into the answer.

Access is never very recommended for a database, unless there’s a great reason for it (legacy, for example). The most interesting alternative to Access is SQL Server Localdb, which is practically a portable SQL Server, and whose data file can be imported into an instance of SQL Server transparently.

Answer 2

Hello, Gypsy Morrison Mendez! I started making a system for 1 user too. At first I was accessing Access even, but now that you advised I am looking for other options... Can you tell me why Access is not very recommended? Thank you already!