C # Search Table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Dan Effets
    New Member
    • Oct 2011
    • 17

    C # Search Table

    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 **?

    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();
    
    
    
            }
    Thank you
    in advance
Working...