dateTimePicker控件的问题...

来源：百度知道 编辑：UC知道 时间：2024/05/31 17:33:26
如何将dateTimePicker控件选到的值赋予一个变量？？还有我的这个sql语句为什么查5到东西？（Date类型是datetime） select c.Member_Name,c.Member_Id,b.Unit_Money,b.Pic,a.Date from Sell as a, Deal as b, Member as c where a.Date between 2009-1-1 and 2009-10-1 and a.Sell_Id=b.Sell_Id and a.Member_Id=c.Member_Id;

日期是常量，要引起来
a.Date between '2009-1-1' and '2009-10-1'

DateTimePicker dtp = new DateTimePicker();
string datetime = dtp.Text;

或者用Value属性，DateTimePicker的Value属性是DateTime类型，当成DateTime来用就行了
DateTime dt = dtp.Value;
。。。

将dateTimePicker控件选到的值赋予一个变量:
DateTime dt = dateTimePicker.Value;

至于你的SQL语句，楼上都说对了

日期要加单引号

'2009-1-1 '