查询两个日期之间的记录搜索 [英] query for searching records between two dates

问题描述

hi ....... im试图搜索两个日期之间的记录，并希望在数据网格视图中显示它们，请plzzzzzzzzzz帮助我并告诉我查询.....

hi.......i m trying to searching records between two dates and want to showing them in data grid view plzzzzzzzzzz help me and tell me the query..........

推荐答案

哪个数据库?
如果使用的是SQL Server，则只需SELECT * FROM myTable WHERE myDate >= ''2001-01-01'' AND myDate < ''2002-0-01''.

更多此处 [

Which database?
If its SQL Server, its as simple as SELECT * FROM myTable WHERE myDate >= ''2001-01-01'' AND myDate < ''2002-0-01''.

More here[^].

嗯.因此，您想知道如何在之间找到所有值 [

Hmmm. So you want to know how to find all values between[^]two dates...

There must be an easy way to do it.

如果需要C#，请尝试此操作

Try this if you need in C#

DateTime dateToCompare = //Any Date;<br />
List < Employee > lstEmployees = //List of all Employees<br />
List<Employee> filteredEmployees = lstEmployees.ToList().FindAll(<br />
          delegate(Employee employee)<br />
              {<br />
                if (employee.DateOfJoin >= dateToCompare && employee.DateOfJoin < dateToCompare)<br />
                    return true;<br />
                else<br />
                    return false;<br />
              });

干杯，

Anand

Cheers,

Anand

这篇关于查询两个日期之间的记录搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！