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