ASP.NET

Inserting checkbox values into one field

Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: May 2009

Posts: 4

Reputation: ebosysindia is an unknown quantity at this point

Solved Threads: 0

ebosysindia ebosysindia is offline

Offline

Newbie Poster

Inserting checkbox values into one field

May 4th, 2009

hi

I have a checkboxes on my page (.aspx) like

checkbox1 - item1
checkbox2 - item2
checkbox3 - item3
etc

what i want is that when a user selects certain checkboxes
they should be inserted into a table called
customer which has fields (customer id and actions)

the data should be inserted as

customerid actions
1 item1,item2,item3
2 item1,item3
3 etc..

i.e all the values should be inserted into database into one field separated by commas.

Thanks

software application development | website development | java game development

•

Join Date: Aug 2007

Posts: 182

Reputation: Kusno is an unknown quantity at this point

Solved Threads: 15

Kusno

Offline

Junior Poster

Re: Inserting checkbox values into one field

May 7th, 2009

Hi ebosysindia,
Please use CheckBoxList control.

and to check which item is selected :

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
Dim V As String = ""
        Dim I As SByte
        For i = 0 To CheckBoxList1.Items.Count - 1
            If CheckBoxList1.Items(I).Selected = True Then
                If V = "" Then
                    V = CheckBoxList1.Items(I).Value
                Else
                    V = V & "," & CheckBoxList1.Items(I).Value
                End If
            End If
        Next
        TextBox1.Text = V
Dim V As String = ""
        Dim I As SByte
        For i = 0 To CheckBoxList1.Items.Count - 1
            If CheckBoxList1.Items(I).Selected = True Then
                If V = "" Then
                    V = CheckBoxList1.Items(I).Value
                Else
                    V = V & "," & CheckBoxList1.Items(I).Value
                End If
            End If
        Next
        TextBox1.Text = V

or if you want to insert the items into database

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
        Dim V As String = ""
        Dim I As SByte
        Dim SQL As String = ""
        Dim SQLList As New StringBuilder
 
        For i = 0 To CheckBoxList1.Items.Count - 1
            If CheckBoxList1.Items(I).Selected = True Then
                SQL = "INSERT INTO CUSTOMER VALUES('0001','" & CheckBoxList1.Items(I).Value & "')" & vbCrLf
                SQLList.Append(SQL)
            End If
        Next
        TextBox1.Text = SQLList.ToString
        Dim V As String = ""
        Dim I As SByte
        Dim SQL As String = ""
        Dim SQLList As New StringBuilder

        For i = 0 To CheckBoxList1.Items.Count - 1
            If CheckBoxList1.Items(I).Selected = True Then
                SQL = "INSERT INTO CUSTOMER VALUES('0001','" & CheckBoxList1.Items(I).Value & "')" & vbCrLf
                SQLList.Append(SQL)
            End If
        Next
        TextBox1.Text = SQLList.ToString

NEVER NEVER NEVER GIVE UP

•

Join Date: May 2009

Posts: 4

Reputation: ebosysindia is an unknown quantity at this point

Solved Threads: 0

ebosysindia ebosysindia is offline

Offline

Newbie Poster

Re: Inserting checkbox values into one field

May 7th, 2009

•

Originally Posted by Kusno

Hi ebosysindia,
Please use CheckBoxList control.

and to check which item is selected :
Help with Code Tags

ASP.NET Syntax (Toggle Plain Text)
Dim V As String = ""
        Dim I As SByte
        For i = 0 To CheckBoxList1.Items.Count - 1
            If CheckBoxList1.Items(I).Selected = True Then
                If V = "" Then
                    V = CheckBoxList1.Items(I).Value
                Else
                    V = V & "," & CheckBoxList1.Items(I).Value
                End If
            End If
        Next
        TextBox1.Text = V
Dim V As String = "" Dim I As SByte For i = 0 To CheckBoxList1.Items.Count - 1 If CheckBoxList1.Items(I).Selected = True Then If V = "" Then V = CheckBoxList1.Items(I).Value Else V = V & "," & CheckBoxList1.Items(I).Value End If End If Next TextBox1.Text = V
or if you want to insert the items into database
Help with Code Tags

ASP.NET Syntax (Toggle Plain Text)
        Dim V As String = ""
        Dim I As SByte
        Dim SQL As String = ""
        Dim SQLList As New StringBuilder
 
        For i = 0 To CheckBoxList1.Items.Count - 1
            If CheckBoxList1.Items(I).Selected = True Then
                SQL = "INSERT INTO CUSTOMER VALUES('0001','" & CheckBoxList1.Items(I).Value & "')" & vbCrLf
                SQLList.Append(SQL)
            End If
        Next
        TextBox1.Text = SQLList.ToString
Dim V As String = "" Dim I As SByte Dim SQL As String = "" Dim SQLList As New StringBuilder For i = 0 To CheckBoxList1.Items.Count - 1 If CheckBoxList1.Items(I).Selected = True Then SQL = "INSERT INTO CUSTOMER VALUES('0001','" & CheckBoxList1.Items(I).Value & "')" & vbCrLf SQLList.Append(SQL) End If Next TextBox1.Text = SQLList.ToString