How to Save Datagridview items within a column?

Navigation
2

I'm creating a Budgets form, similar to this one in the photo:

As you can see, in the New button, you generate a new row in the bank with the budget number in the Código field and the client in the NomeCliente field. But when it comes to adding parts and services, I have no idea how I do it. They are in datagrid with several fields Part Code, Name, Units, Unit Value, Discount, and Total Value.

When I finish adding all the items in datagrid through the products and services form, I can not insert the lines inside the bank, so when I check the budget again they appear in datagrid itself.

Can anyone help me with an idea how to do it? I'm still starting the project.

Then comes the question:

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

Thank you.

    
asked by anonymous 19.06.2015 / 14:28

2 answers

0

This is a classic case of master-detail. "> There is a very rich explanation of how to do this here , but we can narrow down the answer a little bit.

Access is never very recommendable for a database, unless there is a good 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 transparently imported into an instance of SQL Server.

    
19.06.2015 / 17:46
0

Hello, Gypsy Morrison Mendez! I started making a system for 1 user as well. At first I was accessing same Access, but now that you've advised I'm looking for other options ... Can you tell me why Access is not very recommended? Thank you in advance!

    
05.07.2015 / 04:20
Socket in Java is not printing what it should JavaScript style buttons