Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET SQL
Hello Everyone..
 
How to maintain time sheet of employees based on From date to till date in a GridView.
 

Any help..
Posted 23-Jan-13 20:17pm
maye12358
Comments
AshishChaudha at 24-Jan-13 2:24am
   
what you have tried so far??

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

"Select * from DataTable WHERE ((FirstDate >='" + first date time+ "') AND (LastDate<= '" + last date time+ "'))"
 
Try to use this select command for the adapter to the dataset...
after that you will get all rows which is lies between these dates...
 
Best Regards
Hemant Tyagi
+91-9045263253
Write on : Hemantt84@hotmail.com
  Permalink  
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Zoltán Zörgő 220
1 Peter Leow 160
2 CPallini 120
3 Sergey Alexandrovich Kryukov 95
4 BillWoodruff 85
0 Sergey Alexandrovich Kryukov 9,428
1 OriginalGriff 6,901
2 Peter Leow 4,737
3 Zoltán Zörgő 4,349
4 CHill60 2,932


Advertise | Privacy | Mobile
Web02 | 2.8.150129.1 | Last Updated 24 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100