Populating a ListView from an Access Database

[Patrick]

Am upgrading an application from VB6 to VB.Net. One of the controls is a ListView that am failing to populate. Am including some of the code for some assistance where I may be going wrong.

Private Sub ShowFielgs()
Dim f As ListViewItem
Dim i As Integer
Dim Names as String
Dim Arr6() As Object

With tbStaffm
Dim date1 As Date = Now
Dim date2 As Date = .Fields("BirthD ate").Value
Dim DateDifference As Integer = (DateDiff(DateI nterval.DayOfYe ar, date2, date1) \ 30 \ 12)

Names = ""
i = 0

If .RecordCount > 0 Then
ListView.Items. Clear()
.MoveFirst()

Do While Not .EOF

If StrComp(Trim(.F ields(StaffCode ).Value), Trim(cboStaffCo de.Text))=0 Then
f = ListView.Items( i)
ReDim Arr6(i)
Arr6(i) = .Bookmark

Names = .Fields("SurNam e").Value & " " & .Fields("FirstN ame").Value & " " & .Fields("OtherN ames").Value

f.Text = .Fields("Record Count").Value
f.SubItems(1) = Names

If IsDate(.Fields( "BirthDate").Va lue) Then
f.SubItems(5) = DateDifference
Else
f.SubItems(5) = ""
End If

i = i + 1
End If

When I try to run the application I get errors at:
(a) f.SubItems(1) = Names - "Value of type 'String' cannot be converted to 'System.Windows .Forms.ListView Item.ListViewSu bItem'"

(b) f.SubItems(5) = DateDifference - "Value of type 'Integer' cannot be converted to 'System.Windows .Forms.ListView Item.ListViewSu bItem'"

(c) f.SubItems(5) = "" - "Value of type 'String' cannot be converted to 'System.Windows .Forms.ListView Item.ListViewSu bItem'"

I need help because I ve tried to change to other variable values without success

Patrick

[sainin]

Patrick. The error messages are very clear. You are trying to compare a listview item (type is listviewitem) with other types (such as integer, string). .Net is a type-safe environment and wont let you compare different types.

So the way is to read the listview item's value. Convert the value to the type you want to compare (such as datetime, integer, string); use Convert(..., Int32) e.g. And then compare.You would like to catch any exceptions while converting the type.

Hope that helps.