Part 38 CheckBoxList in asp net mvc

In this video we will discuss implementing a checkbox list in asp.net mvc. We will be using table "tblCity" for this demo.
Using the link below for, Sql script to create table tblCity
csharp-video-tu...
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our KZbin channel. Hope you can help.
/ @aarvikitchen5572
Add ADO.NET data model, to retrieve data from database table tblCity
Right click on the "Controllers" folder, and add a "HomeController". Include the following 2 namespaces in "HomeController"
using MVCDemo.Models;
using System.Text;
Copy and paste the following code.
[HttpGet]
public ActionResult Index()
{
SampleDBContext db = new SampleDBContext();
return View(db.Cities);
}
[HttpPost]
public string Index(IEnumerable[City] cities)
{
if (cities.Count(x =] x.IsSelected) == 0)
{
return "You have not selected any City";
}
else
{
StringBuilder sb = new StringBuilder();
sb.Append("You selected - ");
foreach (City city in cities)
{
if (city.IsSelected)
{
sb.Append(city.Name + ", ");
}
}
sb.Remove(sb.ToString().LastIndexOf(","), 1);
return sb.ToString();
}
}
Right click on the "Views" folder, and a "Home" folder. Right click on the "Home" folder and "EditorTemplates" folder.
Right click on "EditorTemplates" folder - Add - View. In the "Add View" dialog box, set
View Name = City
View Engine = Razor
and click "Add".
Copy and paste the following code in "City.cshtml"
@model MVCDemo.Models.City
@{
ViewBag.Title = "City";
}
@Html.HiddenFor(x =] x.ID)
@Html.HiddenFor(x =] x.Name)
@Html.CheckBoxFor(x =] x.IsSelected)
@Html.DisplayFor(x =] x.Name)
Please Note: Put the templates in "Shared" folder, if you want the "Templates", to be available for all the views.
Right click on the "Index" action method in "HomeController", and select "Add View" from the contex menu. Set
View Name = Index
View Engine = Razor and click "Add"
Copy and paste the following code in "Index.cshtml"
@model IEnumerable[MVCDemo.Models.City]
@{
ViewBag.Title = "Index";
}
[div style="font-family:Arial"]
[h2]Index[/h2]
@using (Html.BeginForm())
{
@Html.EditorForModel()
[br /]
[input type="submit" value="Submit" /]
}
[/div]
Text version of the video
csharp-video-tu...
Slides
csharp-video-tu...
All ASP .NET MVC Text Articles
csharp-video-tu...
All ASP .NET MVC Slides
csharp-video-tu...
All Dot Net and SQL Server Tutorials in English
www.youtube.co...
All Dot Net and SQL Server Tutorials in Arabic
/ kudvenkatarabic

[@sushmaka4905]

Hi Venkat Thank you for your videos!They are very clear to understand and your teaching is really good!You explain every concept in a clear and easy way!

[@Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.

[@PatilShirish]

Thank you venkat It's really good and understandable for every one.

[@Csharp-video-tutorialsBlogspot]

Hi, Editor and Display templates are discussed in Parts 44 to 46. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.

[@umangpatwa8484]

EditorModel method auto-loop by itself or what ? how it shows all data from city table without using for loop to show all city with check boxes

[@avinashg2008]

good one...new way to implement using editor template..

[@waiyanhein7205]

What is wrong ?? Can u explain ?? Cos u generate only once the checkbox in both templates . But it showing all . Why ? EditorModel method auto-loop by itself or what ??

[@RuhiGoktas]

A very vital point you have to pay attention here is while you create tblCity DO NOT check allow nulls if you do that, your code will give you an error saying "Cannot implicitly convert type 'bool?' to 'bool'. An explicit conversion exists (are you missing a cast?)"

[@sprakash1094]

IN edmx part set the IsSelected Property to false . its working for me. Thanks

[@PoomulusRobsBanksOnTV]

Make sure your IsSelected column in your database is of type bit and that the IsSelected property inside your DataModel is a boolean. It should solve the issue since a bit returns true on 1 and false on 0

[@syednoohu8692]

I'm confused between generating the RadioButtonFor and CheckBoxList We are using ForEach loop to generate RadioButton for each Department but in the case of CheckboxList not, What makes the difference? this is because of EditorforModel Templates ? sorry for asking naïve Question Thanks

[@intersowa1970]

Yes. "EditorForModel returns an HTML input element for each property in the model, using the template name, HTML field name, and additional view data." I did not know that before watching this episode tutorial. Fantastic.

[@mellis321]

Hi, thank you so much for this video! But, when I created the 'City' view page and ran the app, I noticed in the browser's source view that the entire HTML code itself was duplicated more than once. I decided to recreate the 'City' view as a partial view and now the source code is structured properly. I just wanted to bring this to your attention! :)

[@jayrcodes91]

Hi Venkat, thank you for the effort for sharing your knowledge to everyone who wants to become a web developer. I just want to ask regarding to the IEnumerable parameter in HttpPost Index action method, when I try to write the IF statement, it doesn't provide a Count() function just like what you have used in the video. By the way I am using MVC4,VS2013 & EF 5.

[@khoao1636]

have you tried to put System.LINQ namespace into you controller?

[@jayrcodes91]

Right, I forgot to include the System.Linq namespace. I didn't notice that It was removed during I saved the project. My VS automatically get rid the unused namespaces during save. Hehe, this is already okay. Thanks for the response anyway.

[@yamarat1]

Thank you for these videos! You are saying that editor templates are discussed in a later tutorial. which tutorial number are editor templates discussed? I could not find it. Thank you in advance!

[@pathivadachakravarthy3905]

Hi Venkat, While calling @Html.EditorForModel() showing error like External component has thrown an exception. Please suggest what i need to do?

[@sca11ywagg]

IsSelected? Is it good that your database contains the UI's state? Food for thought.

[@rajareddyanapareddy6490]

Sir, what is the need of sending db.cities passing to index View.. where we are using those.

[@maximss]

I also did this after sb.Remove() - sb.Replace(",", " and ", sb.ToString().LastIndexOf(","), 1); Looks more fluent.

[@kondareddy6162]

checkbox is treated as id,name as isselected when you post the form data you select which checkbox what relation between checkbox and hidden element how to know us correct value come from hidden if you select one checkbox beside value as london just consider how to read correct value modelbinder london in hidden input element i hope u understood my point

[@sachingreat222]

In this video very important thing is described that is how to get selected checkbox from database

[@saradatandukar7253]

@Html.CheckBoxFor(x=> x.IsSelected) "Cannot convert lambda expression to intended delegate type because some of the return types in the block are not implicitly convertible to the delegate return type" there is problem in selected

[@gurunathrao2985]

For this error did the following and it worked for me: 1.IN SQL , drop the IsSelected Column using (alter table Cities1 drop column IsSelected). 2.Then create the same column again except use (alter table Cities1 add IsSelected BIT NOT NULL default 0) 3.Go to your model.edmx file>>right click on the entity>>Update you model from database. 4.Save your work and build and the error goes as IsSelected is not nullable anymore

[@venkyL-cz2hl]

@@gurunathrao2985 thank u very much for ur solution it's very helpful for others and me to solve this error.

[@gurunathrao2985]

[HttpPost] [ActionName("Index")] public string Index_Post(IEnumerable ResCities) { if(ResCities.Count(x => x.IsSelected == true) == 0) { return "Are you kidding...select something!!"; } else { StringBuilder sb = new StringBuilder(); sb.Append("You Selected -"); foreach(Cities temp in ResCities) { if(temp.IsSelected == true) { sb.Append(temp.Name + ","); } } sb.Remove(sb.ToString().LastIndexOf(","), 1); return sb.ToString(); } } I think this slightly modified version of the [HttpPost] method is gonna help. Also please try making the IsSelected field in the table as non-nullable

[@donwiesmann5186]

How would this example work if the checkbox list was a List in a larger class of objects? You wouldn't set the view a IEnumerable as only one object is the List. If I do a @foreach loop, I can display the check boxes but I can't figure out how to retain the List of items that were checked for the HttpPost.Thanks you in advance!

[@abubakarizhar5608]

Dear can we display check boxes in foreach loop.

[@nanda3281]

sir when I put it view of home folder it does not work instead it shows 12345 number with button but I put it shared folder it works correctly.

[@sunilparmar6434]

use '@' before (Html.BeginForm()) like this: (@Html.BeginForm())

[@shahzaibriaz6552]

I'm getting error Templates can be used only with field access ,property access , single dimension array index, or single parameter custom indexer expression?

[@yeasinahmed4819]

Please set that your IsSelected column to not null in your database table. Then update your model from edmx and finally remove null-ability from IsSelected Property from city class. Here is my city class: public partial class City { public int Id { get; set; } public string Name { get; set; } public bool IsSelected { get; set; } }

[@yamikadesai3931]

@@yeasinahmed4819 This is not working...

[@saminashaikh5564]

This is useful,But i want Mvc with jquiry code for selected multiple Checkbox and store in database how it is can u help

[@mahidharguggilam2435]

you can trim it with comma

[@Junaid7671]

veenkat could you please make a video for how to create reusable checkbox list in mvc .

[@HemantKumar-yk2jk]

when I put it view of home folder it does not work instead it shows 12345 number with button

[@dineshengg408]

Hi Venkat, me too stuck at the same point. Not sure how to get rid of this. Could you help us in fixing this error. Code residing in the Views is same. But still not getting the expected o/p.

[@developernader]

- check the folder name EditorTemplates - In database change IsSelected Not Allow Null - Update your DataMobile object -In City.cs public bool IsSelected { get; set; }

[@Piotruch88]

I have the same problem :( @developernader I checked and it still does not work

[@badrulhussain5545]

developernader hi i followed this instruction but i still get the output as 12345?

[@shyamal890]

Hemant Kumar I too am getting the same error. kudvenkat can you please help

[@adishjain3073]

I am getting error in this line of code "@Html.CheckBoxFor(x=>x.IsSelected)". Getting red square line under “x.IsSelected”. i.e "Cannot implicitly convert type 'bool?' to 'bool'. An explicit conversion exists (are you missing a cast?) Cannot convert lambda expression to intended delegate type because some of the return types in the block are not implicitly convertible to the delegate return type" How resolve this?

[@TheRohannanu]

Convert all null values to 0 in tblCity for column isSelected

[@umangpatwa8484]

set IsSelected property as NOT NULL in database

[@dineshkumarachari8757]

public Nullable IsSelected { get; set; } change the this formate code public Boolean IsSelected { get; set; } is correct..i think this is help full for you..

[@PoomulusRobsBanksOnTV]

Make sure your IsSelected column in your database is of type bit and that the IsSelected property inside your DataModel is of boolean. It should solve the issue since a bit returns true on 1 and false on 0 so it can be converted to a boolean type. Having the column set to not null would also be a good idea

[@shahzaibriaz6552]

@Html.CheckBoxFor(m=> m.IsSelected ?? false)

[@killers512]

It would be simplier to to use string.Join method

[@meghamisra5622]

Can i put them in to dropdown?

[@jenithjana3652]

Hai all this comment is for those who get 1234 in the browser instead of checkboxes. Be careful with the spelling while naming the folder EditorTemplates. Hope this helps!!!

[@tapankumarbaral1244]

thnx

[@venkyL-cz2hl]

thank u very much for this solution

[@kavithavishwanathen6778]

Error CS1662 Cannot convert lambda expression to intended delegate type because some of the return types in the block are not implicitly convertible to the delegate return type

[@vikaspandey72]

achu r in httppost action, return null

[@muhammadshoaibkhan8428]

isselected property give me a problem.Its generate error of can't explacity convert type bool to bool. what to do

[@ABHISHEKPATHAK49]

+Shoaib Khan Friend because IsSelected is nullable type in database, make it non nullable. or @Html.CheckBoxFor(m => m.IsSelected ?? false) try this. Please reply if it works

[@braScene]

Just change the IsSelected property type from "Nullable" to just "bool".

[@ABHISHEKPATHAK49]

thanks a lot dear.

[@shahzaibriaz6552]

@Html.CheckBoxFor(m=> m.IsSelected ?? false)

[@shahzaibriaz6552]

That's Bad thing because our entity is Auto-Generated

[@krishnagoriparthi4570]

I didn't get any message when i was clicked the check box and submit button plz help me kudvenkat sir

[@cabritoloko1]

Don't you need a for our a while to display all the check boxes? without it it should only display 1 checkbox

[@dineshkumarachari8757]

Hi Sir, From where the Cities Property comes in this code [[return View(db.Cities)] ] you not mansion the Cities Properties code .Please Send the code..

[@rrgaming7244]

if you create table city and add into entity model then it comes auto

[@kavithavishwanathen6778]

CS0019 Operator '==' cannot be applied to operands of type 'int' and 'bool'.....help people help

[@kavithavishwanathen6778]

CS0029 Cannot implicitly convert type 'int' to 'bool' ..m getting this error

[@shahzaibriaz6552]

@Html.CheckBoxFor(m=> m.IsSelected ?? false)

[@arun9385]

Whats the use of City.cshtml what it is rendering and what is Index.cshtml for i am confused Sob Sob

[@arun9385]

Arun Nagar Why you put City in Editor template i put it in home folder O/P is 12345

[@arun9385]

Arun Nagar You should Reply people are crying here

[@tictac18g-j1c9q]

Mahender Kumar gave answer as below. "EditorTemplates"

[@sachingreat222]

from where we will get code

[@sridevimahapatra3046]

Got 12345 output instead of Checkboxes.

[@gh0stdagger]

Make sure your folder name is "EditorTemplates"

[@sridevimahapatra3046]

I named it right but still didn't get the Out put. Actually the task was to load Check boxes dynamically with data from DB,(like Cuisines-Indian,Chines,Italian).Kindly let me know if you have any idea about how to do it. Thanks in advance.

[@rasmiranjanmishra8271]

Hi Sridevi The issue is your view is unable to get data from EditorForModel control . Make sure your view and EditorTemplates folder are in same folder

[@sridevimahapatra3046]

Hi Rashmi Ranjan Mishra. Thank you.

[@rrgaming7244]

Thanks Dear​@@rasmiranjanmishra8271

[@HemantKumar-yk2jk]

Can u please explain why it is happened ..

[@mahender18]

Please check the folder name in view->Home->EditorTemplates,it helped me

[@attiqafridi9094]

+Mahender Kumar a bundle of thanks, you made it easy for me...

[@mohanbehara6262]

hey im geting 1234 insted of checkboxes i kept "EditorTemplates"

[@sunilparmar6434]

use '@' before (Html.BeginForm()) like this: (@Html.BeginForm())

[@DeathHordes]

dude...

[@shahzaibriaz6552]

Worst Video totally confusing

[@desitrump]

@@TheVibhu100 He is right, its totally confusing video.

[@codingislife6387]

My @Html.EditorForModel() not Gettng EditorTemplates don't know whats wrong . I am doing all steps correctly