C#编辑的窗体应用程序运行时，使用模糊查询方式查询数据库中的信息

Question

C#编辑的窗体应用程序运行时，使用模糊查询方式查询数据库中的信息，显示查询语言有错，谁有完整可以运行的代码或者看看 string cmd = "select * from [同学录].[dbo].[bdt] where" + lie + "like'" + "%" + zi + "%" + "'";哪里有错误。谢谢

Answer 1

 string s = "select * from dbo.BHQ_Ecotourisms where Name like '%" +  textEdit1.Text.Trim() + "%'"

你在第一个%号前面加一个空格试试

Answer 2

你好：

建议你调试一下程序，监视一下变量cmd的值，然后修改这行代码。

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.