July 27, 2008 at 11:18 pm
I am passing three parameters to a stored procedure,and received an error
Failed to convert parameter value from a SqlParameter to a String.
the parameters i am passing are :
year
month
status
year and month are of datetime datatype in database
status is of nvarchar datatype.
pls kindly help mee to rectify it.
July 28, 2008 at 6:57 am
You need to post the .NET code associated with the Exception for us to assist with this. It sounds like a simple syntax error, but I can't tell without the code.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
October 16, 2008 at 1:30 am
The first thing to remember is that the data to be passing in the Stored procedure must be of same datatype as declared for the particular parameter, and if not, try to send the valule in string and in the stored procedure convert that value as per the requirement.
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply