嗨 我的项目是发票管理,我有一些表格,例如客户详细信息,项目和我将计算与项目表混淆了,因为这是我的第一个无法正确设计的项目 项目表中我有项目编号,描述,数量,donumber,dodate和cusid等字段. 项目编号,描述,数量-从动态文本框中获取值并将其保存在数据表中-以插入数据库. 如何添加其他三个值? Donumber我必须使我们成为主键,在我的下一张表中它将是外键.请帮助 谢谢
Hi My project is invoice Management i have tables like customer details , Items & Calculation i am confused with the Item Table since this is my first project not able to design properly item table i have fields like Item No,Description,Qty,donumber,dodate and cusid. Item No,Description,Qty - taking value from dynamic textbox and save it in datatable -to insert database. how do i add the other three values? Donumber i have to make us primarykey and in my next table it will be foreign key. pls help Thanks
推荐答案您可以从这里学习如何设计数据库.... www.databaseanswers/data_models/ [ ^ ] Hi, You Can learn from Here How to Design Database.... www.databaseanswers/data_models/[^]
更多推荐
sql数据库中的表设计
发布评论