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

Question

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

Bhim Kunwar · Answer

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 papaioannou · Answer

I use Access 2003... if i want to add to the db more than one fields what't happens??

Manish Dwivedi · Answer

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!!