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 19: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 Sergey Alexandrovich Kryukov 756
1 OriginalGriff 345
2 Magic Wonder 131
3 Kishore Pogaru 130
4 Fredrik Bornander 130
0 OriginalGriff 5,705
1 Sergey Alexandrovich Kryukov 4,763
2 CPallini 4,570
3 George Jonsson 3,142
4 Gihan Liyanage 2,450


Advertise | Privacy | Mobile
Web01 | 2.8.140916.1 | Last Updated 24 Jan 2013
Copyright © CodeProject, 1999-2014
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