Solved

Checkboxlist - set checked status from database

Posted on 2006-11-07
6
1,425 Views
Last Modified: 2009-07-29
I have a checkboxlist bound to an object data source in a VB ASP.NET 2.0 environment.

My object datasource returns a three column sqlDataReader with the following columns: "TagName", "TagID", "Selected". The "Selected" column is boolean. I set the "DataTextField" = "TagName" and the "DataValueField" = "TagID". Unfortunately there is no "DataCheckedField" property to set the selected status of the check box to the value from the "Selected" column.

When I load the checkboxlist I want the items for which  the "Selected" field from the database equals "True" to be selected in the checkboxlist. What is the easiest way to do this? If the answer involves setting it with code which it probably does, please use VB.

Note: I have no problem writing back the user's selections to the database.
0
Comment
Question by:glebn
  • 3
  • 2
6 Comments
 
LVL 12

Expert Comment

by:renjurdevan
ID: 17896337
In page load

for (int i = 0; i < CheckBoxList1.Items.Count; i++)
        {
            CheckBoxList1.Items[i].Selected = true;
        }

regards
Renju
0
 
LVL 12

Assisted Solution

by:renjurdevan
renjurdevan earned 100 total points
ID: 17896345
i mean loop thru reader and set "DataCheckedField"

CheckBoxList1.Items[i].Selected =   //convert to boolean and set salData("DataCheckedField")
0
 
LVL 4

Author Comment

by:glebn
ID: 17903718
Thanks for responding Renju, but I'm sorry your comments didn't answer my question. Your second comment was too vague and it didn't use VB. Telling me to loop through and set the box tells me nothing about how to do this most effectively. Again, thanks for responding.

I solved my own problem. My fundamental mistake was trying to use one datasource to build the list and set the values. Being an ASP.NET newbie I did this because I expected to be able to use the boolean "Selected" field to set the check box "checked" status which I now see that I can't. Instead, I used a datasource to populate the CheckboxList which included all possible rows ignoring the "Selected" field. I then created a different data source pulling only the rows for which selected was true. This second data source I used for the sqlReader in the code below to loop through the checkboxlist items during page load to check the appropriate items.

If sqlReader.HasRows Then
      Do While sqlReader.Read()
            For Each li As ListItem In Me.chkblCategories.Items
                  If li.Value = sqlReader("TagID") Then
                        li.Selected = True
                  End If
            Next
      Loop
Else
        ' If sqlReader doesn't have rows then no items should be selected.
      For Each li As ListItem In Me.chkblCategories.Items
            li.Selected = False
      Next
End If
sqlreader = Nothing

If anybody has suggestions for improving this or alternate approaches to the problem I would be glad to award the points.

0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 12

Accepted Solution

by:
sandip132 earned 400 total points
ID: 17904845
Do you mean by like this? :

If sqlReader.HasRows Then
    Do While sqlReader.Read()
      i=0
     While i < MyList.Items.Count
      Dim chklst As CheckBoxList = CType(MyList.Items(i).FindControl("CheckBoxList1"), CheckBoxList)
      quantity = Int32.Parse(quantityTxt.Text)
      If chklst .value = sqlReader("TagID") Then
        chklst .Checked = True Then
      End If
      i=i+1:
    End While
   Loop
End IF

0
 
LVL 4

Author Comment

by:glebn
ID: 17920010
Both work fine. I prefer the For-Next loop because it is easier to read--don't know which method would be faster but the number of checkboxes are so small that it doesn't matter.

P.S. My Else clause was written a little to late at night ;) -- as written it doesn't clear checkboxes properly in some cases. I fixed it by removing the Else clause entirely and putting the clear all checkboxes code before the initial If-Then.

Thanks for the comment.

0
 
LVL 4

Author Comment

by:glebn
ID: 17933945
I actually decided to use my solution posted above, but appreciate both responses which were correct solutions. I gave sandip132 most of the points because s/he gave a detailed solution with VB code.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question