请教：日期查找问题

Question

请教：日期查找问题在C#中，设置分别设置DateTimePicker1,DateTimePicker2, TextBox1 ,TextBox2
adapter = new SqlDataAdapter(@"SELECT GOODSID ，CODE FROM MRP_VIEW_VARIABLESUM_GOODS('2009-01-01','2009-09-09' )", conn);
请问有什么办法在查询语句时('2009-01-01','2009-09-09')取变量DateTimePicker1,DateTimePicker2的日期进行.

Answer 1

DateTimePicker1.value.parseTostring("yyyy-MM-dd")

Answer 2

DateTimePicker1.value.Tostring("yyyy-MM-dd")

Answer 3

最简单的方法就是字符串相加...不过安全嘛...保险一点还是用SqlCommand.Parameters传递参数好

Answer 4

DateTimePicker1.value.ToString("yyyy-MM-dd");

Answer 5

DateTimePicker 的Format 属性设置成： Short
然后：
string strSQL = string.Format("SELECT GOODSID ，CODE FROM MRP_VIEW_VARIABLESUM_GOODS('{0}','{1}'", DateTimePicker1.Text, DateTimePicker2.Text);

Answer 6

还有个问题想请教各位：
adapter = new SqlDataAdapter(@"SELECT sum(QTY) FROM MRP_VIEW_VARIABLESUM_GOODS('2009-01-01','2009-09-09' )", conn); 如何把SUM(QTY)的值赋给TextBox显示，是不是
adapter = new SqlDataAdapter(@"SELECT TextBox.Text=sum(QTY) FROM MRP_VIEW_VARIABLESUM_GOODS('2009-01-01','2009-09-09' )", conn); 

Answer 7

DataTable dt = new DataTable();
adapter.Fill(dt);
if(dt!=null){
TextBox.Text=dt.rows[0][0].toString();
}

Answer 8

运行
adapter = new SqlDataAdapter(@"SELECT sum(QTY) FROM MRP_VIEW_VARIABLESUM_GOODS(DateTimePicker1.value.Tostring(yyyy-MM-dd)','DateTimePicker1.value.Tostring(yyyy-MM-dd)' )", conn); 提示出错，从字符串转换为 datetime 时发生语法错误