I want to create an Invoice-Entry-Form for my application.
Each item of the invoice will be written to an item table, which will have it's QUANTITY, DESCRIPTION and UNIT PRICE columns shown on the form's DataGrid.
The same DataGrid will need a 4th AMOUNT column that I dont want to be part of the table, because its values will be calculated at runtime and they wont be stored after execution.
How do I add this column to the DataGrid so I'll later be able to dump the calculated values to its cells as well as sum them up to a Total lable?
The other thing - Whenever I insert a new record to a DataGrid, it seems to insert the blank record at random possitions in the table.
How do I make the grid to always insert the new records at the bottom of the grid?