数据库问题 请高手指点。

[maliang13567]

String connStr = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{

cmd.CommandText = string.Format("select * from T_Data where time between #{0}# and #{1}#",dateTimePicker1.Value,dateTimePicker2.Value);
using (SqlDataReader Reader = cmd.ExecuteReader())
{
if (Reader.HasRows)
{
while (Reader.Read())
{
楼层号 = Convert.ToString(Reader["楼层号"]);
节点组号 = Convert.ToString(Reader["节点组号"]);
节点号 = Convert.ToString(Reader["节点号"]);
设备号 = Convert.ToString(Reader["设备号"]);
电池电压 = Convert.ToString(Reader["电池电压"]);
光源状态 = Convert.ToString(Reader["光源状态"]);
电池状态 = Convert.ToString(Reader["电池状态"]);
市电电压 = Convert.ToString(Reader["市电电压"]);
报警 = Convert.ToString(Reader["报警"]);
时间 = Convert.ToString(Reader["time"]);
sw.WriteLine(楼层号 + "," + 节点组号 + "," + 节点号 + "," + 设备号 + "," + 电池电压 + "," + 光源状态 + "," + 电池状态 + "," + 市电电压 + "," + 报警 + "," + 时间);

}

}
Reader.Close();
Reader.Dispose();
}
这是我自己编的一段吧数据导出数据库的程序 但是 cmd.CommandText = string.Format("select * from T_Data where time between #{0}# and #{1}#",dateTimePicker1.Value,dateTimePicker2.Value);这个句子好型有问题，请高手指点。。谢谢

[bearfly2011]

#{0}# and #{1}#
应该是'{0}' and '{1}'吧

[暖枫无敌]

恩？ #是干嘛的？是前后都有这样的字符嘛？

[暖枫无敌]

cmd.CommandText = string.Format("select * from T_Data where time between {0} and {1}",dateTimePicker1.Value,dateTimePicker2.Value);

[Tragedy]

把你的sql字段名为time的换了 time好像有问题吧

[TimZhuFaith]

[time] between {0} and {1}

[肖恩]

[Quote=引用 3 楼 taomanman 的回复:]
C# code


cmd.CommandText = string.Format("select * from T_Data where time between {0} and {1}",dateTimePicker1.Value,dateTimePicker2.Value);
[/Quote]
up

[lml3546]

[Quote=引用 5 楼 timzhufaith 的回复:]

[time] between {0} and {1}
[/Quote]time是关键字吧

[sdl2005lyx]

"cmd.CommandText = string.Format("select * from T_Data where time between #{0}# and #{1}#",dateTimePicker1.Value,dateTimePicker2.Value);这个句子好型有问题"

LZ,你断点调试到那个地方，看看字符串到底是什么，也许你一下就能看到问题了！
如果还是看不处理，你把字符串拷贝出来，放到SQL SERVER的查询分析器执行一下，就能找到问题！

[zxh198841]

楼上正解