How to Make a Desktop Application work over LAN Environment for Multiple Users

Question

0.00/5 (No votes)

See more:

Hi,
I have created an application in Vb.net with SQL Server as Database which works fine
on single PC. But Currently, it is installed on Multiple PCs with a central Database. Multiple users are using over LAN Environment and if suppose they work on the same screen and save a transaction at the same time the Transaction ID Field is duplicated. The Transaction ID Field is set to varchar (predefined format like S000001) in the database.

How to resolve this issue, Please Help as I am a beginner in development.

Thanks.

Posted 8-May-12 19:00pm

David Nathan A

Add a Solution

Comments

Maciej Los 9-May-12 4:16am

Why ID field is set to varchar? If the predefined format is: S000001 try to add additional field like HelpId int and set it as autoincrement.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2012-05-08T19:17:00

Solution 1

You need to look into your DB design. If inserting a record is creating a duplicate key, then there is some serious issue. Short term fix can be using Transactions. Either at SQL level or code level.

Here:
MSDN: BEGIN TRANSACTION (Transact-SQL)[^]
SQL Server Transactions and Error Handling[^]

MSDN: Local Transactions[^]
Using Transactions in ADO.NET[^]

Posted 8-May-12 19:17pm

Sandeep Mewara

Comments

Maciej Los 9-May-12 4:11am

Good answer, my 5!

Sandeep Mewara 9-May-12 4:46am

Thanks.

Wendelius · Answer 2 · 2012-05-09T11:17:00

Solution 2

This sounds like you're trying to generate a surrogate key by your code. If that's the case, don't do it.

Instead use the database to create a unique value, for example uniqueidentifier[^].

Also if not already done so, you should define this column as the primary or secondary key.

Posted 9-May-12 11:17am

Wendelius