Select Id, CompanyName, Remarks
FROM LC_CompanyTB
Where (CompanyName LIKE '%?%')生成的方法为:
public virtual LC_DB.LC_CompanyTBDataTable Search();参数CompanyName丢失了,SQL语句稍做修改:
Select Id, CompanyName, Remarks
FROM LC_CompanyTB
Where (CompanyName LIKE ?)这样生成的方法为:
public virtual LC_DB.LC_CompanyTBDataTable Search(string CompanyName);总算正确了,调用如下:
LC_CompanyTBTableAdapter adapter = new LC_CompanyTBTableAdapter();
dataGridView1.DataSource = adapter.Search("[color=Red]%[/color]" + companyName + "[color=Red]%[/color]");注意添加%!
评论(0)
暂无评论。