asked on
Private Sub frmPatientLookup_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
Me.PatientsTableAdapter.Fill(Me.PatientsDataSet.Patients)
For Each r In PatientsDataSet.Tables(2).Rows
lstPatients.Items.Add(r(2) & ", " & r(1))
Next
End Sub
r(2) is the Last Name, r(1) is the First Name. Private PatientList As List(Of Patients)
Private Sub frmPatientLookup_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
PatientList = New List(Of Patients)
Dim aPatient As Patients
Me.PatientsTableAdapter.Fill(Me.PatientsDataSet.Patients)
For Each r In PatientsDataSet.Tables(2).Rows
lstPatients.Items.Add(r(2) & ", " & r(1))
aPatient.Name = r(2) & ", " & r(1)
aPatient.ID = r(0)
aPatient.ExternalID = r(3)
PatientList.Add(aPatient)
Next
End Sub
There are (at least) three problems: