Show SQL error in ASP.net

Question

I have the following stored procedure. But I don't know how to throw an error from SQL Server and show it on JavaScript Alert.

Here is the stored procedure

Begin
    if EXISTS(select * from POS_Transactions where ID = @transId) 
    Begin
        declare @totalAmount money

        select @totalAmount = TotalAmount 
        from POS_Transactions 
        where ID = @transId and PAN = @pan

        update pos_transactions 
        set transactiontypeid = 3 
        where id = @transId

        update cardbalance 
        set cardbalance = (cardbalance + @totalAmount),
            totalredemption = (totalredemption - @totalAmount) 
        where pan = @pan
    END
    Else
        --Show Error Here
    BEGIN
END

And here is the VB code:

Try
  If txtEmbossLine.Text <> "" And txtTransactionId.Text <> "" Then
  Utilities.VoidRedemption(txtEmbossLine.Text, txtTransactionId.Text)
  Response.Write("<script>alert('Redemption Voided successfully')</script>")
  Else
  Response.Write("<script>alert('Please enter both fields')</script>")
  End If
Catch ex As Exception
  Response.Write(ex.Message)
End Try

codeproject.com/Articles/38650/…

wiretext
– wiretext

2015-07-22 11:05:19 +00:00
Commented Jul 22, 2015 at 11:05 — wiretext
– wiretext, Commented Jul 22, 2015 at 11:05

Patrick Hofman · Accepted Answer · 2015-07-22 11:03:23Z

1

You can use this code to throw an exception from SQL Server:

throw 50001, 'Some error', 1

Your try ... catch in your C# code will do the rest for you.

answered Jul 22, 2015 at 11:03

Patrick Hofman

158k23 gold badges270 silver badges343 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Musakkhir Sayyed · Accepted Answer · 2015-07-22 11:11:32Z

0

Catch SQL exception in vb.net.

Try
     //Do your stuff
Catch ex as SqlException
  Dim errors = ex.Errors
  // inspect errors to decide if this is the condition you want to catch
  Dim shouldCatch As Boolean = ... 
     // Code that acts on the specific error condition
  If shouldCatch Then
  Else
     Throw // rethrow error
  End If
 End Try

answered Jul 22, 2015 at 11:11

Musakkhir Sayyed

7,21813 gold badges44 silver badges67 bronze badges

Collectives™ on Stack Overflow

Show SQL error in ASP.net

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related