Has anyone seen this error before?

[Zarcom]

I am using a sql command object for a stored procedure that does a simple update. However when my code reaches the .executeNonQuery() line it dies with this error


System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.FormatException: Input string was not in a correct format. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()


Thanks

 

[Zarcom]

s'ok I got it. I had changed the sql store procedure. Once you do this you need to refresh the server Explorer tab in the development environment, delete the old sqlcommand, drag a new one onto the interface and rename it to the same name as the old sqlcommand. This way the parameters of the stored procedure are properly set and have the correct data types