Linq to SQL searching

Question

I have a table with users. I want to be able to search for a string and then return all username which contains this string. Then i want to populate a ListBox. This is what I have tried:

var varUser = (from u in dc.Users
                           where u.username == searchUserName
                           select u.username);
            lbSearchResult.DataSource = varUser;
            lbSearchResult.DataBind();

But when i try to search for "a" i don't get any results. It only works if i enter the full username.

Yuck · Accepted Answer · 2012-04-13 11:49:38Z

5

Try using Contains() instead:

var varUser = from u in dc.Users
              where u.username.Contains(searchUserName)
              select u.username;

answered Apr 13, 2012 at 11:49

Yuck

51.1k13 gold badges108 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Lloyd Powell Over a year ago

It's worth noting that it can be case ignorant with u.user.ToLower().Contains(searchUserName.ToLower())

Hux Over a year ago

@ThePower Contains within LINQ-SQL will generate a LIKE statement that is case insensitive by default in MSSQL unless otherwise specified.

Matten · Accepted Answer · 2012-04-13 11:50:32Z

1

Maybe because of the clause

where u.username == searchUserName

Try u.username.Contains(searchUserName) or build a regular expression.

answered Apr 13, 2012 at 11:50

Matten

17.6k2 gold badges45 silver badges64 bronze badges

Collectives™ on Stack Overflow

Linq to SQL searching

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related