Need sql string help

[tchavez]

AddItemGo.CommandText = "Insert INTO `book` (`recipe`,`ingredients`,`whos`,`instructions`,`type`)" + "VALUES"+""(rName.Text.ToString(), Ingred.Text.ToString(), wName.Text.ToString(), Instruct.Text.ToString(), TypeBox.SelectedItem.ToString(), "Dawn")"""

For some reason I get an error, expected end of statement near "Dawn"

 

[kulrom]

Try this

AddItemGo.CommandText = "Insert INTO book(recipe, ingredients, whos, instructions, type) VALUES ('" & rName.Text.ToString() & "', '" & Ingred.Text.ToString() & "', ......... 'Dawn')"


Regards

 

[tchavez]

Thank you

I got it to work.