hi guys could you help me with this error..?
here where the error occurs...
If sqlconn.State <> ConnectionState.Closed Then sqlconn.Close()
query = "Select E.AppID as 'Applicant ID',E.FName as 'First Name',E.MName as 'Middle Name'," & _
" E.LName as 'Last Name' from tblEmpMaster as E" & _
" INNER JOIN tblLinks as L" & _
" ON E.AppID = L.fk_AppID" & _
" INNER JOIN tblRefInfo as I" & _
" ON L.RefID = I.RefID" & _
" where I.RefName = '" & cboRefCode.Text & "'"
.CommandText = query
sqlDR = .ExecuteReader
Do While sqlDR.Read
Item = Me.lvDetail.Items.Add(sqlDR!AppID.ToString)
Catch ex As Exception