SYNTAX ERROR IN QUERY

[clynnekent]

Good day everyone, I just wanna ask what is the problem of my code. I do a search query but I have a error when I press this symbol '

Code :

cmo = New OleDbCommand("Select * from tbltools where Tools_name like '%" & txtempsearch.Text & "%'", cn)
doi.SelectCommand = cmo
dp.Clear()
doi.Fill(dp)

DataGridView1.DataSource = dp

DataGridView1.Columns(0).HeaderText = "Tools ID"
DataGridView1.Columns(0).Width = "120"
DataGridView1.Columns(0).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter
DataGridView1.Columns(1).HeaderText = "Tools Name"
DataGridView1.Columns(1).Width = "267"
DataGridView1.Columns(1).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter
DataGridView1.Columns(2).HeaderText = "Tools Unit"
DataGridView1.Columns(2).Width = "100"
DataGridView1.Columns(2).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter
DataGridView1.Columns(3).HeaderText = "Tools Quantity"
DataGridView1.Columns(3).Width = "100"
DataGridView1.Columns(3).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter
DataGridView1.Columns(4).HeaderText = "Tools Date Posted"
DataGridView1.Columns(4).Width = "100"
DataGridView1.Columns(4).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter
DataGridView1.Columns(5).HeaderText = "Categories"
DataGridView1.Columns(5).Width = "100"


I don't have problem with other symbols except this one ' symbol. Error syntax error in query appear.


Thank

clynnekent

Continue reading...