如何在C#中将字符串从date转换为dateTimePicker? [英] How to convert string to dateTimePicker fromate in C#?

问题描述

我正在从名为dt的日期表对象中从数据库中获取数据.
我想将该字符串转换为dateTimePicker的格式.
我尝试使用下面的代码，但无法正常工作.

dt是DataTable的对象

dtpPlanDate.Value = DateTime.ParseExact(dt.Rows [0] ["PlanSDate"].ToString()，"yyyy-MM-dd HH:mm:ss，fff"，System.Globalization.CultureInfo.InvariantCulture);


它给了我这个错误字符串未被识别为有效的DateTime."

我还尝试了其他格式，如下所示
dtpPlanDate.Value = Convert.ToDateTime(dt.Rows [0] ["PlanSDate"].ToString());

它给了我错误
无法从"mm/dd/yyyy"确定年份，月份和日期的顺序.

我还尝试了另一种格式

dtpPlanDate.Value = DateTime.Parse(dt.Rows [0] ["PlanSDate"].ToString());


它给了我下面的错误

无法从"mm/dd/yyyy"确定年份，月份和日期的顺序.



请让我知道正确的格式

I am fetching data from database in datetable''s object called dt.
I want to convert that string in to dateTimePicker ''s format .
I have try below code but its not working .

dt is object of DataTable

dtpPlanDate.Value = DateTime.ParseExact(dt.Rows[0]["PlanSDate"].ToString(), "yyyy-MM-dd HH:mm:ss,fff", System.Globalization.CultureInfo.InvariantCulture);


it gives me this error "String was not recognized as a valid DateTime."

I also tried other format as below
dtpPlanDate.Value = Convert.ToDateTime(dt.Rows[0]["PlanSDate"].ToString());

it gives me error
Could not determine the order of year, month, and date from ''mm/dd/yyyy''.

I also tried one more format

dtpPlanDate.Value =DateTime.Parse(dt.Rows[0]["PlanSDate"].ToString());


it gives me below error

Could not determine the order of year, month, and date from ''mm/dd/yyyy''.



please let me know right format

推荐答案

尝试一下

DateTime dt = Convert.ToDateTime(DateTime.Now, System.Globalization.CultureInfo.CreateSpecificCulture("en-us").DateTimeFormat); 

您可以像这样使用en-us(美国)，en-IN(印度)之类的文化

you can give culture like en-us(united states),en-IN(india) like this

您可以使用DateTime.TryParse

You can use the DateTime.TryParse method[^] to ensure that the input you pass in is a valid datetime.

IFormatProvider provider = new System.Globalization.CultureInfo("en-CA", true);
DateTime fDate = DateTime.Parse(urTxtBoxId.Value, provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault);

并且在传递给数据库时使用

and while passing to database use

fDate.ToString() overloads 
e.g.fDate.ToString("MMM d yyyy");

这篇关于如何在C#中将字符串从date转换为dateTimePicker?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！