Use parameters to avoid this kind of error. Check this site: http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=181862&SiteID=1
Cheers! Benj On Dec 9, 2:57 am, "Vivek Vorani" <[EMAIL PROTECTED]> wrote: > 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.
