Data Entry in ASP.Net web application

[Sinha's]

Hello experts,

I have a web application in ASP.Net (C#) and SQL Server 2005. In the application the end user can enter the customer record. When one end user use the application and enter customer record it works fine. But whenever more then one end user try to enter record at same time then it shows an error. The error message shows the violation of primary key constrain.

NB: The two end user log in to the application with different user id and their records are also different. But they can't enter data at the same time.

Please help me out.

[kvprajapati]

>The error message shows the violation of primary key constrain.

Write a store-procedure which inserts if concern primary key is not found in a database. Please show us your code.

[reach_yousuf]

In your table make Primary Key columns as Identity columns as much as possible !!!

Mark as solved if it helps you!!!

[webnhosting]

hi these are the possible solutions for this
- create the primary key column as autogenerate/Identity Column
- use proper locking mechanish while inserting new records in table
- create before insert trigger to generate the primary key

[dnanetwork]

http://www.15seconds.com/issue/030604.htm
http://www.asp.net/data-access/tutorials/implementing-optimistic-concurrency-vb

[Sinha's]

hi these are the possible solutions for this
- create the primary key column as autogenerate/Identity Column
- use proper locking mechanish while inserting new records in table
- create before insert trigger to generate the primary key

Hi webnhosting,

Thanks for your suggestion. Well the primary key column is auto generated i.e. customer_id.
I think the lock mechanism will work while inserting the record. Can you give me a bit detail about the locking.

Regards,
Umesh Sinha

[kvprajapati]

Read sknake's post - http://www.daniweb.com/forums/thread224795.html