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