Wednesday 18 January 2012

How to Insert and Retreive Checkbox List Item in Database


'How to Insert

Dim Selectval As String = ""
Dim I As Integer

For I = 0 To ChkListCallOrder.Items.Count - 1
      If ChkListCallOrder.Items(I).Selected = True Then
Selectval = Selectval + ChkListCallOrder.Items(I).Value & "#"
      End If
      Next

'Note:- Pass the parameter in you Query or Stored Procedure

cmd.Parameters.AddWithValue("@Call_Order", Selectval)

'How To Reterive and Bind
ChkListCallOrder.ClearSelection()If Not IsDBNull(ds.Tables("ClientTable").Rows(0).Item("Call_Order")) Then
chkboxlst = Split(ds.Tables(
Dim chkboxlst As Array"ClientTable").Rows(0).Item("Call_Order"), "#")Dim I As IntegerIf chkboxlst.Length > 0 Then
ChkListCallOrder.Items.FindByValue(chkboxlst(I)).Selected =
For I = 0 To chkboxlst.Length - 2TrueNextEnd IfEnd If


No comments:

Post a Comment