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 to get all the employee id's information at a time

my code is as follows

strQuery = "SELECT empid FROM [OHEM]"


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"



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"



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

Helpful Answer

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