TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
sathish kumar
NA
117
165.3k
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
Reply
Answers (
6
)
ASP and c#
gridview related problem