I have a list like
IEnumerable<DGeneralAmenities> VBagmodel = (from c in realContext.GeneralAmenities select new DGeneralAmenities { AmenitiesId = c.AmenitiesId, Name = c.Name, BActive =c.BActive ,
checked= //true or false value } ).Where(d => d.BActive == true);
i need to set "checked" entry based on database value .My db contain id of only checked items ie [ 2,5,12,22 ]
please help me how can i set True For only these Id in VBagmodel
It’s somewhat hard to answer your question because it’s not very clear.
Are you saying there is a nullable id on the model?
If so, you can say
checked = c.Amenities.HasValue
If that is not correct please add more information to your question.
I need to set true or false based on Database value
And my Db contan GeneralAmenities -Varchar(200) [For Save my Selected Check box Ids -Separated by comma ie -2,5,4]
IEnumerable LIST
AmenitiesId Name BActive checked
—————————————————-
1 Wifi true
2 CAR true
3 CC true
4 ABC true
5 DEF true
—————————————————–
My Db contain Amenities=>2,3,5
And How I can i get Result in this form
AmenitiesId Name BActive checked
—————————————————-
1 Wifi true flase
2 CAR true true
3 CC true true
4 ABC true false
5 DEF true true
Hi,
Base on your reply, I don’t know where do you get the selected ID value. You could refer to this code below to achieve your requirement.
string[] ids=new string[3]; ids[0]="a"; ids[1]="b"; ids[2]="c"; MessageInfoEntities1 db = new MessageInfoEntities1(); var d = (from u in db.UserInfoes select new { Name = u.UserName, Password = u.Pwd, IsChecked = ids.Any(id=>id==u.Pwd)}).ToList();
Best Regards
Starain