try using with command parameters
On 12/10/08, Benj Nunez <[EMAIL PROTECTED]> wrote: > > > 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.
