sql语句应如下所示:
String sql = " SELECT * FROM Products WHERE ID = @MYID AND Name LIKE '%' + @MYNAME + '%'";
我不确定我是否完全理解您的评论,但是您似乎想在查询中使用文本框中的值-也许这就是您要尝试执行的操作:
String sql = " SELECT * FROM Products WHERE ID = @MYID AND Name LIKE '%' + text_@R_629_2419@.Text + '%'";