Select Id, CompanyName, Remarks
FROM LC_CompanyTB
Where (CompanyName LIKE '%?%')

public virtual LC_DB.LC_CompanyTBDataTable Search();

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("%" + companyName + "%");