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