ASP.NET字符串转化为日期时间格式
前台:
<p>
<span>预约日期:</span>
<asp:DropDownList ID="YearList" runat="server"
onselectedindexchanged="YearList_SelectedIndexChanged" Width="60px">
</asp:DropDownList>年
<asp:DropDownList ID="MonthList" runat="server"
onselectedindexchanged="MonthList_SelectedIndexChanged">
</asp:DropDownList>月
<asp:DropDownList ID="DayList" runat="server" Width="40px">
</asp:DropDownList>日
<b>*</b>
</p>
后台:
//字符串语句
string arrivetime = this.YearList.Text + "-" + this.MonthList.Text + "-" + this.DayList.Text + " " + this.HourList.Text + ":" + this.MinList.Text+":00";
//插入数据库
string sql = "insert into tb_OnlineSeat(OrderRoomName,OrderNum,OrderRoomTel,ArriveTime,CustomerID) values('" + ordername + "','" + ordernum + "','" + tel + "','" +Convert.ToDateTime(arrivetime)+ "','" + this.Session["username"] + "')";
报错:
该字符串未被识别为有效的 DateTime。
这是为什么啊??