Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Loading Values into a Grid

Hi All,

i am taking a employee id from ohem and populating it in my query to get the entire information.when i am populating i am getting only on employee id.how to get all the employee id's information at a time

my code is as follows

strQuery = "SELECT empid FROM [OHEM]"

objRecordSet.DoQuery(strQuery)

If objRecordSet.RecordCount > 0 Then

For inti As Integer = 0 To objRecordSet.RecordCount - 1

strEmployeeNo = objRecordSet.Fields.Item(0).Value

strGridQuery = "SELECT pf,basic,deductions etc where empid=''stremployeeno"

objRecordSet.MoveNext()

Next

here i am getting the information of only first employee

i am having a list of 12 employees

how to get all the employees

i wrote the query also as

strGridQuery += "SELECT pf,basic,deductions etc where empid=''stremployeeno"

regards

Micheal

Edited by: Micheal Vasanth on Sep 4, 2008 1:03 PM

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question