deanlee17
asked on
Linq to find matching record
Hi guys,
I create a list:
Loaded it with part numbers:
Now the next part so far I have
But I cant hook the rest up?
Ideally I want a Boolean with a yes/no as to whether there is an exact match on part number. Additionally it would also be nice to generate a list of any partial matches?
Thanks,
Dean
I create a list:
private List<String> lst_CounterfeitParts = new List<string>();Loaded it with part numbers:
lst_CounterfeitParts = (from d in context.QA_CounterfeitParts select (d.PartNumber)).ToList();Now the next part so far I have
bool has = lst_CounterfeitParts.Any(But I cant hook the rest up?
Ideally I want a Boolean with a yes/no as to whether there is an exact match on part number. Additionally it would also be nice to generate a list of any partial matches?
Thanks,
Dean
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
What I basically have is a grid populated by a list, I need to filter that list per key stroke whilst looking for full or partial matches on the part number
You could use Contains for a partial match...
...but I think most people would find StartsWith more intuitive.
searchString = searchString.ToLower()
List<String> partialMatches = lst_CounterfeitParts.Where(i => i.ToLower().Contains(searchString));...but I think most people would find StartsWith more intuitive.
searchString = searchString.ToLower()
List<String> partialMatches = lst_CounterfeitParts.Where(i => i.ToLower().StartsWith(searchString));
@kaufmed. Thanks, I really don't like writing air code.
As it can be a partial match in the middle then StartsWith isn't of use. As mentioned earlier you could use contains. I did suggest using ToLower to make everything the same case, if it was case dependent (a not being the same as A) then you would miss out the ToLower conversion. I'm not so confident with regex so I won't suggest a regex expression - just consider it for finding a match. It can be more flexible than using a string function such as Contains.
As it can be a partial match in the middle then StartsWith isn't of use. As mentioned earlier you could use contains. I did suggest using ToLower to make everything the same case, if it was case dependent (a not being the same as A) then you would miss out the ToLower conversion. I'm not so confident with regex so I won't suggest a regex expression - just consider it for finding a match. It can be more flexible than using a string function such as Contains.
ASKER
Excellent info thanks guys.
Im getting a slight problem, ive changed the original:
to now be :
I now get the error:
Cannot implicitly convert type 'System.Collections.Generi
Is this a common error?
Thanks,
Dean
Im getting a slight problem, ive changed the original:
lst_CounterfeitParts = (from d in context.QA_CounterfeitParts select (d.PartNumber)).ToList();to now be :
lst_CounterfeitParts = (from d in context.QA_CounterfeitParts select (d.PartNumber, d.Manufacturer)).ToList();I now get the error:
Cannot implicitly convert type 'System.Collections.Generi
Is this a common error?
Thanks,
Dean
That is really going away from the original question.
Your problem is the change returns two values whereas the List<string> is only expecting one.
Your problem is the change returns two values whereas the List<string> is only expecting one.
ASKER
Ok will start another post. Thanks
ASKER
Andy a part match could be 34 or x12