asp.net linq .contains "string"

Question

I have a field in a dataset and im querying using Linq my code is

 var countriesQry = from a in countTbl.AsEnumerable()
                               where a["CountryId"].ToString().Contains(countryId)
                               orderby a["CountryId"]

my problem is that in the "CountryId" field there can be a countryid of 1,22,13 (its a varchar field) so something can be a few countries. as you can guess its returning 1 and 13 if the "Countryid" = 1 can anyone tell how I can correct it

thanks

Yograj Gupta · Accepted Answer · 2012-10-22 11:23:52Z

1

Just change Contains to Equals

var countriesQry = from a in countTbl.AsEnumerable()
                           where a["CountryId"].ToString().Equals(countryId)
                           orderby a["CountryId"]

answered Oct 22, 2012 at 11:23

Yograj Gupta

9,8673 gold badges31 silver badges50 bronze badges

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

2 Comments

andrew slaughter Over a year ago

yeah i initially thought of that but if the country field has the value "1,22,13" that wont return any results

andrew slaughter Over a year ago

sorry ill hold my hand up just tried.Equals and it works great thanks

Paul Michaels · Accepted Answer · 2012-10-22 11:24:02Z

0

var countriesQry = from a in countTbl.AsEnumerable()
                           where a["CountryId"].ToString().Equals(countryId)
                           orderby a["CountryId"]

answered Oct 22, 2012 at 11:24

Paul Michaels

16.8k47 gold badges156 silver badges277 bronze badges

Comments

L.Grillo · Accepted Answer · 2012-10-22 11:26:27Z

0

Try using Any() instead of Contains.

answered Oct 22, 2012 at 11:26

L.Grillo

9813 gold badges13 silver badges26 bronze badges

Collectives™ on Stack Overflow

asp.net linq .contains "string"

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related