How Do I render items checked from checkboxlist

ceci bela

12y2.2k.NET

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?

22 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Maruthi12y ago
cool good to hear ur problem solved and thanks for sharing the solution :)
ceci bela12y ago
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 Maruthi12y ago
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 Maruthi12y ago
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 bela12y ago
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 bela12y ago
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 Maruthi12y ago
what does the item consists of ?
I mean what your getting if you do like this item. after item . what intelisense giving ?
ceci bela12y ago
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) <= this works.
}
}

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 Maruthi12y ago
http://sampathloku.blogspot.com/2013/06/how-to-use-checkboxlistfor-with-aspnet.html
Ramesh Maruthi12y ago
http://vijayt.com/Post/CheckBox-Helper-in-MVC
ceci bela12y ago
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 Maruthi12y ago
what your getting at this line
List placesvisted = db.Students.where(o => o.StudentID == "200312").select ( o => o.PlacesVisited).ToList();
ceci bela12y ago
Thank you for the response. I am now getting a 'System.NullReferenceException' error.
Screenshot.
Ramesh Maruthi12y ago
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 bela12y ago
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 Maruthi12y ago
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();
R J12y ago

you can simply use Split(',');

see below is example.
var query = from o in db.Students
where o.StudentID == "200312"
select o.PlacesVisited.Split(',');
ceci bela12y ago
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 bela12y ago
Nope it doesn't work.
Ramesh Maruthi12y ago
@Html.CheckBoxFor(m=>m[i].PlacesVisited,new SelectList(Model[i].options.Split(new char[]{','})))

don't know this works or not
ceci bela12y ago
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 Maruthi12y ago
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+