抛出异常String未被识别为有效的DateTime。压延机扩展器 [英] Throws exception String was not recognized as a valid DateTime. Calender extender

问题描述

我在TextBox上使用calenderExtender选择日期并将其存储在文本框中但问题是当我想在保存按钮中存储此选定日期时单击它会抛出异常

在SQL字段中，我还提到StockDate日期时间。在保存按钮单击事件我写代码：

Hi,
I am using calenderExtender on TextBox which pick the date and store it in text box but problem is when i want to store this selected date in Save button click it throws exception
In SQL field i also mention StockDate datetime. On Save button click event i write code:

objBusinessUI.StockDate = Convert.ToDateTime(txtStockDate.Text);

我也尝试

and i also try

objBusinessUI.StockDate = Convert.ToDateTime(txtStockDate_CalendarExtender.SelectedDate);

但它不起作用

在DAL文件中

but it not works
In DAL file

SqlParameter StockDate = new SqlParameter("@StockDate", objStock.StockDate);
                   StockDate.Direction = System.Data.ParameterDirection.Input;
                   StockDate.DbType = System.Data.DbType.DateTime;
                   sqlParams[2] = StockDate;

所以请帮助我

Thnx提前

so please help me
Thnx in advance

推荐答案

我认为你的开发机器和sql server机器日期时间之间的日期格式不匹配。查看您的计算机区域设置以查看系统日期时间格式。



也可以使用;

I think it is mismatch between the date formats between your dev machine and the sql server machine datetime. Have a look on your computer Regional settings to see your system date time format.

Also use ;

DateTime dt = DateTime.ParseExact(TextBox.Text, "dd/MM/yyyy", 
                                  CultureInfo.InvariantCulture);

祝你好运，

OI

Good luck,
OI

txtStockDate_CalendarExtender.SelectedDate可能会返回无效的日期时间字符串格式，因为Convert.ToDateTime采用格式为mm / dd / yyyy的字符串。



试试这个。

Hi,

txtStockDate_CalendarExtender.SelectedDate might be returning an invalid string format of date time as Convert.ToDateTime takes the string of form mm/dd/yyyy.

Try this.

Hi Professional



有一些链接可以帮助你更好... ....



http://stackoverflow.com/questions/10570152/string-was-not-recognized-as-a-valid-datetime [ ^ ]



http://forums.asp.net/t/1196663.aspx [ ^ ]



http://stackoverflow.com/questions/10570152/string-被认为是有效的日期时间 [ ^ ]



乐于助人

Hi Professional

there is some link that help you better.......

http://stackoverflow.com/questions/10570152/string-was-not-recognized-as-a-valid-datetime[^]

http://forums.asp.net/t/1196663.aspx[^]

http://stackoverflow.com/questions/10570152/string-was-not-recognized-as-a-valid-datetime[^]

Happy to Help

这篇关于抛出异常String未被识别为有效的DateTime。压延机扩展器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！