Re: Trying to debug an exception

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Frank Rizzo <none@xxxxxxxx> wrote:
> Hello. Every now and then (it's rare), i get an exception when calling
> SqlDataAdapter.Fill. The code is calling a stored procedure and
> attempts to stuff the results into a dataset. It yields the following
> exception. I am trying to understand what the exception is actually
> complaining about. Is it a problem with the data that came back or is
> it an issue inside the stored procedure? Any alternative ways to nail
> down this issue would also be appreciated.

I'd try running SQL Profiler while your program is running - that
should show whether or not an error occurred in the stored proc itself.

--
Jon Skeet - <skeet@xxxxxxxxx>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too
.

Relevant Pages

  • Re: Timeout on populating a datagrid
    ... I'd review the stored procedure SQL in a query tool and see how long ... An unhandled exception occurred during the execution of the ... >Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.framework.aspnet)
  • SqlDataAdapter.Fill returns results of previous command
    ... This code executes successfully at certain points in the application, ... I don't know what the cause of this exception is yet, ... stored procedure was indeed executed on the database. ... The trace shows that the last action on the db was the stored ...
    (microsoft.public.dotnet.framework.adonet)
  • Session_End event, System.NullReferenceException
    ... database table that is used to log user sessions. ... The stored procedure executes successfully, and I can see the updated data in ... an exception is being generated by the code that I'ved added to ... through an execution of the code that led to the exception. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Ignore SQL Server 2000 store proc errors and still get results?
    ... catch (Exception ex) ... > You definitely don't want to do 30 round trips by handling the logic ... > temp table in your stored procedure to handle the collection of valid ... >>> expensive in both server and client code. ...
    (microsoft.public.dotnet.framework.adonet)
  • Random Timeout Exceptions
    ... Let say we have the following stored procedure which returns many records. ... namespace TestApp { ... "*" in application output means catching this exception. ... Usual output is: ...
    (microsoft.public.dotnet.framework.adonet)