asp.net C#时间段查询问题，如何获取时间
代码如下
string sqlstr = "select * from eNewView";
string time1 = this.time1.Text.Trim();
string time2 = this.time2.Text.Trim();
if (time1 != "" && time2 != "")
{
if (wherestr.Trim() == "")
{
wherestr = "shijian >= '" + time1.Text.Trim() + "' AND shijian <= '" + time2.Text.Trim() + "'";
}
else
{
wherestr = wherestr + " AND shijian >= '" + time1.Text.Trim() + "' AND shijian <= '" + time2.Text.Trim() + "'";
}
}
主要是这部分代码，如何获取正确时间数据
'" + time1.Text.Trim() + "'
------解决方案--------------------
if (this.time1.Text.Trim() != "" && this.time2.Text.Trim() != "")
{
if (wherestr.Trim() == "")
{
wherestr = "shijian >= '" + time1.Text.Trim() + "' AND shijian <= '" + time2.Text.Trim() + "'";
}
else
{
wherestr = wherestr + " AND shijian >= '" + time1.Text.Trim() + "' AND shijian <= '" + time2.Text.Trim() + "'";
}
}