编程论坛 → ASP.NET技术论坛

[求助]DateTime

cyyu_ryh 发布于 2007-06-29 11:10， 706 次点击

我用了两个日期控件,作为查询的条件
我用的是组合查询,
DateTime Begin = DateTime.Parse("1900-1-1");
DateTime end = DateTime.Parse("1900-1-1");
if (clb_Begin.Text.Trim().ToString() != null)
{
Begin = DateTime.Parse(clb_Begin.Text.Trim().ToString());
}
if (clb_End.Text.Trim().ToString() != null)
{
end = DateTime.Parse(clb_End.Text.Trim().ToString());
}
我这样写这行代码始终要抱错,当我不选择日期时
Begin = DateTime.Parse(clb_Begin.Text.Trim().ToString());
错误:
String was not recognized as a valid DateTime.
请问当不选择时该怎么判断

4 回复

#2

川流不息2007-06-29 11:32

if (clb_Begin.Text.Trim().ToString() != null)

你不選時這裡能通過嗎？

#3

cyyu_ryh2007-06-29 12:28

一运行 Begin = DateTime.Parse(clb_Begin.Text.Trim().ToString());
这句话几报错

#4

bygg2007-06-29 12:35

string sqlstr = "......... where 1=1"
if( clb_Begin.Text.Trim() != "" )
{
sqlstr += " beginDate>='" + clb_Begin.Text.Trim() + "'"
}

if( clb_Begin.Text.Trim() != "" )
{
sqlstr += " endDate<='" + clb_Begin.Text.Trim() + "'"
}

不用转换

#5

cyyu_ryh2007-06-29 12:58

还是不可以，查询不出

if (clb_Begin.Text.Trim() != "" && clb_Begin.Text.Trim() != "")
{
Select += " Birthday between '" + clb_Begin.Text.Trim() + "' and '" + clb_End.Text.Trim() + "'";
}

1