Thread: Inserting Record - Catching Exceptions

Thank you for your detailed solution. 

imchaz -- Here is a better refactoring of one of those methods...   Protected Sub SendEmail_New_New( _ ByVal sender As Object, _ ByVal e As System.EventArgs _ ) Handles sendEmailButton.Click Dim conn As SqlConnection = Nothing Dim myTrans As SqlTransaction = Nothing Try conn = New SqlConnection(GetConnectionString()) conn.Open() myTrans = conn.BeginTransaction() InsertNumberA(conn, myTrans) InsertNumberB(conn, myTrans)...

imchaz: Babunareshnarra: imchaz: 1.  Inserts Record into Table A 2.  Inserts Record into Table B 3.  Sends Email of the Transaction occured. First execute the steps 1 and 2 in a transaction and return a bool value from the method which is performing steps 1 & 2. If it returns true send email else show ur msg. there is another way in ur query check if @param is null if so set @param=0 and use 2 queries one...

Hi imchaz, A transaction is used for database exceptions. Since sending a mail can't cause a sql exception, it'll not impact the finish of a transaction. Thus I just wonder whether you can try to throw a sql exception if the mail server is wrong so that it may let the transaction rollback. Please try it first. Thanks.