hot来根据两个datetimepicker过滤datagridview [英] hot to filter datagridview according two datetimepicker
问题描述
我的SQL数据库表列是:
date varchar(50)
在日期列中以下列格式插入值:
dtpdate .Value.ToString(dd / MMM / yyyy)
现在另一种形式我有两个datetimepickeer和一个datagridview.1st dtp由用户从日期和第二个到日期设置,datagridview显示记录按照上面的日期
i使用下面的代码来做这个,但只有当我输入两个dtp的相同日期才显示值,请帮忙吗?
da = new SqlDataAdapter(select *从预订日期''+ dateTimePicker1.Value.ToString(dd / MMM / yyyy)+'和'+ dateTimePicker2.Value.ToString(dd / MMM / yyyy)+',con) ;
ds = new DataSet();
da.Fill(ds,Booking);
dataGridView1.DataSource = ds.Tables [0];
不要将日期保存为字符串,首先将列更改为数据库中的日期类型或日期时间
然后在数据库中保存dtpdate.Value.Date
。
加载数据时,使用参数并设置如下参数值
da = new SqlDataAdapter( select *从预订到@ date1和@ date2之间的日期);
da.SelectCommand.Parameters.AddWithValue( @ date1,dateTimePicker1.Value.Date );
da.SelectCommand.Parameters.AddWithValue( @ date2,dateTimePicker2.Value.Date );
my SQL database table column is:
date varchar(50)
while inserting value in date column in below format:
dtpdate.Value.ToString("dd/MMM/yyyy")
now another form i have two datetimepickeer and a datagridview.1st dtp set by user from date and 2nd to date and datagridview show the record as per above date
i have using below code for do that but is show value only if i entered same date of both dtp , please help ?
da = new SqlDataAdapter("select * from Booking where date between '" + dateTimePicker1.Value.ToString("dd/MMM/yyyy") + "' and '" + dateTimePicker2.Value.ToString("dd/MMM/yyyy") + "'", con);
ds = new DataSet();
da.Fill(ds, "Booking");
dataGridView1.DataSource = ds.Tables[0];
Don't save date as string, first change the column to a Date type or DateTime in your database
Then savedtpdate.Value.Date
in the database.
when you load data, use parameters and set the parameter values as below
da = new SqlDataAdapter("select * from Booking where date between @date1 and @date2"); da.SelectCommand.Parameters.AddWithValue("@date1",dateTimePicker1.Value.Date); da.SelectCommand.Parameters.AddWithValue("@date2",dateTimePicker2.Value.Date);
这篇关于hot来根据两个datetimepicker过滤datagridview的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!