how to select datqetween two date from db

Question

Hello Dear programmers I want fatching news uploaded in news_manage table from sql server and this table have id-autoincrnewsstart_dateend_datetitle.so i want to select data between start date and end date with compare to datetime.now objectand also the start date and end date data type is datetime.so how it posible please give an idea to fetch data in asp.net repeter or gridview control. Thanks for reply

Khargesh Rajput · Answer

select news from news_manage where start date>@startdate and enddate

Dipankar Biswas · Answer

hi flw this project to help... http://www.codeproject.com/Articles/168662/Time-Period-Library-for-NET