如何在datepicker中选择日期 [英] How to select date in datepicker

问题描述

大家好，



我在C＃的Windows程序中使用datepicker。我将日期从datetimepicker插入到sqlserver，但遗憾的是我无法从database.it中检索日期。抛出错误。

请任何人帮我。如何从数据库中选择datepicker中的日期。





这是我的代码..

Hi everyone,

i am using datepicker in my windows program in C#. I inserted date from datetimepicker to sqlserver but unfortunately I can not retrieve date from database.it is throwing error.
please any one help me.how to select date in datepicker from database.


here is my piece of code..

dtRecDate.Value = Convert.ToDateTime(dtDocHeaderDetails.Rows[0].ItemArray[13]);

推荐答案

我们需要知道错误，以确定发生了什么，但你应该能够解决这个问题通过调试它。在该行代码上设置断点并查看值是什么。



另外，我建议你不要使用索引引用你的列，因为它取决于你的sql不改变。而是做这样的事情：

We would need to know the error to know for sure what is happening but you should be able to solve this by debugging it. Put a breakpoint on that line of code and see what the values are.

Also, I would suggest you not reference your columns using an index because it depends on your sql not changing. Instead do something like this:

dtDocHeaderDetails.Rows[0]["fieldName"]

数据库的数据类型是什么您要存储值的列？在存储或阅读日期时，您可以将其转换为您需要的格式，请参阅以下链接。



http://msdn.microsoft.com/en-us/library/ms187928%28SQL.90%29.aspx [<一个href =http://msdn.microsoft.com/en-us/library/ms187928%28SQL.90%29.aspxtarget =_ blanktitle =New Window> ^ ]





CAST语法：

CAST（表达式AS data_type [（长度）]）



CONVERT的语法：

CONVERT（data_type [（length）]，表达式[，样式]）



103用于英国/法国格式，如dd / mm / yy。



还有很多其他格式。请参考上面的链接，以便更好地理解在sql中使用日期时间。

What is the datatype of your database column where you are storing your values? While storing or reading the date you can convert it in a format that you require refer following link.

http://msdn.microsoft.com/en-us/library/ms187928%28SQL.90%29.aspx[^]


Syntax for CAST:
CAST ( expression AS data_type [ (length ) ])

Syntax for CONVERT:
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )

103 is used for British/French format like dd/mm/yy.

There are lot many other formats. Please refer above link for better understanding on using date time in sql.

我建​​议检查字段是否等于DBNull.Value [ ^ ]。

例如：

I'd suggest to check if field is equal to DBNull.Value[^].
For example:

DateTime myDate = DateTime.Today();
if (DBNull.Value.Equals(dtDocHeaderDetails.Rows[0].ItemArray[13]))
    dtRecDate.Value = myDate;
else
    dtRecDate.Value = dtDocHeaderDetails.Rows[0].ItemArray[13];

这篇关于如何在datepicker中选择日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！