Hi..i want helpful to understand some lines in this code..this code to insert record in DB using SQL statement(INSERT)and ADO.NET classes:
dim insCom as new OleDb.OleDbCommand()
insCom.CommandTex="INSERT INTO Book(cID,bName,Price)
Values("& TextCid.Text & ",[red]'" & TextName.Text & "'[/red]," &
TextPrice.Text & ")"
[red]in previous 2 lines my questions:
1- i don't understand why single quote is used to insert string and when i don't write this quote it caused error?
2-what about & character?[/red]
plz answer me in hithermost time as you can..and Thax very much
Best regards ..program_agent