A Good book to learn C# libraries

Question

Hi

 

I'm comming as a C++ programmer. I know how to handle quite a bit of Win API with C++. But when it comes to C#, it's plathora of libraries are making me confused. The things I did with with Win API with C++, eludes me when I try to do them with C#. So, I need a better grip of C#.net libraries that interacts with Win API. Can you recommend a good book that shows you how to handle the Win API with C#? I'm looking for a book like the good old classic "Windows 2000 API & COM+ Programming" by Ben Forta.

 

Thanks.

Answer 1

select empid,

(select min(attandancedate) from tbl_test where empid=a1.empid and (cast(attandancedate as time) between '08:00:00' and '09:59:59')) as intime,

(select max(attandancedate) from tbl_test where empid=a1.empid and (cast(attandancedate as time) >= '17:00:00')) as outtime

from tbl_test a1 group by a1.empid

 

 

But This Query Gives Null For Emp1 As Outtime Because He Does Not Punched After 5 PM

 

For Ideal Case We Can Remove Time from second query because we can get last punch of any employee using max, that can be use as outtime

 

Please Tell If This Is Usefull. 

 

 

 

Answer 2

select empid, min(attendencedate) as inTime, max(attendencedate) as outTime

from temp

group by empid;