0

I am working on an ERP based project which was created using asp.net(3.0)c# as the front end and sql server(2005) as the back end. We have completed the project but after installation on the client location, when Multiple users Login and use the same form to perform a transaction, then the data for all users is mismatched. While we have Created Seperate userid and Login for all user. Can anybody suggest to me what I should do?


On login form i am checking for user from the database whether the password and username is right or not.

1.SP_1 is executed to insert the data in table one

2 the primary key from table is retrived to aspx.cs page.

3 That primary key is provided to SP_2 along with other parameters to insert into table two.

suppose user one entered the data in header section (for table 1) and added two or more details in detail section (for table 2).using hid id

Also the user two entered the data in header section (for table 1) and added two or more details in detail section (for table 2).using his id

Both they press the save button at the same time

in this some time data of one user is not saving

but if saved then it display the user two data to user one and vice versa.

2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by hericles
0

Are you actually using transactions in your code - blocking a user2's access to the data while user1 is modifying it? It sounds like you aren't which is causing your mismatched data

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.