string sql = ""; OleDbConnection conn = new OleDbConnection(oldbconnstring); sql = "select AttendanceLogs.InTime,AttendanceLogs.OutTime,Employees.EmployeeCode FROM AttendanceLogs INNER JOIN Employees ON AttendanceLogs.EmployeeId = Employee.EmployeeId"; OleDbCommand cmd = new OleDbCommand(sql, conn); conn.Open(); OleDbDataAdapter adapter = new OleDbDataAdapter(cmd); adapter.Fill(results);
select AL.InTime,AL.OutTime,E.EmployeeCode FROM AttendanceLogs AL INNER JOIN Employees E ON AL.EmployeeId = E.EmployeeId
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)