Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

All contents are copyright of their authors.

[PROBLEM]How to add data from a Checked Listbox to a Database.

Home
Forums
Visual Basic .NET

[PROBLEM]How to add data from a Checked Listbox to a Database.

Alex papaioannou

18yAsked Mar 9, 2008, 5:58 AM4kVisual Basic .NET

Hi i have an application with some controls and a checked listbox filled with "products". What I need is how can I add the selected "products" in my db using VB.NET...

Thanks in advance for helping me

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Bhim Kunwar18y ago

i hope this code may help u to a great extent

Dim Sno As New StringBuilder

Dim drow As DataRowView

Dim ListOfsno As New ArrayList

For Each drow In chkLBVoucher.CheckedItems

Sno.Append(drow(0))

Sno.Append(",")

ListOfsno.Add(drow(0))

Next

If Sno.Length > 0 Then

Sno.Remove(Sno.Length - 1, 1)

End If

best regards
Alex papaioannou18y ago
I use Access 2003... if i want to add to the db more than one fields, what't happens??

Blocked Account18y ago

Hi Friend,
         By using this code you can take the selected value in a 
sigle variable. Now storing in the database depend on the database
structure u are using. 

Dim strselecteditems As String= ""
For i As Integer = 0 To ListBox1.Items.Count - 1
    If ListBox1.Items(i).Selected Then
    strselecteditems  = strselecteditems  + ListBox1.Items(i).Text
              
    End If
Next

Happy Coding!!