Problem when passing null values to command parameters

[WebNickson]

I have created a command object to call an SP. My parameters consist of integers, strings and dates types.

It is possible that the values I pass to is null or an empty string. This seems to give error to my Command object even though I have routines in the SP to handle null or empty strings.

Can someone advise what is the best approach to such a problem?

rgds,
Nickson

 

[Bob2]

You could check the values before you send them to the SP and take care of null/empty values there.



Regards

M