Click here to Skip to main content
15,884,011 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
This is my code behind


VB
Private Sub BindCheckBoxListIssue()

        Dim dt As New DataTable()
        Dim dbconn As New SqlConnection(strCon)
        Try
            dbconn.Open()
            Dim strSql As String = "SELECT * FROM MonitorIssue"
            Dim dbcomm As New SqlCommand(strSql, dbconn)
            Dim SqlDa As New SqlDataAdapter(dbcomm)

            SqlDa.Fill(dt)
            If (dt.Rows.Count > 0) Then
                chklstIsu.DataSource = dt
                chklstIsu.DataTextField = "Issue"
                chklstIsu.DataValueField = "Issue"
                chklstIsu.DataBind()
            End If

            For i As Integer = 0 To 15
                dt.Rows(i)("IsSelected").ToString()
                chklstIsu.Items(i).Selected = Convert.ToBoolean(dt.Rows(i)("IsSelected"))
            Next

            dbconn.Close()

            setMsg(Me, "Record saved", "strKey")
        Catch
            setMsg(Me, "Record save failed", "strKey")
        End Try
    End Sub

    Private Sub UpdateIssue()
        Dim conn As New SqlConnection()
        Dim cmd As New SqlCommand
        Dim strSql = ""

        Try
            cmd.Connection = conn
            conn.Open()

            strSql = "UPDATE MonitorIssue SET IsSelected = @IsSelected WHERE Issue = @Isu"
            For Each item As ListItem In chklstIsu.Items
                cmd.Parameters.Clear()
                cmd.Parameters.AddWithValue("@IsSelected", item.Selected)
                cmd.Parameters.AddWithValue("@ListingId", item.Value)
                cmd.ExecuteNonQuery()
            Next

            conn.Close()

            setMsg(Me, "Record saved", "strKey")
        Catch
            setMsg(Me, "Record save failed", "strKey")
        End Try
    End Sub
Posted

1 solution

Try this

VB
Private Sub UpdateIssue()
        Dim conn As New SqlConnection()
        Dim strSql = ""
 
        Try
            conn.Open()
 
            strSql = "UPDATE MonitorIssue SET IsSelected = @IsSelected WHERE Issue = @Isu"
            Dim cmd As New SqlCommand(strSql, conn)
            For Each item As ListItem In chklstIsu.Items
                cmd.Parameters.Clear()
                cmd.Parameters.AddWithValue("@IsSelected", item.Selected)
                cmd.Parameters.AddWithValue("@ListingId", item.Value)
                cmd.ExecuteNonQuery()
            Next
 
            conn.Close()
 
            setMsg(Me, "Record saved", "strKey")
        Catch
            setMsg(Me, "Record save failed", "strKey")
        End Try
    End Sub


Hope it helps.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900