Last post May 20, 2011 03:01 AM by KumarHarsh
May 18, 2011 06:23 AM|tofoolee|LINK
I'm using tableadapter in my DAL layer, eveything was working fine if there's only one user executing query. However, when I tested it in a multi-user environment it seems that it only execute one transaction (one insert query) , although, we had try to
excute the query concurrently 10 user at once. Please let me know how to solve this, cause i'll need them urgently. Thanks
May 18, 2011 06:32 AM|farukinfo|LINK
What type of problem your are facing, is it throwing exception?. If then please provide the exception message and stack trace if possible.
May 18, 2011 07:29 AM|tofoolee|LINK
It didn't throw any exception, it just didnt do anything, as if it dies of in the middle of the process after we concurrently click save (which run the query)
May 18, 2011 08:39 AM|farukinfo|LINK
Better provide your code here.
May 18, 2011 10:50 PM|tofoolee|LINK
Ok, but i guess that's not much coding as the whole application was built on the use of .XSD files with Table Adaptors, we're using the BLL and DAL just like the tutorial below, in fact we referring to them.
May 19, 2011 10:48 PM|Decker Dong - MSFT|LINK
In my mind, this problem is dealing with Concurrency of GridView or TableAdapter, maybe you should have a good look at this:
May 20, 2011 03:01 AM|KumarHarsh|LINK
Thorughly check the code and its property,if there is any lock define.
http://msdn.microsoft.com/en-us/library/aa581776.aspx (check "Create the Query Graphically, through the Query Editor")