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