search in grideview for date

select * from table_name where date_column_name between from_date and To_date

"select * from call_Details 
where enquirydate between '"+DateTime.Parse( txt_datefrom.Text) + "' and '"
+DateTime.Parse( txt_dateto.Text) +"'";

SqlCommand command = new SqlCommand("select * from call_Details
where enquirydate between @startdate and @enddate", connection))  ;    
command.Parameters.Add(new SqlParameter("@startdate" , DateTime.Parse(text_datefrom.Text)));
command.Parameters.Add(new SqlParameter("@enddate" , DateTime.Parse(text_dateto.Text)));