how to select datqetween two date from db

Hello Dear programmers,
I want fatching news uploaded in news_manage table from sql server and this table have id-autoincr,news,start_date,end_date,title.so i want to select data between start date and end date with compare to datetime.now object,and 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