[RESOLVED] Bug !

[angelica]

cant seem to spot the bug! Can anyone please?

---------------------------------------------------
Using cmd1 As New SqlCommand(query, MyConn)

cmd1.CommandType = CommandType.StoredProcedure

..................
..................

cmd1.Parameters.Add("@ReturnErrorText", SqlDbType.NVarChar, (100))
cmd1.Parameters("@ReturnErrorText").Direction = ParameterDirection.Output
cmd1.Parameters.Add("@Success", SqlDbType.Int)
cmd1.Parameters("@Success").Direction = ParameterDirection.Output

MyConn.Open()
cmd1.ExecuteNonQuery()
cmd1.Parameters.Clear()
If Not CStr(cmd1.Parameters("@ReturnErrorText").Value) = String.Empty Then 'if there's error messages from stored proc
MessageBox.Show(CStr(cmd1.Parameters("@ReturnErrorText").Value))
MyConn.Close()
Exit Sub
End If
success = CInt(cmd1.Parameters("@Success").Value)
'before clearing the parameters swap the value of @success to see if Commit transaction is executed
cmd1.Parameters.Clear()

If success = 1 Then
MessageBox.Show("New School has been added SUCCESSFULLY.", " Success", MessageBoxButtons.OK, MessageBoxIcon.Information)

End If

End Using