How to set RadDatePicker textbox from database

[Rob Venable]

Hi,
 I have a contact page that retrieves contact information from the database. When I populate all fields from the database, how do I set the date for my RadDatePicker textbox to that of birthdate value from my contact object.

ex: RadaDatePicker1.Value = Contact.Birthdate

Thanks

[Shinu]

Hi Rob,

You can set the date for RadDatePicker as shown below.

CS:
     RadDatePicker1.SelectedDate = (DateTime) Contact.Birthdate;

-Shinu.

[robertw102]

The proper way to set the selected date of a RadDatePicker control from the database would be like so:

RadDatePicker1.DbSelectedDate = Contact.BirthDate;

This way if the BirthDate is null, no error is thrown.

[Rob Venable]

Hi,
Thanks for the information. Both scenarios worked.

[Eric Larsen]

Error 32 Cannot convert type 'string' to 'System.DateTime' 

please help.

[Shinu]

Hi Eric,

Please try the following C# code.

C#:

RadDatePicker1.SelectedDate = DateTime.ParseExact(datestring, "M/d/yyyy", CultureInfo.InvariantCulture);

Thanks,
Shinu.