sathish kumar

sathish kumar

  • NA
  • 117
  • 163.6k

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

Aug 21 2012 5:00 AM
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

Answers (6)