I am working on a project and hit a road block , I would like for the customer to be able to search the whole data table. So far I can only find a way to search one column.Also is there a way to use wildcards **?
Thank you
in advance
Code:
private void btnFind_Click(object sender, EventArgs e)
{
tblEmployeeBindingSource.DataSource =
from tblEmployee in hollandDataSet.tblEmployee
where tblEmployee.LastName.StartsWith(txtFind.Text)
orderby tblEmployee.EmployeeID, tblEmployee.FirstName, tblEmployee.LastName, tblEmployee.Position, tblEmployee.SupervisorID
select tblEmployee;
txtFind.Clear();
}
in advance