Insert values from Checkboxlist

Question

Hi all..

I have a page frmLocationMaster.aspx. ..

On this, I am having 2 checkboxlist controls -

1. checkboxlistusers

2. checkboxlistlocation

Uitlity -

Users must get access to specific locations only ..

Eg -

User Table

ID	User
1	A
2	B
3	C
4	D
5	E

ID	Location
1	UP
2	Bihar
3	Andhra Pradesh
4	Karnataka
5	Maharashtra
6	West Bengal
7	Gujarat
8	Rajasthan

Suppose, Users - A,B,C must have access to Location - UP, Rajasthan and Bihar.

Then, user will select - users -A,B,C From userscheckboxlist and Location - UP, Rajastahn,Bihar from LocationCheckboxlist.

On button click event - Following data must be inserted -

UserID	Location
A	UP
B	UP
C	UP
A	Rajasthan
B	Rajasthan
C	Rajasthan
A	Bihar
B	Bihar
C	Bihar

How to do this ??

Please guide ..

Brijesh Rathor · Answer

Hi, Try like this, for frontend : - --------------------------------- for backend :- -------------------------------------------- // Here i added user and location list for checkboxlist public class users { public int id { get; set; } public string Value { get; set; } public bool isselected { get; set; } } public class USERS { public static List userList { get { List lst = new List (); lst.Add(new users() { id = 1, Value = "A" ,isselected = false}); lst.Add(new users() { id = 2, Value = "B" }); lst.Add(new users() { id = 3, Value = "C" }); lst.Add(new users() { id = 4, Value = "D" }); lst.Add(new users() { id = 5, Value = "E" }); return lst; } } } public class USERLOCATIONS { public static List userlocationList { get { List lst = new List (); lst.Add(new users() { id = 1, Value = "UP" , isselected = false }); lst.Add(new users() { id = 2, Value = "BIHAR" }); lst.Add(new users() { id = 3, Value = "ANDHRAPRADESH" }); lst.Add(new users() { id = 4, Value = "KARNATAKA" }); lst.Add(new users() { id = 5, Value = "MAHARASTRA" }); lst.Add(new users() { id = 6, Value = "WESTBENGAL" }); lst.Add(new users() { id = 7, Value = "GUJRAT" }); lst.Add(new users() { id = 8, Value = "RAJSTHAN" }); return lst; } } } protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { chkUserlist.DataSource = USERS.userList; chkUserlist.DataTextField = "Value"; chkUserlist.DataValueField = "id"; chkUserlist.DataBind(); chkUserLocationslist.DataSource = USERLOCATIONS.userlocationList; chkUserLocationslist.DataValueField = "id"; chkUserLocationslist.DataTextField = "Value"; chkUserLocationslist.DataBind(); } } protected void Submit_Details(object sender , EventArgs e) { int selectedUserCount = chkUserlist.Items.Cast ().Count(li => li.Selected); int selectedLocationCount = chkUserLocationslist.Items.Cast ().Count(li => li.Selected); List selectedusersarray = new List (); List selectedlocationarray = new List (); IEnumerable newuserid = new List (); IEnumerable newuserlocations = new List (); string items = string.Empty; string itemsuserlocations = string.Empty; string[] userid = new string[selectedUserCount]; string[] userlocation = new string[selectedLocationCount]; // Getting all checked userTexts foreach (ListItem i in chkUserlist.Items) { if (i.Selected == true) { items += i.Text + ","; } } // Getting all checked userLocationTexts foreach (ListItem j in chkUserLocationslist.Items) { if (j.Selected == true) { itemsuserlocations += j.Text + ","; } } // Converted usertext and userlocation into list for (var i = 0; i { var data = chkUserLocationslist.Items[i]; if (data.Selected == true) { userid = items.Split(','); userlocation = itemsuserlocations.Split(','); newuserid = userid.Take(userid.Count() - 1); newuserlocations = userlocation.Take(userlocation.Count() - 1); } } // getting required usersids result for (var k = 0; k { selectedusersarray.AddRange(newuserid); } // getting required location result for (var ki = 0; ki { if (chkUserLocationslist.Items[ki].Selected == true) { var dataresult = chkUserLocationslist.Items[ki]; for (var k = 0; k { if(newuserid.Count() > k) selectedlocationarray.Add(dataresult.Text); } } } Hope this will help u.

Mayank · Answer

Model Class: using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace ValidationsMvc.Models { public class CheckBoxClass { public List Usr { get; set; } public List Loc { get; set; } public string LocationList { get; set; } public string UserList { get; set; } } public class Users { public int Id { get; set; } public string UserName { get; set; } } public class Location { public int Id { get; set; } public string LocationName { get; set; } } } Controller code: public ActionResult CheckBoxListSelection() { var user = new Users { Id= 1, UserName = "A" }; var user2 = new Users { Id = 2, UserName = "B" }; var user3 = new Users { Id = 3, UserName = "C" }; List list = new List (); list.Add(user); list.Add(user2); list.Add(user3); var loc = new Location { Id = 1, LocationName = "UP" }; var loc2 = new Location { Id = 2, LocationName = "Delhi" }; var loc3 = new Location { Id = 3, LocationName = "Bihar" }; List lst = new List (); lst.Add(loc); lst.Add(loc2); lst.Add(loc3); var model = new CheckBoxClass { Usr = list, Loc=lst }; return View(model); } [HttpPost] public ActionResult CheckBoxListSelection(CheckBoxClass model) { //Here you will get the location and user in list u can split it by split function and save in DB return RedirectToAction("CheckBoxListSelection"); } View: @model ValidationsMvc.Models.CheckBoxClass @* ~/Models/CheckBoxClass.cs *@ @{ ViewBag.Title = "CheckBoxListSelection"; } CheckBoxListSelection @using (Html.BeginForm("CheckBoxListSelection", "Home", FormMethod.Post)) { @foreach (var items in Model.Usr as List ) { @items.UserName } @Html.HiddenFor(M => M.UserList, new { id = "userIdLst" }) @foreach (var items in Model.Loc as List ) { @items.LocationName } @Html.HiddenFor(M => M.LocationList, new { id = "locIdLst" }) } $(document).ready(function () { //alert("alert"); }); function BtnClick() { var idslist = ""; $("input:checkbox[class=chkclass]").each(function () { if ($(this).is(":checked")) { var userid = $(this).attr("value"); if (idslist != "") idslist = idslist + ','+userid ; else idslist = userid; } }); $("#userIdLst").val(idslist); alert(idslist); idslist = ""; $("input:checkbox[class=chkLocclass]").each(function () { if ($(this).is(":checked")) { var userid = $(this).attr("value"); if (idslist != "") idslist = idslist + ',' + userid; else idslist = userid; } }); $("#locIdLst").val(idslist); // locIdLst alert(idslist); } If this resolve your issue please mark as answer

Manas Mohapatra · Answer

Try with below code.. foreach (ListItem userItem in checkboxlistusers.Items) { if (userItem.Selected) { foreach (ListItem locationItem in checkboxlistlocation.Items) { if (locationItem.Selected) { var locationName = locationItem.Value; var userName = userItem.Value; // insert locationName, userName into database.. } } } }

Suvendu Shekhar Giri · Answer

Share the relevant code you have tried so far.

Insert values from Checkboxlist

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)