SQL vb.net return exception

Question

I have the following query

DS = SqlHelper.ExecuteDataset(ConfigurationManager.AppSettings("ADOConnectionString"), CommandType.StoredProcedure, "duMaurier", params)

I want to call this in a try

Catch ex As Exception
    Return "this"
End Try

How do I return a specific message of the error that prevents it running?

Can you share the full function code please, I can't understand what kind of return you want. — MrAlex6204
– MrAlex6204, Commented May 25, 2015 at 16:37

nhgrif · Accepted Answer · 2015-05-25 16:09:35Z

2

.message is a property of the exception.

Return ex.message 'This is the string message of the error description

nhgrif

62.2k25 gold badges136 silver badges174 bronze badges

answered May 25, 2015 at 16:08

DiscipleMichael

5102 silver badges19 bronze badges

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

1 Comment

Thanks for the edit nhgrif. I somehow didn't hit the code option

MrAlex6204 · Accepted Answer · 2015-05-25 16:08:14Z

-1

Like this

 Catch ex As Exception
       Throw New Exception("This is may handle exception Error")
 End Try

answered May 25, 2015 at 16:08

MrAlex6204

1677 bronze badges

Return and rethrow are not the same thing.