问题描述
我在SQL SERVER 2005数据库中有一个名为"CusInvoice"的表
``CusInvoice''具有一列``CusInvoiceID''
``CusInvoieID''是(主键)和(是身份)
Vb.Net 2008中与此表相关的数据集的"AutoIncrement"也为true.
该软件适合单用户运行.
对于多用户网络用户:他们连接到此SQL Server
如果多个用户同时添加新用户.它们被分配了相同的自动编号.不幸的是，他们都无法保存.
我该如何编程以使两者具有由服务器或数据集分配的不同的自动编号.表适配器管理器不自行管理
I have a table in SQL SERVER 2005 Database called ''CusInvoice''
''CusInvoice'' have a column ''CusInvoiceID''
''CusInvoieID'' is a (Primary key) and (Is Identity)
A databset in Vb.Net 2008 relating to this table has also its ''AutoIncrement'' to true.
The software runs fine for single user.
For multiuser-network users : They connect to this SQL Server
If more than one user Add New at the same time. They are assigned the same autonumber. and unfortunatly none of them can save.
How can I program to let both have differnt autonumber assigned by the Server or by the dataset. Table Adaptor Manager is not managing itself
推荐答案
这篇关于Vb.net自动增量和SQL SERVER身份增量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！