Hi All,

I am trying to upgrade my existing vb6 project to vb2005.
In vb6 i was using


strQuery = "select * from tblemployee order by emp_name"
Set rstRecord = gObjConn.Execute(strQuery)

While Not rstRecord.EOF

lstLookup.AddItem rstRecord("emp_name")
lstLookup.ItemData(lstLookup.NewIndex) = rstRecord("emp_id")
rstRecord.MoveNext
Wend

How can i do the same using vb2005


Thnks