My mysql query is correct but in vb.net is wrong

Question

For Search textbox

this is my query correct query

Select tip_part_no as TIPPartNo, date_rec as DateRecieve, reciever_name as RecieverName,
qty, SUM(qty) as Total from pcba_info.lot_info where tip_part_no like '' group by 
packing_list_no;

error in my program vb,net T_T

("Select tip_part_no as TIP, SUM(qty) as Total_Quantity from pcba_info.lot_info 
WHERE tip_part_no LIKE '%" & Trim(txtsearch.Text.TrimEnd()) & "%' group by 
tip_part_no '%" , con)

score 2 · Answer 1 · edited May 23 '17 at 12:28

You should use a parameterised query for this...

Your query then looks like this:

Select tip_part_no as TIPPartNo, date_rec as DateRecieve, 
reciever_name as RecieverName, qty, SUM(qty) as Total from pcba_info.lot_info 
where tip_part_no like @tip_part_no group by packing_list_no;

Then you add the parameter @tip_part_no with the value txtsearch.Text.Trim()

Information about using LIKE operator in parameterized queries: Parameterized Queries with LIKE and IN conditions

Example and background information here: How do I create a parameterized SQL query? Why Should I?

score 0 · Accepted Answer · answered Jan 29 '14 at 08:54

Remove %,' (Percentage and Single quotes) symbols near Group By (group by tip_part_no '%")

Try like this

"Select tip_part_no as TIP, SUM(qty) as Total_Quantity from pcba_info.lot_info 
WHERE tip_part_no LIKE '%" & Trim(txtsearch.Text.TrimEnd()) & "%' group by 
tip_part_no" , con

My mysql query is correct but in vb.net is wrong

2 Answers2