p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   ASP.NET 2.0 Professional (http://p2p.wrox.com/forumdisplay.php?f=215)
-   -   ICallbackEventHandler.GetCallbackResult Problem (http://p2p.wrox.com/showthread.php?t=69993)

tropicalpisces August 11th, 2008 01:04 PM

ICallbackEventHandler.GetCallbackResult Problem
 
Hello, I've been trying to use ICallbackEventHandler, it works fine with simple scripts and computations. however once I try using it with queries and stored procedure i now have problems. Below is the code i'm using for the Function GetCallbackResult() As String Implements ICallbackEventHandler.GetCallbackResult. The stored procedure spProcessTxn is called properly but suddenly ends after 10-20 seconds and the code returns a successful message, however upon checking it in the database no transaction was processed. Before trying to implement the ICallbackEventHandler the same code is called in a different function and it usually takes 4-5 minutes after executing the stored procedure.

        Try
            sqlcmd = New SqlCommand("spProcessTxn", _
                  New SqlConnection(strConn))
            sqlcmd.CommandType = CommandType.StoredProcedure
            sqlcmd.Parameters.AddWithValue("@repdateinput", strRepdate)
            sqlcmd.Connection.Open()
            'set time out to 10 minutes
            sqlcmd.CommandTimeout = 600
            sqlcmd.ExecuteNonQuery()
            sqlcmd.Connection.Close()

            Return "Transactions have been processed successfully." Catch ex As Exception
            Me.Results.ForeColor = Drawing.Color.Red
            Return "Error Processing Transactions"
        End Try



thanks



All times are GMT -4. The time now is 11:48 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.