Loading Values into a Grid
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]"
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