Multiple users inserting record at same time
-
Hi, I tried with "SqlTransaction" for multiple users inserting record at same time in my sample application , it is working fine in my sample application,It is not working in my Project , this project has one dynamic page in this page has 5 dynamic textboxes and 2 dropdown lists these controls i created in Page_PreInit and i need to save these controls data in database sqlserver 2005 , data saving properly in my system with vs2008,i created virtual directory for my project then we are trying to insert record then it inserting records is done successfully but data is not correctly inserted (data is been swapped between two user or more) Regards, Vishnu.
-
Hi, I tried with "SqlTransaction" for multiple users inserting record at same time in my sample application , it is working fine in my sample application,It is not working in my Project , this project has one dynamic page in this page has 5 dynamic textboxes and 2 dropdown lists these controls i created in Page_PreInit and i need to save these controls data in database sqlserver 2005 , data saving properly in my system with vs2008,i created virtual directory for my project then we are trying to insert record then it inserting records is done successfully but data is not correctly inserted (data is been swapped between two user or more) Regards, Vishnu.
vishnukamath wrote:
data is been swapped between two user or more)
I guess you may be using some global state. Are you using
static(sharedin VB) variables?Best wishes, Navaneeth
-
Hi, I tried with "SqlTransaction" for multiple users inserting record at same time in my sample application , it is working fine in my sample application,It is not working in my Project , this project has one dynamic page in this page has 5 dynamic textboxes and 2 dropdown lists these controls i created in Page_PreInit and i need to save these controls data in database sqlserver 2005 , data saving properly in my system with vs2008,i created virtual directory for my project then we are trying to insert record then it inserting records is done successfully but data is not correctly inserted (data is been swapped between two user or more) Regards, Vishnu.
-
vishnukamath wrote:
data is been swapped between two user or more)
I guess you may be using some global state. Are you using
static(sharedin VB) variables?Best wishes, Navaneeth
hi, Thanks for the reply. but what do you exactly mean to say by '
global state
'. Is it necessary to use for multiple users inserting records at same time into the same table. Regards, Vishnu
-
Hope this[^]and Big resource[^] will give you an idea.
With Regards, Kasson. When there is a conflict between the heart and the brain, let the heart be followed
Hi, Thank you for your reply , But i'm using Asp.net 3.5 with c# and sql server 2005, not VB 6.0. Regards, Vishnu.
-
hi, Thanks for the reply. but what do you exactly mean to say by '
global state
'. Is it necessary to use for multiple users inserting records at same time into the same table. Regards, Vishnu
-
Hi , Thank you for your reply, Multiple users accessing same dynamic page ,if two users trying to insert on same page and same table , it is inserting two records but first record or second might be getting null values in all columns in table. please suggest me better way. Regards, Vishnu.
-
Hope this[^]and Big resource[^] will give you an idea.
With Regards, Kasson. When there is a conflict between the heart and the brain, let the heart be followed
Hi , My issue Solved , so don't waste your valuable time. Regards, Vishnu.