Click here to Skip to main content
15,888,039 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Which CheckBox was clicked in a CheckBoxList Pin
Christian Graus18-Dec-08 17:33
protectorChristian Graus18-Dec-08 17:33 
GeneralRe: Which CheckBox was clicked in a CheckBoxList Pin
Ekjon18-Dec-08 18:45
Ekjon18-Dec-08 18:45 
QuestionAJAX User Controls Access from inside or outside assembly Pin
Leo Smith18-Dec-08 9:39
Leo Smith18-Dec-08 9:39 
QuestionWhy can I not update node attribute right after node created? Pin
crystal915418-Dec-08 6:43
crystal915418-Dec-08 6:43 
AnswerRe: Why can I not update node attribute right after node created? Pin
Christian Graus18-Dec-08 11:19
protectorChristian Graus18-Dec-08 11:19 
QuestionHow to refresh WebForm from the client side after clicking the drop down list? Pin
raziknp18-Dec-08 4:12
raziknp18-Dec-08 4:12 
AnswerRe: How to refresh WebForm from the client side after clicking the drop down list? Pin
Rutvik Dave18-Dec-08 4:44
professionalRutvik Dave18-Dec-08 4:44 
QuestionSqlTransaction Pin
vjvjvjvj18-Dec-08 3:41
vjvjvjvj18-Dec-08 3:41 
Hi,

Probably this is not a question to ask in this forum . but I could not decide. Just putting things in abstract level. I have a primary function which insert some rows to DB0 tables and calls subFun1 and SubFUn2 who connection to different databases and insert some rows in tables in there.
Say I get error in subFun2 function I need to rollback everything what was inserted till that point from DB0 tables, DB1 tables and may from DB2 tables also. How to achive that here?

If exception occurs in subFun2, it will throw exception to primary function and only DB2 and DB0 transactions will be rolled back but not from the DB1 transactions. Any workaround for this

sub primaryfunction()

try
SqlConnection0 = Connection to DB0
SqlTransaction0

Insert/Update some table

call function SubFun1
call function subFun1
call function subFun2

SqlTransaction0.commit()

catch exception
SqlTransaction0.rollback()
end sub

sub SubFun1
try
SqlConnection1 = Connection to DB 1
SqlTransaction1

call function SubFun1
call function subFun1
call function subFun2
SqlTransaction1.commit()

catch exception
SqlTransaction1.rollback()
throw exception
end sub

sub SubFun2
try
SqlConnection2 = connection to DB2
SqlTransaction2

Insert/Update some table

SqlTransaction2.commit()
catch exception
SqlTransaction2.rollback()
throw exception
end sub
AnswerRe: SqlTransaction Pin
Parwej Ahamad18-Dec-08 5:00
professionalParwej Ahamad18-Dec-08 5:00 
QuestionRequest.querystring Problem. Pin
kavitha_blueindia18-Dec-08 3:15
kavitha_blueindia18-Dec-08 3:15 
AnswerRe: Request.querystring Problem. Pin
Abhijit Jana18-Dec-08 3:22
professionalAbhijit Jana18-Dec-08 3:22 
GeneralRe: Request.querystring Problem. Pin
kavitha_blueindia18-Dec-08 4:29
kavitha_blueindia18-Dec-08 4:29 
AnswerRe: Request.querystring Problem. Pin
Nishant Singh18-Dec-08 4:08
Nishant Singh18-Dec-08 4:08 
GeneralRe: Request.querystring Problem. Pin
J4amieC18-Dec-08 5:15
J4amieC18-Dec-08 5:15 
QuestionHow to change the color of Div based scrolls in Mozilla firs fox ? Pin
King Shez18-Dec-08 3:08
King Shez18-Dec-08 3:08 
AnswerRe: How to change the color of Div based scrolls in Mozilla firs fox ? Pin
Abhijit Jana18-Dec-08 3:17
professionalAbhijit Jana18-Dec-08 3:17 
QuestionParameter Field in CR - VS 2005 Pin
BalasubramanianK18-Dec-08 0:42
BalasubramanianK18-Dec-08 0:42 
Questiontracing indivisual machine by server Pin
snehasish18-Dec-08 0:20
snehasish18-Dec-08 0:20 
AnswerRe: tracing indivisual machine by server Pin
Christian Graus18-Dec-08 0:25
protectorChristian Graus18-Dec-08 0:25 
GeneralRe: tracing indivisual machine by server Pin
snehasish18-Dec-08 19:06
snehasish18-Dec-08 19:06 
QuestionUnicode problem in asp.net2.0 Pin
sbua18-Dec-08 0:17
sbua18-Dec-08 0:17 
AnswerRe: Unicode problem in asp.net2.0 Pin
Expert Coming18-Dec-08 0:45
Expert Coming18-Dec-08 0:45 
GeneralRe: Unicode problem in asp.net2.0 Pin
sbua18-Dec-08 0:54
sbua18-Dec-08 0:54 
GeneralRe: Unicode problem in asp.net2.0 Pin
Expert Coming18-Dec-08 0:56
Expert Coming18-Dec-08 0:56 
GeneralRe: Unicode problem in asp.net2.0 Pin
sbua18-Dec-08 1:06
sbua18-Dec-08 1:06 

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.