How Do I render items checked from checkboxlist

Question

I have a bunch of come delimited items on my db table column. Example Peter, Greg, Paul, Mary, My question is, how do I display these items as checked Items on my view?

R J · Answer

you can simply use Split(','); see below is example. var query = from o in db.Students where o.StudentID == "200312" select o.PlacesVisited .Split(',');

Ramesh Maruthi · Answer

cool good to hear ur problem solved and thanks for sharing the solution :)

ceci bela · Answer

I got it to work. I had to do this: foreach (string placesvi in placesvisted) { List myString = new List (placesvi.Split(',').Select(p=>p.Trim()).ToList()); ViewBag.CheckedItems = myString ; // use ViewBag } Thank you both Ramesh & RJ!

Ramesh Maruthi · Answer

final try do in this way: 1) return View(myString.AsEnumerable) 2) //controller List myString = new List (placesvi.Split(',')) return View(myString ); //view @model List // and property Model is type of List @foreach(var item in Model) { }

Ramesh Maruthi · Answer

sorry its my typo, return View(ViewBag.CheckedItems) you can't do this because when we returning a view it should be a model or a viewname but ViewBag.CheckedItems neither both

ceci bela · Answer

When I tried your suggestion to try this @foreach(CheckListBoxItem item in ViewBag.CheckedItems) I got the error below. The type or namespace name 'CheckListBoxItem' could not be found (are you missing a using directive or an assembly reference?) When I tried return View(ViewBag.CheckedItems) I got this error: Exception Details: System.InvalidOperationException: The view 'NY NJ CA ND ' or its master was not found or no view engine supports the searched locations. The following locations were searched: ~/Views/home/NY NJ CA ND .aspx ~/Views/home/NY NJ CA ND .ascx ~/Views/Shared/NY NJ CA ND .aspx ~/Views/Shared/NY NJ CA ND .ascx ~/Views/home/NY NJ CA ND .cshtml ~/Views/home/NY NJ CA ND .vbhtml ~/Views/Shared/NY NJ CA ND .cshtml ~/Views/Shared/NY NJ CA ND .vbhtml

ceci bela · Answer

I am not sure if I am answering you correctly but the ' item ' in the foreach() on the View seem to be completely empty! But the controller shows there is data as shown here. https://www.dropbox.com/s/swkvozcga0ofnwm/debug.png?dl=0 is it the way I am saving the data in ViewBag or is it the problem when I access the ViewBag?

Ramesh Maruthi · Answer

what does the item consists of ? I mean what your getting if you do like this item. after item . what intelisense giving ?

ceci bela · Answer

Still working on the same code I am trying to put the split items into a ViewBag but nothing is being passed to the View or maybe I am not accessing it correctly. Controller foreach (string placesvi in placesvisted) { List myString = new List (placesvi.Split(',')); foreach (var singleItem in myString) { ViewBag.CheckedItems = singleItem; // Response.Write("Debug:"+ ViewBag.CheckedItems ) } } View @foreach (var item in ViewBag.CheckedItems) { @item } NOTE: if I do a Response.Write( ViewBag.CheckedItems ) on the controller I can see all the items. Thanks guys I really appreciate it.

Ramesh Maruthi · Answer

http://sampathloku.blogspot.com/2013/06/how-to-use-checkboxlistfor-with-aspnet.html

Ramesh Maruthi · Answer

http://vijayt.com/Post/CheckBox-Helper-in-MVC

ceci bela · Answer

I recompiled and now it looks like I am getting the values. Getting closer phew! See image . Now how can I get this into checkboxes on my View without the @Html.CheckBoxFor helper function? I am thinking something like this: @PlacesVisited I might be wrong but I don't think the @Html.CheckBoxFor() is friendly in my case. Thanks a bunch.

Ramesh Maruthi · Answer

what your getting at this line List placesvisted = db.Students.where(o => o.StudentID == "200312").select ( o => o.PlacesVisited).ToList();

ceci bela · Answer

Thank you for the response. I am now getting a 'System.NullReferenceException' error. Screenshot.

Ramesh Maruthi · Answer

List placesvisted = db.Students.where(o => o.StudentID == "200312").select ( o => o.PlacesVisited).ToList(); foreach(string placesvi in placesvisted ) { List result = new List (placesvi.Split(',')); }

ceci bela · Answer

Could you kindly explain on creating a new list? I couldn't get it. I tried both suggestions (but without creating a new list) and got the same error. LINQ to Entities does not recognize the method 'System.String[] Split(Char[])'

Ramesh Maruthi · Answer

Agree with Rj, if that doesnt work u can create a separate list List res= new List (o.PlacesVisited.Split(',')) as Rj said u can do in this way var resu1 = db.Students.where(o => o.StudentID == "200312").select ( o => o.PlacesVisited.Split(',')).ToList();

ceci bela · Answer

I got this error LINQ to Entities does not recognize the method 'System.String[] Split(Char[])' method, and this method cannot be translated into a store expression. When I tried this on my homecontroller var query = from o in db.Students where o.StudentID == "200312" select o.PlacesVisited.Split(new char[] { ',' }); Any ideas how to use the Split() correctly with Linq? Thanks

ceci bela · Answer

Nope it doesn't work.

Ramesh Maruthi · Answer

@Html.CheckBoxFor(m=>m[i].PlacesVisited,new SelectList(Model[i].options.Split(new char[]{','}))) don't know this works or not

ceci bela · Answer

Thanks for the links but none of those links mention anything about how to deal with checkbox items stored in an Array, say PlacesVisited Db Example. --------------------------------------------- | Name | Last Name | PlacesVisited | --------------------------------------------- | Jonh | Doe | NY, NJ, CA, RI, | ---------------------------------------------- | Mary | Lou | LA, CO, OR, NY | ---------------------------------------------

Ramesh Maruthi · Answer

http://www.codeproject.com/Tips/613785/How-to-Use-CheckBoxListFor-With-ASP-NET-MVC http://stick2basic.wordpress.com/2013/03/12/checkboxlist-in-asp-net-mvc4/ http://forums.asp.net/t/1943984.aspx?How+to+use+checkbox+and+submit+the+check+values+

How Do I render items checked from checkboxlist

Answers (22)