Hi, I have an mdb database and I want to execute some queries but some cells are containing double quotes and I'm getting error.
My string:
The error:Code:Dim dbStr As String = "SELECT * FROM products_tbl WHERE product_name = '" + s + "'"
How can I fix this?Code:An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll Additional information: Syntax error (missing operator) in query expression 'product_name = 'ASUS X550JK İ5-4200H 4GB 500GB 15.6' VGA 2GB D''.




Reply With Quote
