Helping for retrieving values from CHECKEDBOXLIST code

Question

0.00/5 (No votes)

See more:

This's code for storing the indexes of values in CHECKEDBOXLIST :

VB

Dim checkedItemsList As Integer() = New Integer(CheckedListBox1.CheckedIndices.Count - 1) {}
        Dim sb As New StringBuilder()
        For i As Integer = 0 To CheckedListBox1.CheckedIndices.Count - 1
            checkedItemsList(i) = CheckedListBox1.CheckedIndices(i)
            sb.Append(checkedItemsList(i))
            sb.Append(";")
        Next
        CheckedListBox1.Tag = sb


        Dim cmd As New SqlCommand("Insert into tb values('" & sb.ToString() & "')", connDB)
        Dim iCount As Integer = cmd.ExecuteNonQuery()
        connDB.Close()

it's save the values of CHECKEDBOXLIST in one column as:

0;1;2;3;

the problem in retrieving code doesn't run correctly :

VB

Dim intersts As String = ""
       Dim cmd As New SqlCommand("Select Interests from tb", connDB)

       Dim dr As SqlDataReader
       dr = cmd.ExecuteReader()
       If dr.Read() Then
           intersts = dr("Interests").ToString()
       End If
       connDB.Close()



       For Each i As ListItem In CheckedListBox1.Items
           For Each s As String In intersts.Split(";"c)
               If i.Value = s Then
                   i.Selected = True
                   Exit For
               End If
           Next
       Next

the compiler show me error message : "Type 'ListItem' is not defined."

anyone has a code for retrieving the values from the column and display them

Posted 22-Mar-15 5:21am

Member 428769

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Thava Rajan · Answer 1 · 2015-03-24T18:30:00

Solution 2

seems you are doing something wrong there

at first you are pick the index in the later you are using the wrong approach

you need to use the same approach as you get the index

loop through the selected index and use this method setItemChecked [^] to check the items in the checkedlistbox

Posted 24-Mar-15 18:30pm

Thava Rajan

Jaroslav Mitrovic · Answer 2 · 2015-03-24T16:35:00

Hi.

Try ListBoxItem instead of ListItem.

And then take care of the new Properties of the i-Variable...

And if you do alot of Splitstring-Operations use a .Trim to be shure the String can Split without errors...

VB

For Each i As ListBoxItem In CheckedListBox1.Items
           For Each s As String In intersts.Split(";"c)
               If i.Value = s.Trim Then
                   i.Selected = True 
                   Exit For
               End If
           Next
Next

A can´t Test it now, so I don´t memorize if i.Value and i.Selected can be used.

Maybe i.IsSelected ??? but I think the IDE will help You with that...

c.u. and Happy Coding

Joshi