Please edit your post and do the following:
1. Change title to something more descriptive than "C#". You're in the C# forum, people tend to assume the question is related to C#.
2. Remove the bold text and use the code button in the toolbar (enters the pre tags in the text, your code needs to be between pre tags)
3: Remove User Id and especially password from your connection string and replace with dummy text. Never ever give user id's and password in clear text. Even if it is just a test database.
4: Improve your language a little, even if you're not native English, a space here, a spell check there can work miracles.
5: Maybe related to #4, but I haven't understood the core problem
6: "please guide me tosolve this problem as soon as possible" -> Don't count on it. At best it will work just the opposite way. We're not here to serve you, we're here at our own free will and will help if we can, or want to and we will assign as much time to it as we wish.
On the positive side. You did do some research, you did post some code.
I am facing a serious problem, with c# sqlTransaction,
The thing is, i have about 7 different tables that i execute a single transactions against(with a their autoIncrement IDs), which works fine for a single user when trying to insert new record... now the problem started when 10 users were capturing the information together and sometimes do concurent transections where the first user submits the form and the transaction starts(e.g at ID 1001), and user number 2 (few seconds after the 1st user) submits as well and get the second(1002) for the 1st and 2nd table, but for some reason(network signal maybe) 1st user insert is slow and and 2nd user's signal(speed) is faster and then the 2nd user ends up getting the 1st ID of the 3rd and the rest of the tables and the 1st user will get the second ID that was assigned to the 2nd user in the 1st 2 tables........
i think the problem here is the isolation mode which i didn't(or couldn't) set for the insert query to prevent the concurent insertion...
If i'm wrong please kindly correct me.
Now what i'm asking is you guys to help me control this...
The languages i'm using is/are..
1.c# in Visual studio 2010
2.Ms sql server 2008 r2
3. and asp.net...
I'd really appreciate ur help...
I'm sorry about the grama, English is not my home languege. thank you in advanve
thanx there man, the solution was to add and IsolationMode(Serializable)........
THANX once again, but u kinda ranked me too low with ur "if u thinking hiring a prof programmer wait till u hire an amatuer...".... i'm way better than an amatuer that this quiz may have reflected of me.... but i'll never stop learning
THANX once again, but u kinda ranked me too low with ur "if u thinking hiring a
prof programmer wait till u hire an amatuer...".... i'm way better than an
amatuer that this quiz may have reflected of me.... but i'll never stop learning
Er, that's just part of my sig. It was said by Red Adair[^] and is spot on but wasn't directed at you!
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum
Do you just need code to generate the strings in that sequence or do you need conversion to/from int?
The implementations likely will be quite different depending on the answer.
(Code based on the code you've posted assumes all you need is the strings in sequence. And never needing to start mid-sequence!)