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

Question

I have created a website which I am hosting using IIS. I have just discovered that if two people are accessing the site at the same time, they are sharing the DATA . Does anyone have any suggestions ??..... Thanks!

Below is my table structure ::

CREATE TABLE [dbo].[Temp_PurchaseBill](
    [ITEMCODE] [varchar](50) NULL,
    [ITEMDESCRIPTION] [varchar](100) NULL,
    [BRAND] [varchar](50) NULL,
    [BatchNo] [varchar](20) NULL,
    [ExpiryDate] [datetime] NULL,
    [ITEMUNIT] [varchar](50) NULL,
    [PURCHASERATE] [numeric](12, 2) NULL,
    [MRP] [numeric](12, 2) NULL,
    [QTY] [numeric](12, 2) NULL,
    [PackQTY] [numeric](12, 2) NULL,
    [FreeQTY] [numeric](12, 2) NULL,
    [StockQTY] [numeric](12, 2) NULL,
    [VATOn] [varchar](30) NULL,
    [ITEMRATE] [numeric](12, 2) NULL,
    [MRPRATE] [numeric](12, 2) NULL,
    [VatPercentage] [numeric](12, 2) NULL,
    [VatTotal] [numeric](12, 2) NULL,
    [FreeVatAmt] [numeric](12, 2) NULL,
    [TaxScheme] [varchar](30) NULL,
    [DiscountOption] [varchar](30) NULL,
    [DiscPer] [numeric](12, 2) NULL,
    [DiscTotal] [numeric](12, 2) NULL,
    [TotalAmount] [numeric](12, 2) NULL,
    [BillNO] [varchar](20) NULL,
    [BillDate] [datetime] NULL,
    [MrpAbate] [numeric](12, 2) NULL,
    [VatOptions] [varchar](50) NULL,
    [TaxType] [varchar](50) NULL,
    [IPAddress] [varchar](50) NULL
) ON [PRIMARY]

in IPAddress column I am getting IPaddress of a client system. Even though , the table gets clashed ... Any idea frnds...Its URGENT....

Please Help me...Thanks in advance

Akkiraju Ivaturi · Answer

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(11) not null

sathish kumar · Answer

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......

Akkiraju Ivaturi · Answer

Can you be little bit clear in what you need? The question is not easy to understand.

Sukesh Marla · Answer

What exactly you want. What if they are sharing the dataI am not getting whats the point.

sathish kumar · Answer

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

Sukesh Marla · Answer

whatever you do do it in sqltransaction. Hope this helped Check this is correct answer if it is.