Databind in checkbox list in ASP.NET

Bytajuddin

Feb 28, 2012 #APEX, #checkbox, #checkboxlist, #databind, #dynamic databind, #formview, #Oracle, #sql server, #sqldatasource

Checkbox list does not support multiple databind. To be a bit clearer, it does not support databind for multi select in checkbox list. It only stores one entry from the checkbox list.

In one of my recent project I had to implement checkbox list where user can tick multiple checkboxes and store them into the database table. In this project I was using SQL server express database and storing the data using the data in colon (:) delimited value so that I can push the data back into Oracle database to use this in Oracle APEX application. You can store your data whatever fashion you want to save in. In oracle APEX application it is an in build feature where you can bind data dynamically in checkbox list. Unfortunately you can not do this in ASP.NET.

Lets start the task, I have used SqlDataSource for database operation in this example and connection string pulled from web.config file. Here is my SqlDataSource structure –

01<asp:SqlDataSource ID="dsImported" runat="server" ConnectionString="<%$ ConnectionStrings:ApplicationServices %>"
02        SelectCommand="SELECT * FROM [rtt_sites] where sit_id=@sit_id" UpdateCommand="update rtt_sites set name=@name, sit_type=@sit_type, status=@status, primary_function=@primary_function, fee_type=@fee_type, access_type=@access_type, update_date=getdate() where sit_id=@sit_id">
03        <UpdateParameters>
04            <asp:Parameter Name="sit_id" Type="Decimal" />
05            <asp:Parameter Name="name" Type="String" />
06            <asp:Parameter Name="status" Type="String" />
07            <asp:Parameter Name="primary_function" Type="String" />
08        </UpdateParameters>
09        <SelectParameters>
10            <asp:QueryStringParameter QueryStringField="sit" Name="sit_id" Type="Int32" />
11        </SelectParameters>
12    </asp:SqlDataSource>

In the above sqldatasource I am actually using a query string to fetch data in a Formview. User can update or change record if they want to. Now here is my formview structure –

01<asp:FormView ID="FormView1" runat="server" AllowPaging="True"
02        DataKeyNames="recId" DataSourceID="dsImported" DefaultMode="Edit"
03        Width="100%">
04        <EditItemTemplate>
05 
06        <table cellpadding="3" cellspacing="3" >
07        <tr><th>Record Id:</th><td><asp:Label ID="Label1" runat="server" Text='<%# Eval("recId") %>' /></td></tr>
08<tr><th>Site Id:</th><td><asp:TextBox ID="sit_idTextBox" runat="server" Text='<%# Bind("sit_id") %>' ReadOnly="true" /></td></tr>
09<tr><th>Site Name:</th><td><asp:TextBox ID="nameTextBox" runat="server" Text='<%# Bind("name") %>' ReadOnly="true" Width="400" /></td></tr>
10<tr><th>Site Type: </th><td>
11    <asp:CheckBoxList ID="chkSiteType" runat="server" RepeatColumns="5" DataSourceID="dsSiteType"
12        DataTextField="description" DataValueField="returnVal">
13    </asp:CheckBoxList>
14 
15        <tr><th>Status:</th><td>
16            <asp:DropDownList ID="dlStatus" runat="server" selectedValue='<%# Bind("status") %>' >
17            <asp:ListItem  Text="Select status" Value="" />
18            <asp:ListItem Text="Current" Value="CURRENT" />
19            <asp:ListItem Text="Closed" Value="CLOSED" />
20 
21            </asp:DropDownList>
22        </td></tr>
23<tr><th>Primary function:</th><td> 
24    <asp:DropDownList ID="dlPrimaryFunction" runat="server"
25        selectedValue='<%# Bind("primary_function") %>' DataSourceID="dsSiteType"
26        DataTextField="description" DataValueField="returnVal" AppendDataBoundItems="true" >
27    <asp:ListItem Value="" Text="Select function" />
28 
29    </asp:DropDownList>
30</td></tr>
31<tr><th>Longitude: </th><td><asp:TextBox ID="txtLongitude" runat="server" Text='<%# Bind("longitude") %>' Width="200" /></td></tr>
32        <tr><th>Latitude: </th><td><asp:TextBox ID="txtLatitude" runat="server" Text='<%# Bind("latitude") %>' Width="200" /></td></tr>
33        <tr><th>Fee Type:</th><td> 
34            <asp:CheckBoxList ID="chkFeeType" runat="server" RepeatColumns="6">
35                <asp:ListItem Value="ANOFEES">No Fees</asp:ListItem>
36                <asp:ListItem Value="BOAT">Boat Tour</asp:ListItem>
37                <asp:ListItem Value="PARK">Park Entry</asp:ListItem>
38                <asp:ListItem Value="CAMPING">Camping</asp:ListItem>
39                <asp:ListItem Value="CAVING">Caving</asp:ListItem>
40                <asp:ListItem Value="SITE">Site Entry</asp:ListItem>
41 
42            </asp:CheckBoxList>
43        </td></tr>
44        <tr><th>Access Type: </th><td><asp:CheckBoxList ID="chkAccessType" runat="server"
45                RepeatColumns="7">
46            <asp:ListItem Value="BICYCLE">Bicycle</asp:ListItem>
47            <asp:ListItem Value="BUS">Bus</asp:ListItem>
48            <asp:ListItem Value="CANOE">Canoe</asp:ListItem>
49            <asp:ListItem Value="CAR">Car</asp:ListItem>
50            <asp:ListItem Value="CARAVAN">Caravan</asp:ListItem>
51            <asp:ListItem Value="AIRCRAFT">Fixed Wing Aircraft</asp:ListItem>
52            <asp:ListItem Value="FOOT">Foot</asp:ListItem>
53            <asp:ListItem Value="4WD">Four Wheel Drive</asp:ListItem>
54            <asp:ListItem Value="HELICOPTER">Helicopter</asp:ListItem>
55            <asp:ListItem Value="HORSE">Horse</asp:ListItem>
56            <asp:ListItem Value="PWR_BOAT">Power Boat</asp:ListItem>
57            <asp:ListItem Value="SAIL_BOAT">Sail Boat</asp:ListItem>
58            <asp:ListItem Value="Bike">Trail Bike</asp:ListItem>
59            </asp:CheckBoxList> </td></tr>
60<tr><th>Created on: </th><td><asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("create_date") %>'  ReadOnly="true"  /></td></tr>
61<tr><th>Last updated: </th><td><asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("update_date") %>' ReadOnly="true" /></td></tr>
62<tr><th>Created on: </th><td></td></tr>
63<tr><th>Created on: </th><td></td></tr>
64<tr><th>Created on: </th><td></td></tr>
65        </table>
66            <asp:Label ID="lblFeetype" runat="server" Text='<%# Eval("fee_type") %>' Visible="false" /> <br />
67            <asp:Label ID="lblAccessType" runat="server" Text='<%# Eval("access_type") %>' Visible="false" /> <br />
68           <asp:Label ID="lblSiteType" runat="server" Text='<%# Eval("sit_type") %>' Visible="false" />
69            <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True"
70                CommandName="Update" Text="Update" />
71            &nbsp;<asp:LinkButton ID="UpdateCancelButton" runat="server"
72                CausesValidation="False" PostBackUrl="~/importSite.aspx" Text="Cancel" />
73 
74                <asp:SqlDataSource ID="dsSiteType" runat="server"
75        ConnectionString="<%$ ConnectionStrings:ApplicationServices %>"
76        SelectCommand="SELECT [description], [returnVal] FROM [rtt_param] WHERE ([CODE] = @CODE)">
77        <SelectParameters>
78            <asp:Parameter DefaultValue="SITE_TYPE" Name="CODE" Type="String" />
79        </SelectParameters>
80    </asp:SqlDataSource>
81        </EditItemTemplate>
82 
83    </asp:FormView>
84    <asp:Label ID="lblMsg" runat="server" ></asp:Label>
85<br />

Now in the above formview I also have couple of dynamic dropdown list populated from database table. Hope it is easy to understand. If you look at the above code closely, you will notice I have binded data in all textbox and dropdown list controls however I did not bind data in checkbox list control at this stage.

Lets start first bind the data dynamically in those checkboxes. So I want to bind data on formview databound event. To retrieve the value from database for these checkboxes I have created a few labels to fetch the data. I also have set the visible property to false so that they are not visible to user.

Now the aim is to grab the value from these label controls and split them into arrays then fetch the data into checkbox list control :).

In VB –

01Protected Sub FormView1_DataBound(sender As Object, e As System.EventArgs) Handles FormView1.DataBound
02        'access the checkbox list control in Formview
03        Dim c As CheckBoxList = CType(FormView1.FindControl("chkFeeType"), CheckBoxList)
04         'access the Label control in Formview
05        Dim feeType As Label = CType(FormView1.FindControl("lblFeetype"), Label)
06        'get the value of label field
07        Dim rawVal As String = feeType.Text
08 
09        'create an array using split 
10        Dim str As String() = rawVal.Split(":"c)
11 
12        'loop through the array and bind to checkbox list
13        For i As Integer = 0 To c.Items.Count - 1
14            If str.Contains(c.Items(i).Value) Then
15                c.Items(i).Selected = True
16            End If
17        Next
18 
19    End Sub

In C# –

01FormView1_DataBound(object sender, System.EventArgs e)
02{
03    //access the checkbox list control in Formview
04    CheckBoxList c = (CheckBoxList)FormView1.FindControl("chkFeeType");
05    //access the Label control in Formview
06    Label feeType = (Label)FormView1.FindControl("lblFeetype");
07    //get the value of label field
08    string rawVal = feeType.Text;
09 
10    //create an array using split 
11    string[] str = rawVal.Split(':');
12 
13    //loop through the array and bind to checkbox list
14    for (int i = 0; i <= c.Items.Count - 1; i++) {
15        if (str.Contains(c.Items(i).Value)) {
16            c.Items(i).Selected = true;
17        }
18    }
19 
20}

[warning]I have omitted some codes here, just wanted to show one example how to fetch checkbox list dynamically. Follow the same procedure if you have multiple checkbox list like mine.[/warning]

Here is the screen shot when data fetched in checkboxes –

Data Bind in Checkbox list — CheckBoxList

You can see in the above screen data are nicely fetched in CheckboxList. Now the question is how can I update the data when user tick or un-tick any of those check boxes. Well to do this I had to create a custom function and event and call that in page load to bind update parameters in sqldatasource.

Lets look at the function first, this function basically grab the value from checkboxlist and combine them together in whatever format I want.

In VB –

01Private Function GetStringFromCheckBoxList(ByVal chk As CheckBoxList) As String
02 
03        Dim strTemp As String = String.Empty
04 
05        For Each lst As ListItem In chk.Items
06            If lst.Selected Then
07                strTemp = strTemp & lst.Value & ":"
08            End If
09        Next
10 
11        Return strTemp.Trim(":")
12 
13    End Function

In C# –

01private string GetStringFromCheckBoxList(CheckBoxList chk)
02{
03 
04    string strTemp = string.Empty;
05 
06    foreach (ListItem lst in chk.Items) {
07        if (lst.Selected) {
08            strTemp = strTemp + lst.Value + ":";
09        }
10    }
11 
12    return strTemp.Trim(":");
13 
14}

The above function basically grabbing the selected value from checkbox list and return as string with colon(:) separated value. Now I got the the string value and I have to update the database column. Here is my code on page load –

In VB –

01Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
02        'access the checkbox lists in FormView control
03        Dim chkBox As CheckBoxList = CType(FormView1.FindControl("chkFeeType"), CheckBoxList)
04        Dim chkAccess As CheckBoxList = CType(FormView1.FindControl("chkAccessType"), CheckBoxList)
05        Dim chkSite As CheckBoxList = CType(FormView1.FindControl("chkSiteType"), CheckBoxList)
06        If Me.IsPostBack Then
07 
08            'collect and format the checkbox list values and set to string variable
09            Dim st As String = GetStringFromCheckBoxList(chkBox)
10            Dim ac As String = GetStringFromCheckBoxList(chkAccess)
11            Dim sit As String = GetStringFromCheckBoxList(chkSite)
12 
13            'assign update parameter values here to update database
14            dsImported.UpdateParameters.Add("fee_type", st)
15            dsImported.UpdateParameters.Add("access_type", ac)
16            dsImported.UpdateParameters.Add("sit_type", sit)
17        End If
18 
19    End Sub

In C# –

01Page_Load(object sender, System.EventArgs e)
02{
03    //access the checkbox lists in FormView control
04    CheckBoxList chkBox = (CheckBoxList)FormView1.FindControl("chkFeeType");
05    CheckBoxList chkAccess = (CheckBoxList)FormView1.FindControl("chkAccessType");
06    CheckBoxList chkSite = (CheckBoxList)FormView1.FindControl("chkSiteType");
07 
08    if (this.IsPostBack) {
09        //collect and format the checkbox list values and set to string variable
10        string st = GetStringFromCheckBoxList(chkBox);
11        string ac = GetStringFromCheckBoxList(chkAccess);
12        string sit = GetStringFromCheckBoxList(chkSite);
13 
14        //assign update parameter values here to update database
15        dsImported.UpdateParameters.Add("fee_type", st);
16        dsImported.UpdateParameters.Add("access_type", ac);
17        dsImported.UpdateParameters.Add("sit_type", sit);
18    }
19 
20}

Now here is your fully functional checkbox list databind in very simple and easy way. Let me know if you have any problem or issue implementing this. Good luck

By tajuddin

APIM Azure C#

11 thought on “Databind in checkbox list in ASP.NET”

chad hughes says:

November 25, 2012 at 11:22 pm

Have a smiliar project was wondering if you are available or interested.

Thanks.

Chad Hughes

Reply
than says:

January 20, 2013 at 7:16 pm

Thiѕ tеxt is іnvaluable. When can I find out moге?

Reply
Some Thoughts on Online Bingo Jackpots says:

February 2, 2013 at 5:08 am

I comment each time I especially enjoy a article on a website
or if I have something to valuable to contribute to the discussion.
It’s caused by the sincerness displayed in the article I browsed. And on this article Databind in checkbox list in ASP.NET | Tajuddin’s Blog.
I was excited enough to drop a commenta response I actually do have a couple
of questions for you if it’s allright. Could it be only me or do some of these comments look as if they are written by brain dead people? And, if you are writing at other online sites, I’d like to keep up with
everything new you have to post. Could you make a list
the complete urls of all your communal pages like your linkedin profile, Facebook page or twitter feed?

Reply
Deals restaurants says:

February 5, 2013 at 3:41 am

Hi there, I lοg on to your blog on а геgulаr basis.
Υour writіng style is witty, keeр uρ the good ωοгκ!

Reply
Page Idemoto says:

February 20, 2013 at 8:43 pm

I hardly create remarks, however i did some searching and wound up here
Databind in checkbox list in ASP.NET | Tajuddin’s Blog. And I actually do have a couple of questions for you if it’s allright.
Could it be only me or does it look like some of these responses
come across like they are coming from brain dead visitors?
And, if you are posting on additional places, I would like to follow anything
fresh you have to post. Could you make a list of every one of all your public pages like your
linkedin profile, Facebook page or twitter feed?

Reply
Beatrice says:

May 5, 2013 at 11:05 am

Excellent post! We are linking to this great content on our site.
Keep up the great writing.

Reply
remote computer support Charlotte says:

May 5, 2013 at 11:22 am

Woah! I’m really enjoying the template/theme of this website. It’s simple, yet effective.

A lot of times it’s hard to get that “perfect balance” between superb usability and visual appearance. I must say you have done a very good job with this. Also, the blog loads extremely quick for me on Internet explorer. Outstanding Blog!

Reply
Charlotte remote computer support says:

May 12, 2013 at 4:48 am

Saved as a favorite, I really like your web
site!

Reply
bugs bunny t-shirts transfers says:

May 18, 2013 at 8:34 am

I always spent my half an hour to read this webpage’s articles or reviews every day along with a mug of coffee.

Reply
visit the website says:

December 24, 2013 at 12:57 pm

Hi there! This is my 1st comment here so I just wanted to give a quick shout out and
say I genuinely enjoy reading through your blog posts. Can you suggest any
other blogs/websites/forums that go over the same subjects?
Thanks!

Reply
Gary says:

September 18, 2014 at 9:51 pm

Great article, can you send me the source code for study. Thank you

Reply

Databind in checkbox list in ASP.NET

Bytajuddin

By tajuddin

Related Post

Setting up CORS in Azure APIM policy

jQuery Datatable with Blazor in ASP.NET 6

ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege for PDB in OCI

11 thought on “Databind in checkbox list in ASP.NET”

Leave a Reply to bugs bunny t-shirts transfers Cancel reply

You missed

Backup and restore Azure APIM

Why we should not save passwords in browsers – Cyber security awareness

Setting up CORS in Azure APIM policy

Add Azure DevOps agent IP address to Storage Account firewall using PowerShell and CI/CD pipeline