Table gets clased if it is user by multiple users on IIS using ASP.NET

There is a problem with your table structure. You have item code and Bill no and so on... All these field values will be entered by you and not generated by system. So, you cannot identify when you save data about your transaction with others. You can do like this:

Have a integer, identity column in the table and make it primary key. So, whenever you enter a bill information first it should save a record in the database on form opening and get you back the id (primary key) of your transaction and store this id in your form. While saving the data, you need to use the id and update the other information. This will make sure that no two user's data gets clubbed or clashed any time.

Alter table temp_purchsebill add ID int identity(1,1) not null

Actually i have to generate bill for the medicine in pharmacy  depending on the individual patient requirements. So i have to use my website to generate bill and it has to be used simultaneously by different users. Now  what the problem i am facing is if my website used by 2 users ( in A system i enter some tablets  for the patinet 1 and billing the amount, in B system  i am entering some tablets for Patient B and billing it... its two different Bill... ) entered tablets from the two system gets clashed...I mean i m entering doloper tablet from system A and Anacin tablet from B system...Both they should not get clashed.  But now it shows both those two tablets in both the system. it shows all the tablets together  entered from system A and System B.....I hope now u can understand my problem...


  Any idea brother......

What exactly you want.
What if they are sharing the data,I am not getting whats the point.

brother ...sqltransaction means...i dont know really...i m fresher...how can i use that one...

whatever you do, do it in sqltransaction.


Hope this helped, Check this is correct answer if it is.