command3 = New Data.SqlClient.SqlCommand("UPDATE Products SET Stock=" + numU + " Where ProductName='" + proName + "'", connection3)
At the code snippet above, numU is integer and when i execute it in insert at sql server as a double so it throws me an error and says me that its a double and you try to put in integer ...
Why this happens? how can avoid this error?
I ahve visual studio 2005 and when i put my cursor on numU says Dim numU as integer and when i put the cursor to + it says me double...
June 5, 2009 9:19 AM
December 15, 2010 11:11 PM