Click here to Skip to main content
15,888,454 members
Home / Discussions / C#
   

C#

 
AnswerRe: c# Pin
V.14-Feb-13 21:08
professionalV.14-Feb-13 21:08 
GeneralRe: thank you Pin
Azza ALbelushi15-Feb-13 0:04
Azza ALbelushi15-Feb-13 0:04 
GeneralRe: thank you Pin
V.15-Feb-13 0:05
professionalV.15-Feb-13 0:05 
AnswerRe: c# Pin
Richard MacCutchan14-Feb-13 23:11
mveRichard MacCutchan14-Feb-13 23:11 
GeneralRe: c# Pin
Azza ALbelushi14-Feb-13 23:58
Azza ALbelushi14-Feb-13 23:58 
AnswerRe: How to Send SMS Messages from C# ? Pin
jschell15-Feb-13 9:18
jschell15-Feb-13 9:18 
AnswerRe: How to Send SMS Messages from C# ? Pin
Amir Mohammad Nasrollahi29-Jul-13 22:15
professionalAmir Mohammad Nasrollahi29-Jul-13 22:15 
QuestionC# SqlTransaction Pin
Hbr_Tha_real14-Feb-13 8:25
Hbr_Tha_real14-Feb-13 8:25 
Hy guys...

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
AnswerRe: C# SqlTransaction Pin
R. Giskard Reventlov14-Feb-13 8:42
R. Giskard Reventlov14-Feb-13 8:42 
GeneralRe: C# SqlTransaction Pin
Hbr_Tha_real14-Feb-13 9:08
Hbr_Tha_real14-Feb-13 9:08 
GeneralRe: C# SqlTransaction Pin
R. Giskard Reventlov14-Feb-13 9:46
R. Giskard Reventlov14-Feb-13 9:46 
GeneralRe: C# SqlTransaction Pin
Hbr_Tha_real14-Feb-13 11:17
Hbr_Tha_real14-Feb-13 11:17 
GeneralRe: C# SqlTransaction Pin
R. Giskard Reventlov14-Feb-13 11:46
R. Giskard Reventlov14-Feb-13 11:46 
QuestionClassic ASP and C# syntax Pin
vanikanc14-Feb-13 8:11
vanikanc14-Feb-13 8:11 
AnswerRe: Classic ASP and C# syntax Pin
vanikanc14-Feb-13 10:54
vanikanc14-Feb-13 10:54 
Questionalphanumeric counter Pin
Angela Scheuvront14-Feb-13 7:41
Angela Scheuvront14-Feb-13 7:41 
AnswerRe: alphanumeric counter Pin
Jibesh14-Feb-13 9:04
professionalJibesh14-Feb-13 9:04 
GeneralRe: alphanumeric counter Pin
Matt T Heffron14-Feb-13 9:28
professionalMatt T Heffron14-Feb-13 9:28 
GeneralRe: alphanumeric counter Pin
Jibesh14-Feb-13 9:29
professionalJibesh14-Feb-13 9:29 
GeneralRe: alphanumeric counter Pin
Matt T Heffron14-Feb-13 9:13
professionalMatt T Heffron14-Feb-13 9:13 
QuestionRe: alphanumeric counter Pin
Matt T Heffron14-Feb-13 9:52
professionalMatt T Heffron14-Feb-13 9:52 
AnswerRe: alphanumeric counter Pin
Angela Scheuvront14-Feb-13 10:15
Angela Scheuvront14-Feb-13 10:15 
GeneralRe: alphanumeric counter Pin
Matt T Heffron14-Feb-13 10:25
professionalMatt T Heffron14-Feb-13 10:25 
GeneralRe: alphanumeric counter Pin
Angela Scheuvront15-Feb-13 1:45
Angela Scheuvront15-Feb-13 1:45 
AnswerRe: alphanumeric counter Pin
Richard Deeming15-Feb-13 1:37
mveRichard Deeming15-Feb-13 1:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.