我的mysql查询是正确的，但在vb.net中是错误的。

Question

用于搜索文本框

这是我的查询正确的查询

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;

在我的程序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)

Answer 1

删除%，‘(百分比和单引号)符号附近的组(group by tip_part_no '%")

试着像这样

"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

Answer 2

您应该对此使用参数化查询。

然后您的查询如下所示：

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;

然后，使用值@tip_part_no添加参数txtsearch.Text.Trim()。

有关在参数化查询中使用类似操作符的信息：Parameterized Queries with LIKE and IN conditions

这里的示例和背景信息：How do I create a parameterized SQL query? Why Should I?