I have a problem in my project. I have table for saving category and I have a `listview` for viewing that category names and I have a text box above of the `listview`. When I type an alphabet in the `textbox`, I want to see the corresponding category name in the list view using LINQ query and for that I'm using this code:

```
 DataTable dt = (from c in Common.dc.TblBrands
                    where SqlMethods.Like(c.BrandName, txtSearch.Text+"%")
                    orderby c.BrandName
                    select c).getDataTable();

```

I can see the names correctly but I want to see the brand name when I input the brand id in the `textbox`. What query can I use to achieve this?