Click here to Skip to main content
15,910,981 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionHow To Optimize Gif Images ??? It's So Cool To Answer This ??? Pin
Rahul_asp.net26-Apr-07 23:17
Rahul_asp.net26-Apr-07 23:17 
AnswerRe: How To Optimize Gif Images ??? It's So Cool To Answer This ??? Pin
Sathesh Sakthivel26-Apr-07 23:23
Sathesh Sakthivel26-Apr-07 23:23 
QuestionSession timeout Pin
NICE TO MEET26-Apr-07 23:13
NICE TO MEET26-Apr-07 23:13 
QuestionFile Download Feedback/result Pin
theScorp26-Apr-07 23:11
theScorp26-Apr-07 23:11 
QuestionUrgent help in Log4Net Pin
Jia Fang26-Apr-07 22:35
Jia Fang26-Apr-07 22:35 
Questionsql server transactions Pin
wilf5726-Apr-07 21:53
wilf5726-Apr-07 21:53 
AnswerRe: sql server transactions Pin
N a v a n e e t h26-Apr-07 22:41
N a v a n e e t h26-Apr-07 22:41 
GeneralRe: sql server transactions Pin
wilf5726-Apr-07 23:20
wilf5726-Apr-07 23:20 
ok thats the code: I execute it in the gridview_RowCommand()
and on the development system everything is great.

sqlKont = "Update tbnKontBib set fest=fest+ CONVERT( money," & "'" & Komma2Punkt(diffFest) & "') " & _
"where bh='" & Session("bHalle") & "'"

sql = "Insert into tbOrder(artnr, odatum, bh, oanz, opreis, bhoper) Values( " & _
"'" & artnum & "'" & "," & _
"'" & Date.Now.ToShortDateString & "'" & "," & _
"'" & Session("bHalle") & "'" & "," & _
"'" & anzBest & "'" & "," & _
"CONVERT( money," & "'" & Komma2Punkt(preis) & "')" & "," & _
"'" & Session("bUser") & "')"


'Ausfuehrung mit Transaction
Try
t = conn.BeginTransaction
cmd = New SqlCommand(sqlKont, conn)
cmd.Transaction = t
erg = cmd.ExecuteNonQuery()
If erg <> 1 Then 'Fehler
MsgBox("K-Fehler in Bestellung! Bitte Administrator benachrichtigen!", MsgBoxStyle.Critical, "!!! Achtung !!!")
t.Rollback()
GoTo ende
End If

cmd = New SqlCommand(sql, conn)
cmd.Transaction = t
erg = cmd.ExecuteNonQuery()
If erg <> 1 Then 'Fehler
MsgBox("O-Fehler in Bestellung! Bitte Administrator benachrichtigen!", MsgBoxStyle.Critical, "!!! Achtung !!!")
t.Rollback()
GoTo ende
End If
t.Commit()
MsgBox("Ihre Bestellung wurde ausgeführt!", MsgBoxStyle.Exclamation, "Bestellvorgang")
Catch ex As Exception
t.Rollback()
MsgBox("Ihre Bestellung ist fehlgeschlagen! Bitte wiederholen sie die Bestellung.", MsgBoxStyle.Critical, "Bestellvorgang")
End Try
ende: conn.Close()

Bye Wilfried
GeneralRe: sql server transactions Pin
Colin Angus Mackay27-Apr-07 0:47
Colin Angus Mackay27-Apr-07 0:47 
GeneralRe: sql server transactions Pin
wilf5727-Apr-07 1:49
wilf5727-Apr-07 1:49 
GeneralRe: sql server transactions Pin
wilf5727-Apr-07 3:36
wilf5727-Apr-07 3:36 
Questionhyperlinkfield of gridview Pin
Rajeshcross26-Apr-07 21:32
Rajeshcross26-Apr-07 21:32 
Questionhow to create delay at server side function Pin
rama charan26-Apr-07 21:18
rama charan26-Apr-07 21:18 
AnswerRe: how to create delay at server side function Pin
Sathesh Sakthivel26-Apr-07 21:25
Sathesh Sakthivel26-Apr-07 21:25 
AnswerRe: how to create delay at server side function Pin
Mayank Parmar27-Apr-07 0:27
professionalMayank Parmar27-Apr-07 0:27 
Questionupdate in Grid view Pin
Rhydo26-Apr-07 21:11
Rhydo26-Apr-07 21:11 
AnswerRe: update in Grid view Pin
Sathesh Sakthivel26-Apr-07 21:14
Sathesh Sakthivel26-Apr-07 21:14 
GeneralRe: update in Grid view Pin
Rhydo26-Apr-07 21:59
Rhydo26-Apr-07 21:59 
GeneralRe: update in Grid view Pin
Sathesh Sakthivel26-Apr-07 23:06
Sathesh Sakthivel26-Apr-07 23:06 
QuestionASP.Net chat code Pin
Rhydo26-Apr-07 21:08
Rhydo26-Apr-07 21:08 
AnswerRe: ASP.Net chat code Pin
Sathesh Sakthivel26-Apr-07 21:13
Sathesh Sakthivel26-Apr-07 21:13 
GeneralRe: ASP.Net chat code Pin
Rhydo26-Apr-07 22:01
Rhydo26-Apr-07 22:01 
GeneralRe: ASP.Net chat code Pin
Sathesh Sakthivel26-Apr-07 22:59
Sathesh Sakthivel26-Apr-07 22:59 
AnswerRe: ASP.Net chat code Pin
Blue_Boy26-Apr-07 22:18
Blue_Boy26-Apr-07 22:18 
Questionhow to accept only characters in chartxtbox and only numbers in numtxtbox using asp.net? Pin
sathyan_829426-Apr-07 20:59
sathyan_829426-Apr-07 20:59 

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.