Loading data from mysql to CheckBoxList Vb.net

Question

I'm in a Vb.Net application coding and really a newbie here, I just finished creating my first MySQL connexion to a remote server ..

Anyway, What I'm asking about here is how to gather data from a table and load it into a CheckBoxList, so that user can have a list of items from the table, and he checks the ones he need, that I will later.

Thank you all the community here :)

What platform? Winforms, WPF, Silverlight, ASPX, other? Are you familiar with sql statements? — OneFineDay
– OneFineDay, Commented Jun 30, 2013 at 3:16
Thanks youfor asking a basic level question. At times people forget that we are not all experts and some basic help is needed. I had the same question and was frustrated with the hyper advanced answers. — Aggie Jon of 87
– Aggie Jon of 87, Commented Jan 13, 2022 at 19:15

Trevor · Accepted Answer · 2013-06-30 05:08:03Z

1

You first need to get the data that you need into a table. Then loop through that table and add it to your CheckedListBox.

Here's a short example:

 Dim dtPersons As DataTable
 dtPersons = GetPersons()

 For Each dRow As DataRow In dtPersons.Rows
   CheckedListBox1.Items.Add(dRow.Item("LastName"))
 Next

This will loop through a datatable and add an item to the checkedlistbox each time with last name.

GoodLuck!

answered Jun 30, 2013 at 5:08

Trevor

8,0156 gold badges35 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Chaibi Alaa Over a year ago

The function GetPersons is .. ?

Trevor Over a year ago

That was added to get you started; this function would pull your data in. It can be whatever you want it to be; you already make a connection from what you state. So all you need to do is perform a query to get what you need in a function that returns a data table.

Chaibi Alaa Over a year ago

Is there any ability to load values for each item ? (Value, Item)

Trevor Over a year ago

No it's either checked or not; the checked listbox items are already what you want because you are already displaying them. For example: red apples and green apples are per say in your listbox. You only want the red apples so you just check them. Well know you have your item "red apples".

Trevor Over a year ago

You can also loop through the checked listbox for example: For Each i As Object In CheckedListBox1.CheckedItems TextBox1.Text += i.ToString() Next

Collectives™ on Stack Overflow

Loading data from mysql to CheckBoxList Vb.net

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related