Hi,
I'm trying to use MySQL database for IBuySpy ASP Starter Kit.
I can connect to database to retreive info, but I always get the following error from executing"GetProductDetails()" function in ProductsDB.cs file:
Specified cast is not valid
myProductDetails.ModelNumber = (string)parameterModelNumber.Value;
This error dissapears when I modify the above line to:
myProductDetails.ModelNumber = parameterModelNumber.Value.ToString();
Apparently, "ExecuteNonQuery()" returns nothing when I checked in debug mode.
I'm still not sure whether this is caused by ExecuteNonQuery() or "ParameterDirection.Output" implementation in ProductsDB.cs.
Does MySQL support ParameterDirection implementation? If doesn't, what is the alternative way to implement? Can anyone give me an example?
Thanks.
Regards,
Gywer