SQL Output parameters

[neilmcdonald]

Hi,

I have a page with a sqldatasource and a detailsview.

The sqldatasource uses stored procedures for select and update operations.

When the page first loads, everything is fine, the select stored procedure returns three output parameters, which are used to determine which buttons on the page are enabled.

When a button is clicked, the update stored procedure runs, and then I get an error message "Object reference not set to an instance of an object".

This is caused by the select stored procedure not returning any output parameters, despite the input parameters being supplied (I can see this using SQL profiler).

Apologies for the long winded post, but If anyone can shed any light on this I'd be very grateful!

 

[jmeckley]

can't do anything without code. paste the markup and code behind and we may be able to help.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[neilmcdonald]

I resolved this - I has the incorrect type set for the input parameter.

Thanks anyway...