c＃为购买相册的客户创建发票。 [英] c# create invoice for a customer that buys an album.

问题描述

我正在编写一个跟踪专辑（音乐）的程序。



我的数据库看起来像这样：



数据库（简单）



它在荷兰语，但它归结为：



Klant table保存有关客户的信息（名称等）



相册表包含有关相册的信息。



订单表保存有关哪个客户/日期/付款和订单的信息



Order_Items保存哪些专辑和一张客户的专辑数量买了。



也不是所有桌子都只是我需要的。





我想做一个这样的表格：



销售表格



白色字段是列表视图设置为详细信息。我希望能够选择一个客户。然后我希望能够添加相册，之后我应该点击生成发票，它需要为客户生成发票。 （Crystal报道？）



你们能指点我正确的方向吗？

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?

推荐答案

开始学习首先是ADO.NET。检查这些。一位CP成员为像你这样的人（初学者）写过一堆文章（在ADO.NET上）。

为初学者使用ADO.NET [ ^ ]

使用DataGrid控件 [ ^ ]

面向初学者的ADO.NET数据库操作 [ ^ ]

填充数据fr在ComboBox中的数据库 [ ^ ]

Start learning ADO.NET first. Check these. One CP member wrote more than bunch of articles(on ADO.NET) for people like you(beginner).
Using ADO.NET for beginners[^]
Using the DataGrid Control[^]
Database Manipulation with ADO.NET for beginners[^]
Populate data from database in a ComboBox[^]

这篇关于c＃为购买相册的客户创建发票。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！