Are you sure that Price is a char? I would think that it is numeric and you need a conversion from the String in the textbox to the Value of the data column.
HTH ......................... Stephen Russell - Senior Visual Studio Developer, DBA Memphis, TN 901.246-0159 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Vivek Vorani Sent: Monday, December 08, 2008 12:58 PM To: [email protected] Subject: [DotNetDevelopment] SQL UPDATE query error Can someone please tell me why I'm getting an error - "No value given for on more parameters when I execute this SQL query. cmd.CommandText = "UPDATE products SET code= '" & TextBox1.Text & "', price= '" & TextBox2.Text & "' WHERE product= '" & TextBox1.Text & "'" Fonts kept large intentionally to differentiate between " and ' Thanks, Vivek. No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.176 / Virus Database: 270.9.15/1837 - Release Date: 12/9/2008 9:59 AM
