Tracking Forums, Newsgroups, Maling Lists
Home Submit Tracker Forums
  Advanced Search


Forms Data Controls :: Use A CheckBoxList.SelectedItems As A Gridview Datasource?

Cana CheckBoxList.SelectedItems be used as a Gridview datasource?

View 8 Replies (Posted: Dec 30, 2010 07:57 PM)

Sponsored Links:

Related Forum Messages For ASP.NET category:
Forms Data Controls :: Save Checkbox Selecteditems On Pageindex Changing In Gridview
I have a gridview where the user can use the checkbox to select items that he wants. I have enabled the pageindex cahnging for the gridview. so my proclem is how to retain the checkbox selection when the user navigates from page 1 to page 2 and back to page 1 in gridview i tried it doing session id but it dosen't seem to work.

Posted: Nov 06, 2009 05:03 AM

View 1 Replies!   View Related
Storing SelectedItems Values Of A Checkboxlist In An Array?
what is the best way to store the selected items value of a checkbox list in an array in VB.Net?

Posted: Dec 31, 2009 12:32 AM

View 2 Replies!   View Related
Design Decisions - CheckBoxList Doesn't Have A SelectedItems Member?
Whenever I want to get selected items I have to loop through each item and see if it's selected. They even have a SelectedItem (no "s" at the end) member which seems odd for a CheckBoxList. It seems like a logical thing to have, does anyone know why they haven't added it?

Posted: Sep 22 10 at 16:29

View 4 Replies!   View Related
DataSource Controls :: CheckBoxList And SqlDataSource To GridView?
I would like to have my data shown in gridview based on selecting multi-value from the checkboxlist, but it seems that the gridview is only able to response one ticked box in the checkboxlist. i checked with selectcommand by changing to "SELECT * FROM cities WHERE country IN (France,Italy, Germany)" and it shows the data correctly in the gridview, therefore I believe that its either that checkboxlist is not passing multi-values to the sqldatasource, or some code is needed to modify in the sqldatasource to accept multiple values from the checkboxlist. I have no clue what and where to do.

Posted: Mar 24, 2008 08:04 PM

View 5 Replies!   View Related
Forms Data Controls :: Value Of Datasource Of Checkboxlist Is Becoming Null
Page 1: To add a record in to DB. At this page, as per the user requests , few controls will be added to the page from server side code. one of them is checkbox list. and when user is requesting to save data, its going to the DB. Everything is fine upto now.

Page 2: To edit the record which is entered from page no 1.When user requests to edit the record entered at page no 1, i'm redirecting user to this update page, with record id, and generating the required controls to show the values. Now the main problem is :

When page is loading first time, I m creating the required controls and then assigning the values to them to edit. but after that at each postback, the value of datasource of checkboxlist is becoming null, same case is with the label control. but the value of textbox is same, it is not becoming empty at each postback. In code: In code i have created two method to generate controls.

1st is : to create new controls, and to assign values to them

2nd is : to regenerate the controls at each postback, with the same IDs, but not assigning any value here.

I think viewstate will reload the values of respective controls, if IDs are same.

Posted: Sep 09, 2010 10:00 AM

View 4 Replies!   View Related
Forms Data Controls :: Populating Gridview From Checkboxlist?
I am using a checkboxlist that gets its data from a textboxcontrol that I use as a search. The checkboxlist is output to a gridview. All of this works fine. The problem is that when I try to searcg again and then select more data from the cehckboxlist the onclick wipes out the previous search selections. I want to be able to populate the gridview from all search selections made concurrently. Below is my code


Posted: Nov 18, 2009 10:00 PM

View 2 Replies!   View Related
Forms Data Controls :: Filtering GridView Based On CheckBoxList?
I have a CheckBoxList that is bound to the database with a DataSource control. A GridView also is boundwith another DataSource control. Is there a way to filter GridView based on what is checked in CheckBoxList control?

Posted: Nov 19, 2009 03:41 PM

View 6 Replies!   View Related
Forms Data Controls :: Checkboxlist To Retrieve Data From Database To Display Results In Gridview?
I have a page where I will insert all the data into the database. The page where I'm having problems is when I select an item from the checkboxlist it only displaysone item.The data which is displayed is only the one that was inserted withone selected item from the checkboxlist. The following code is the page I'm using to try to retrieve the data from the database. I am trying to do is when a user selects the first, second, or third, or fourth item. The corresponding data appears in the gridview. In my current code,the record which has one item selected appears. If the user has more than one selected it does not appear. It comes up as empty. Is there a way I can do it?


Posted: Jun 23, 2010 01:44 AM

View 4 Replies!   View Related
Forms Data Controls :: How To Insert, Update Checkboxlist With Detailsview,gridview
I have a checkboxlist control inside the detailsview form. I am using the insert command in the detailsview. My problem is if I check multiple listitems, it only insert one selected value. I know I have to iterate the checkboxlist control to get all the selected value but how do I do it with the detailsview built in insert command? I used the checkboxlist databound event to get the value and pass this as a session variable to the insert sql statement

<asp:CheckBoxList ID="chkAchieved" runat="server" Font-Size="Smaller"
SelectedValue='<%# Bind("achieved") %>'

Posted: Dec 02, 2009 03:42 PM

View 1 Replies!   View Related
Forms Data Controls :: Finding A CheckBoxList Inside GridView's ItemTemplate?
I have tried and tried to find a CheckBoxList control inside my ItemTemplate in my GridView control. However I have run out of ideas. I'm also having issues of databinding the CheckBoxList control to ItemTemplate as well. I'm doing the DataBind operation on codebehind and it works as it should be. I have only issues by working with CheckBoxList control

My code looks like this:


<asp:GridView ID="grdMyGrid" runat="server" AutoGenerateColumns="false" EmptyDataText="No results found" OnRowDataBound="grdMyGrid_RowDataBound">
<asp:TemplateField HeaderText="Select">
<asp:CheckBoxList ID="chkListMyCheckBoxList" runat="server" />


Posted: Sep 19, 2009 09:49 AM

View 4 Replies!   View Related
Forms Data Controls :: Update Database By Using Checkboxlist In Edit Template Field In Gridview Rowupdating
Ihave a checkboxlist in a template field in a gridview and when in edit mode, im trying to gather what the user has selected, builda string from it, and then set an UpdateParameter to it and update the database.

I am trying like below, but I keep getting an Object Reference Not SetTo Instance of Object error.


Posted: Dec 09, 2009 04:36 AM

View 3 Replies!   View Related
DataSource Controls :: Reading / Storing Values Of Checkboxlist In SQL (VB)
I'm trying to store multiple selected checkboxes from a single checkboxlist, but i don't know where to start. Imagine i have three tables: tbl_events, tbl_organisors and tbl_settings and i want to store the organisors of an event. Each event can have multiple organisors, so each organisor should be added as a single row into tbl_settings. I know how to bind tbl_organisors to a checkboxlist, but how do i store the results (meaning: add the rows to tbl_settings) ?

tbl_events: Event_ID (PK) and Event_Name
tbl_organisors: User_ID and user_name.
tbl_settings: Settings_ID (PK), Event_ID and User_ID





Initially all checkboxes will be unchecked, but users must be able to select multiple organisors from the checkboxlist and then store them into the DB by submitting a form. So the query will look something like: INSERT INTO tbl_settings (user_id, event_id) VALUES (@user_id, @event_id). And this is where my head cracks

1) How do i loop through all selected checkboxes and store each value (user_id) in a new row in tbl_settings?
2) After saving, the users reloads the page and the organisors he just selected must be selected by default in the checkboxlist. How?

Posted: Sep 22, 2010 02:29 PM

View 2 Replies!   View Related
DataSource Controls :: Checkboxlist / How To Fix The Table So Values Are Stored OK
I need to fix the table so values are stored ok.

Now I think I should have the values of music feature set by default to 0

What should I modify in the below table. as well as profileid should be a foreign key constraint.


Posted: Jan 16, 2010 09:32 PM

View 1 Replies!   View Related
DataSource Controls :: Multiple Selection Checkboxlist To Database?
i need to know how i can save more than 1 of the selected values from a checkboxlist to a database. I tried the following code.

ArrayList test = new ArrayList();
for (int i = 0; i < CheckBoxListMeest.Items.Count; i++)


The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MeestenEvaluatie_MeestGeAsp". The conflict occurred in database "GIPDatabase", table "dbo.MeestGeAsp", column 'EvMeestID'. The statement has been terminated.

Posted: Apr 27, 2010 07:09 PM

View 3 Replies!   View Related
DataSource Controls :: CheckBoxList Items Save To Database?
I've this checkboxlist with differentsports items inside (Example Swimming, Floorball, Basketball and etc). Users are able to check/tick more than one item as they may be interested in lots of different sports.However, I realised that I'm not able to save all the items that the user has checked into the database; only an item will be saved. How can I save all the items that the user has checked into the database?The codes I'm implementing now:cblSportsInterest.SelectedValue (to save the value into the database)

Posted: Jan 04, 2010 02:02 PM

View 4 Replies!   View Related
Web Forms :: Get The Selecteditems Count In Listbox?
I am trying to get a count of all the selected item in my listbox by using listboxa.SelectedItems.Count but keep getting Error6'System.Web.UI.WebControls.ListBox' does not contain a definition for 'SelectedItems'. I am using C# Visual Studio 2005

my .aspx code is as follow: Error6'System.Web.UI.WebControls.ListBox' does not contain a definition for 'SelectedItems' <asp:ListBox ID="ddlAvailable" runat="server" Height="200px" Width="420px" SelectionMode="Multiple" />

Posted: May 30, 2007 03:02 PM

View 7 Replies!   View Related
Data In CheckBoxList To Gridview
I have a CheckBoxList like this. (There are customer name)Every customer has a customer number (Unique -- Primary Key)

MUS_K_ISIM represent Customer Name
HESAP_NO represent Customer Number

I have a Send Button and Gridview.When i click the Send Button, In my Gridview, I just want run this SQL;


But as you can see bottom of th SQL, I just want to show "Which customers i selected in CheckBoxList" in my Gridview.

Posted: Mar 21 at 16:56

View 2 Replies!   View Related
DataSource Controls :: Building String To Pass Into StoredProcedure From CheckBoxList?
I have a CheckBoxList that I need to get the values from, concatenate, and pass into a stored procedure in SQL Server 2005 utilizing Visual Basic. Due to the way our data layer is I cannot use a SqlCommand object at this level.

I have no problem getting to the selected values in the CheckBoxList:

Dim selectedValue As New StringBuilder
For i = 0 To cblMethods.Items.Count -1
If cblMethods.Items(i).Selected Then
End If

The problem is that I do not know how to list the values in such a way that my stored procedure will pull data:

SET @MethodNames ='GetWords','GetLetters'
SELECT * FROM TABLE WHERE method IN ( @MethodNames )
I've tried experimenting with apostraphes but cannot make it work:
selectedValue.Append("'''" + cblMethods.Items(i).Text + "''', "

Posted: Jul 01, 2010 08:21 PM

View 2 Replies!   View Related
DataSource Controls :: Selecting Multiple Values From A Checkboxlist And Submitting To DB Individually
I need to select multiple values from a checkboxlist and submit them individually to my SQL Server database.

I am developing in

Posted: Nov 17, 2009 06:54 PM

View 1 Replies!   View Related
Forms Data Controls :: Set CheckBoxList In Three Colums?
How can I set my Checkboxlist in tree columns?

This is my SqlDataSource


This is my CheckBoxList


Posted: Mar 23, 2011 03:39 PM

View 1 Replies!   View Related
Forms Data Controls :: Insert To Data Table Checkboxlist Items Within For Loop?
in my button4 click event, i want to insert checboxlist items to data table. first i want to delete all of the exisiting and then insertagain.

my code is below but it is not workingif you couldexplain anyone?

in page load I have writtencodeso that existing checkbox itemsare selected.


Posted: Jun 01, 2010 09:17 AM

View 5 Replies!   View Related
Forms Data Controls :: Retrieving Data From Database To Populate CheckBoxList - C#
I am somewhat new at C# so forgive me if I have something listed wrong. This is what I got:

I am working on a school project designing a car dealership website. I have an inventory list that allows you to edit any car in the inventory. When you click on the edit button it takes you to the edit page and populates the controls with selections from the database. I have an options table that stores the VehicleID and Option ID. When the page loads it fills all the DropDownLists for the vehicle info with the data and selects the correct item according to the database selection but the CheckBoxList does not select the items that are on the Options table. I checked the query in SSMS and it returns the correct data. I have stepped through the method and it works till the "(currentCheckBox != null) if statement. It doesn't throw any errors but it also doesn't select items when the page renders.

I thought it might have been something with the page life cycle since databound controls don't render until the end but the DropDown's I have fill and selects the correct item according to the database.

Posted: Feb 24, 2011 10:38 PM

View 2 Replies!   View Related
Forms Data Controls :: Adding Data To CheckBoxList Dynamically From Database?
Scenario : I want to add data from database to checklistbox on page_load and checked data should be stored in other table.I want to bind data to checklistboxlike a gridview, i m trying but i m not able to.

Posted: May 06, 2010 07:42 AM

View 2 Replies!   View Related
Forms Data Controls :: Checkboxlist In Formview Edittemplate Data Display?
I can insert a checkboxlist selected value as comma delimited string into the database. But I have hard time to reload it in formview edit mode. I added a hidden label to retrieve the comma delimited string and try to use checkboxlist databound event, but it doesn't work. I don't know what problem is in my code.



Posted: Oct 14, 2010 03:23 AM

View 7 Replies!   View Related
Forms Data Controls :: How To Set The Column Width In CheckBoxList Row
I have a form with 3 CheckBoxLists in a row. All three are databound, and setup like this:


The problem is that since I can't seem to figure out how to set the width of the individual cells, which means the columns in each list don't match up with the other lists, and the design doesn't look clean.

Is there some way to set the column width that I am overlooking?

Posted: Mar 26, 2007 08:40 PM

View 8 Replies!   View Related
Forms Data Controls :: Checkboxlist With Autocomplete Functionality
I have spent lot of time to implement the functionality of checkboxlist with autocomplete like GMAIL.

Posted: Jun 29, 2010 12:02 PM

View 4 Replies!   View Related
Forms Data Controls :: Getting CheckBoxList ListItems In And Out Of A Session?
Need a little guidance on handling selected items in a listview and sessions.

First, the CheckBoxList looks like this:


In the code behind for that page, I'm trying to put the store the selected values into the session like this:


Finally, I want to retrieve the items and wind up with a string containing the items (I think I want a string--what I need to do is put the items into a variable so I can display them in a Label control and also include them in the text of an email that gets generated. Here is how I'm attempting to retrieve the items:


But my variable "Opportunities" ends up with this value: "System.Web.UI.WebControls.ListItemCollection".

Posted: Feb 28, 2011 10:16 PM

View 3 Replies!   View Related
Forms Data Controls :: CheckBoxList Within The Datalist Is Not Working
I am binding the datalist and the checkboxlist. The problem is that the outputed result is looped upto the total number rows in the table. Here is the code I have used,

<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1">
<asp:CheckBoxList ID="CheckBoxList1" runat="server" DataSourceID="SqlDataSource1" DataTextField="Email" DataValueField="Email">
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%&#36; ConnectionStrings:SiteSqlServer %>"
SelectCommand="SELECT [Email] FROM [aspnet_Membership]" >
I am having 15 rows in the table "aspnet_Membership".

The out put is displaying as the 15 rows for 15 times.

Posted: Nov 13, 2009 08:18 AM

View 3 Replies!   View Related
Forms Data Controls :: Setting The Layout Of A Checkboxlist?
i've tried to find a way by using css to make a diferent layout toa checkboxlist. I'd like to have the label above the input.

that's what i came up with. Still didn't work.


Posted: Oct 23, 2009 04:48 PM

View 9 Replies!   View Related
Forms Data Controls :: Pre-selecting Items In A CheckBoxList?
I am trying to pre-select checkboxes in a CheckBoxList control. The datasource provides three useful columns per item: id, name, selected_flag.

Posted: Apr 10, 2010 12:48 AM

View 2 Replies!   View Related
Forms Data Controls :: CheckboxList 101 - Checkmarks Are Not Showing?
Iwant to show a checkbocklist bound to a datasource. The datasource is a table with 2 columns. Column1= description of the checkbox, Column2 = atrue/false whether the box is checked or not.

I am able to create the checkboxlist control and bind it to the table but the checkmarks are not showing for values that are true.

Manager Approval
User Submit

Is there a predefined field type for the checked value? Does it have to be 0 or 1 or True/False or Checked/Unchecked in order for the checkboxlist to interpret it correctly?

Posted: Jun 03, 2010 02:10 PM

View 5 Replies!   View Related
Forms Data Controls :: CheckBoxList Updating The Database?
I have an issue here, I have a checksboxList that I have populated with content from database using this code:


Lstfn is the checkBoxList and obviously some of the contents are checked("Y") others aren't.

My question is this I am now trying to check the unchecked and be able to update the database(insert a new line into the facility table) or uncheck the checked (delete the checked line in the database/ facility table)

Posted: Oct 22, 2009 10:14 AM

View 5 Replies!   View Related
Forms Data Controls ::a Checkboxlist Binded To Sql Table ?
i have a checkboxlist binded to my sql tablewith one control parameter to checkboxlist which is lblcode.


Posted: Nov 19, 2010 03:14 AM

View 5 Replies!   View Related
Forms Data Controls :: Preselect All CheckBoxList Items?
I want to preselect _all_ the items in a CheckBoxList - it's bound to a data source and intended to allow the user to deselect an item. Seems like it should be duh simple but the following is not working, i.e. the box is not checked):

FooCheckBoxList.DataTextField = "FooName";
FooCheckBoxList.DataValueField = "FooID";
// Preselect the checkboxes
foreach (ListItem item in FooCheckBoxList.Items)
item.Selected = true;

Posted: Oct 16, 2009 10:45 PM

View 3 Replies!   View Related
Forms Data Controls :: Binding CheckBoxList In FormView?
I have a FormViewwhich will bindvalues from the databaseusing aID parameter from queryString. In my database, I have a field named CategoryList whichcan store multiple CategoryID (From Category table)in CSV format (eg: "1,3,4,5").I'm using SQLDataSource as my datasource.

So, I want to show the selected category in CheckBoxList. Meaning that, the checkbox will be checked (on page load) if its ID is in the CategoryList. Also, I want to allow the user to check/uncheck the CheckBoxList and updates to the database in CSV format. How can i do that?

Posted: Jul 22, 2010 02:27 AM

View 4 Replies!   View Related
Forms Data Controls :: Bind Checkboxlist Items Value To Data?
I working on a dontnetnuke module, and was wondering how can I bind a selected checkboxlist item into the databse

Now I got it like this, but this if or 'one' selected item.

But the thing I want it, that every one of them has their own Value (abPermission.TabID, TabPermission.PermissionID, TabPermission.AllowAccess, TabPermission.UserID) (tabhome = 6,6,6,6) (tabsupp = 7,7,7,7)

If I select 'one' or 'multiple' they values will be inserted into the database


Posted: Nov 30, 2010 12:00 PM

View 1 Replies!   View Related
Forms Data Controls :: CheckboxList And Sql Data Source Advanced?
I am attempting to create a list of top ? results of a specified column(s) of a specified table on a specified database. Sounds tricky, huh? I am attempting to create a key creator for a raw data table. So far I have a list of all raw column names in the table displaying on a checkboxlist control. On the page there is a checkboxlist control on the left. A drop down menu in the middle and a gridview (hidden until the checkboxlist selects an item) on the far right.Once the user selects an item on the checkboxlist control and also selects an item (or leaves it as default) in the drop down menu (values consist of : 1, 2, 3, 4, 5, ect.) the gridview will appear and display the top (value in the drop down menu) results of the selected column in the checkboxlist control (would be nice to allow the user to select multiple items and have the gridview grow as more columns are selected and shrink as they are deselected). I am having trouble figuring this out. So far I have attempted to write a dynamic sql stored procedure, add parameters to the sqldatasource and change the value at runtime, and now I am reaching out to the ASP.Net community.


Posted: Mar 30, 2010 08:27 PM

View 1 Replies!   View Related
Forms Data Controls :: Validation For Checkboxlist Inside Listview
I'm trying to do a validation for checkboxlist on a server side as all java approaches didn't work. However, probably due to the checklistbox is inside a listview the FindControl is empty. how to find a control inside a listview on a button click event when the button is outside of the listview.

ErrorMessage="* Please, select at least a one checkbox."
"Dynamic" />
Sub cblCustomValidator(ByVal objSource
As Object,
ByVal objArgs As ServerValidateEventArgs)
Dim chblAnswers As CheckBoxList = _
CType(lv_qstns.FindControl("chblAnswers"), CheckBoxList)
If CType(lv_qstns.FindControl("chblAnswers"), CheckBoxList)
IsNot Nothing
Then 'it's not working here as it cannot find the control inside a listview
Dim boolFlag As
Boolean = False
For Each li
As ListItem In chblAnswers.Items
If li.Selected Then
boolFlag = True
End If
If boolFlag Then
objArgs.IsValid = True
objArgs.IsValid = False
End If
End If
End Sub

Posted: Feb 24, 2011 09:21 PM

View 4 Replies!   View Related
Forms Data Controls :: Accessing A Nested CheckboxList In A ListView
SoIhave abound listviewand in each itemTemplate there is a checkboxlist bound tonested data. How can i see what checkboxes were checked on a postback event?

Posted: Oct 22, 2009 06:33 PM

View 1 Replies!   View Related
Copyright 2005-08, All rights reserved