c# create invoice for a customer that buys an album.

See more:

SQL-Server-2005

C#3.0

C#

, +

I am writing a program that keeps track of albums (music).

My database looks like this:

Database (simple)

Its in dutch but it comes down to this:

Klant table holds information about customers (name and such)

Album table holds information about album.

Order table holds information about which customer/date/payed and the orderid

Order_Items holds which albums and how much albums a customer bought.

also its not all of the tables just the ones im going to need for this.


I want to make a form like this:

Sale Form

the white field is a listview set to detail. I want to be able to choose a customer. Then i want to be able to add albums, after that i should click generate invoice and it needs to generate an invoice for the customer. (Crystal reports?)

Could you guys point me in the right direction?