How to select date in datepicker

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.

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];