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.