通过网页时日期时间错误 [英] Error in Datetime while passing through web Page

问题描述

朋友们，
我在日期中出现了一个错误，该错误已在我的网页中以PO Date的形式显示. 在存储过程中，我已经使用了(@POdate作为Datetime).
在代码中，我曾经这样使用过:

Hi friends,
i am getting an error in date which i have taken in my Web page as PO Date.
in stored procedure i have use (@POdate as Datetime).
in Code i have used like this:

CultureInfo en = new CultureInfo("en-US");
Thread.CurrentThread.CurrentCulture = en;
string format = "dd/MM/yyyy";
string Podate = txtPODate.Text.Trim().ToString();
DateTime DT = DateTime.ParseExact(dt1, format, en.DateTimeFormat);
cmd.Parameters.Add("@PODate", SqlDbType.DateTime).Value = DT;

但在

but i get an Error after

cmd.ExecuteNonQuery();

语句后出现错误，

statement,

Error:Conversion failed when converting date and/or time from character string.

我只想要Date 24/07/2012而不是时间.
在数据库中的格式类似于(2012-07-24)(yyyy-MM-dd).

哪来做Guyzz !!!!!!
请回复
Aamir

i just want the Date 24/07/2012 not the time.
in database the format is like (2012-07-24)(yyyy-MM-dd).

wht to do guyzz!!!
pl reply
Aamir

推荐答案

尝试:

CultureInfo en = new CultureInfo("en-US");
Thread.CurrentThread.CurrentCulture = en;
string format = "dd/MM/yyyy";
string Podate = txtPODate.Text.Trim().ToString();
DateTime DT = DateTime.ParseExact(dt1, format, en.DateTimeFormat);


// Add the parameter
cmd.Parameters.Add("@PODate", SqlDbType.DateTime);
// Set the parameter value based on parameter index
cmd.Parameters[0].Value = DT;

或添加如下参数:

Or add the parameter like this:

cmd.Parameters.Add(new SqlParameter
                        {
                            Value = DT,
                            SqlDbType = SqlDbType.DateTime,
                            ParameterName = "@PODate"
                        });

我想给你的一个建议是，仅在数据库sp中进行转换.
像这样发送:

Hi,
One suggestion I want go give you is, do the conversion in database sp only.
Send it like:

cmd.Parameters.Add("@PODate", SqlDbType.DateTime).Value = Convert.ToDateTime(txtPODate.Text);

祝一切顺利.
-=-Amit

All the best.
-=-Amit

我希望此链接对您有帮助
字符串被识别为无效的DateTime [ ^ ]

I hope this link will help you
String was not recognized as a valid DateTime[^]

这篇关于通过网页时日期时间错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！