在grideview中搜索日期 [英] search in grideview for date

问题描述

我必须搜索数据 - > date_from TO date_to。

Ex：

我必须显示数据列表

enquery从日期开始：2012年1月1日至10/1/2012

此日期值在文本框中。



我使用此查询，但无法正常工作：

i have to search data -> date_from TO date_to.
Ex:
I have to show list of data where
enquery made from date:1/1/2012 to 10/1/2012
this date value are in textbox.

I have use this query,but can''t working:

select *from call_details where enquiry_date=''" + txt_datefrom.Text + "'' to ''" + txt_dateto.Text + "''"

推荐答案

Use Query like:
 "Select * from call_details where enquiry_date between ''" + txtStartDate.txt + "'' and ''" + txtEndDate.text + "''";

使用此查询

Use this query

select * from table_name where date_column_name between from_date and To_date

试试这个

try this

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

但这会导致sql注入。所以使用sql参数总是



它应该是

But this will lead to sql injection.so use sql parameters always

it should be

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)));

这篇关于在grideview中搜索日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！