Stored Procedure for Checkbox controls.

charan kumar

Hi Folks ,

I have once check box with value 'Fruit' and when I check that it populates various fruits under it with check boxes for each fruit so that I can choose any fruit from them.

Till here I have no challenges.

(100)Now the point is when I check on any fruit/fruits and click on save , the selected values should display in another page.

Eg: Fruit: (Parent Checkbox)

Apple

Mango

(105) Guava (These three are child checkboxes)

Could someone please help me to write a stored procedure for the lines (100-105). Your help could be my saviour .

Thanks in advance! (By the way , all the child checkbox values are populating from Fruit table.)

2 Replies

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

charan kumar4y ago
Thanks so much for the response , but I need to send the values including checkboxes to the other page , not just a value.
Sachin Singh4y ago
You just need to send the selected values to another page
Protected Sub btnSendToAnotherPage_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSaveSetProject.Click

    Dim ds_selectedFruits As New DataSet

    Dim dt = New DataTable()
    Dim dcName = New DataColumn("Name", GetType(String))
    dt.Columns.Add(dcName)

    Dim eStr As String = String.Empty
    Try
        For Each checkBox As CheckBox In chkbxlst_Fruits.Items
            If (checkBox.Checked = True) Then
                Dim dr As DataRow = dt.NewRow()
                dr("Name") = checkBox.Text
                dt.Rows.Add(dr)
            End If
        Next
        ds_selectedFruits.Tables.Add(dt)
Session["SelectedFruits"]=ds_selectedFruits
    Catch ex As Exception

    End Try
End Sub
On the next page use this DataSet
CheckBoxListNew.DataSource = (DataSet)Session["SelectedFruits"];
CheckBoxListNew.DataBind()