c# cash register logging

[Dresse]

Hello

I'm wondering what the easiest solution is for logging each sale that has been made.
I just need to keep track of the total cost per sale and at the end of the day I want to make a report that counts all the sales made today and makes a total.

Currently i'm just writing data to a textfile, so when I press a button I get an overview of every sale that has been made.
But this method is a little basic, is it better to just write every sale made in a database table?
Any ideas what solution I could use best?

regards

Drese

[RedSon]

First you should look at how you are using the data. Make a list of all the operations you do on it. What kind of reports are you making? Are you analyzing anything? Are you doing any math on the data, like finding aggregates, or averages or anything like that?

Next think about how long the data needs to stay around, who uses it, do I need to back it up or share it? Should it be encrypted? Do I keep customer information with it?

Then you might have a better idea of what technology to use to store your data.

[tlhintoq]

Database tutorial Part 1
Database tutorial Part 2

[Dresse]

Dear RedSon

- The sales must be kept per day, and at the end of the day they will print the total sales of that day
normally it wasn't needed to keep logs, however it could prove useful to store the information of each day

- With reports I actually meant printing data from a datagrid, I made a class that provides a printlayout and prints a nice table of the data in the datagrid.

- I don't want to analyze, encrypt or keep any sensitive data like customer information.

- I am developing this for mentally disabled people by using a touchscreen. However the printing of the totals and management of the items is done by the employees there.

Regards

Dresse