Monday, April 23, 2012


How to update database using listview in vb.net

For y = 0 To ListView1.Items.Count - 1
    If (objcon.con.State = ConnectionState.Closed) Then 
        objcon.con.Open()
        cmd1 = New OleDbCommand("UPDATE Customers SET " & _
                                "fup = #" & ListView1.Items(y).SubItems(5).Text & "#" & _
                                "WHERE policy_no = '" & ListView1.Items(y).SubItems(1).Text & "'", objcon.con)
         cmd1.ExecuteNonQuery()
        objcon.con.Close()
    End If
Next

No comments:

Post a Comment