problem with ADO :problem with inserting row in the same time
-
Hi, I make a registration form but I have problem when 20 members register in the SAME TIME , what is the best strategy to handle this problem with inserting row in the same time using ado 2.0 and example if available.
-
Hi, I make a registration form but I have problem when 20 members register in the SAME TIME , what is the best strategy to handle this problem with inserting row in the same time using ado 2.0 and example if available.
Honeyboy_20 wrote:
I have problem
What are the symptoms? What database? What sort of client (Web, WinForms, etc.)?
-
Hi, I make a registration form but I have problem when 20 members register in the SAME TIME , what is the best strategy to handle this problem with inserting row in the same time using ado 2.0 and example if available.
-
Hi, I make a registration form but I have problem when 20 members register in the SAME TIME , what is the best strategy to handle this problem with inserting row in the same time using ado 2.0 and example if available.
IMO, you don't have too much of an issue while doing an insert. An update or delete can create more issues in terms of concurrency. However, you can run a check on all existing users to probably check if the user does not already exist.
Too much of heaven can bring you underground Heaven can always turn around Too much of heaven, our life is all hell bound Heaven, the kill that makes no sound
-
Hi, I make a registration form but I have problem when 20 members register in the SAME TIME , what is the best strategy to handle this problem with inserting row in the same time using ado 2.0 and example if available.
-
Hi, I make a registration form but I have problem when 20 members register in the SAME TIME , what is the best strategy to handle this problem with inserting row in the same time using ado 2.0 and example if available.
As you can see from the responses you have gathered here, people are having a real problem understanding what the issue you are suffering really is. As a hint, when posting a question, try to put in as much relevant detail as you can. A description of what you are trying to achieve, along with a relevant code snippet, details of your expected output and a description of the error will help you get a detailed answer to your problem. If you could edit your question to include this information, I look forward to helping you.
Forgive your enemies - it messes with their heads
My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility
-
Hi, I make a registration form but I have problem when 20 members register in the SAME TIME , what is the best strategy to handle this problem with inserting row in the same time using ado 2.0 and example if available.
SCOPE_IDENTITY()
Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost
-
Hi, I make a registration form but I have problem when 20 members register in the SAME TIME , what is the best strategy to handle this problem with inserting row in the same time using ado 2.0 and example if available.
in the end it is not a problem. A database will handle each insert seperately so it will not add two or more rows at once.
In Word you can only store 2 bytes. That is why I use Writer.
-
in the end it is not a problem. A database will handle each insert seperately so it will not add two or more rows at once.
In Word you can only store 2 bytes. That is why I use Writer.
I'make asp project but my problems happens when over 20 users register in the same time , i found that only 3 users register in db however all 20 users received message that they made registration successfully.
-
I'make asp project but my problems happens when over 20 users register in the same time , i found that only 3 users register in db however all 20 users received message that they made registration successfully.
do you use statics or some kind?
In Word you can only store 2 bytes. That is why I use Writer.
-
do you use statics or some kind?
In Word you can only store 2 bytes. That is why I use Writer.
No Static
-
No Static
is there a try catch around the sqlCommand and is the possible exception caught and stored somewhere? That might give a better indictation
In Word you can only store 2 bytes. That is why I use Writer.
-
Hi, I make a registration form but I have problem when 20 members register in the SAME TIME , what is the best strategy to handle this problem with inserting row in the same time using ado 2.0 and example if available.
i am interesting about your system,it's a useful one with large amount of people? i think if members aren't concentrated at the same time ,you can delay some seconds to release the charge!