list view is empty. i have used the following code. why? please help
VB.NET:
Public Sub populate_SubjectsDepartmentsLvw()
SubjectsDepartmentsLvw.Items.Clear()
ds.Clear()
Dim cmds As New SqlCommand(" select subject_name, department_name" _
& " from Departments_Subjects_junction" _
& "join Subjects on Subjects.subject_id = Departments_Subjects_junction.subject_id" _
& "join Departments on Departments.department_id= Departments_Subjects_junction.department_id", con)
con.Open()
Using dr As SqlDataReader = cmds.ExecuteReader
While dr.Read
Dim li As New ListViewItem
li.Text = Convert.ToString(dr.Item("subject_name"))
li.SubItems.Add(Convert.ToString(dr.Item("department_name")))
SubjectsDepartmentsLvw.Items.Add(li)
End While
End Using
con.Close()
End Sub