RadDateTimeEditor defaults to 1 Jan 1753

[Johan]

Hi,

Any idea why my RadDateTimeEditor columns always defaults to 1 Jan 1753 on selection?

I've looked at the properties that RadDateTimeEditor expose but can find anything relevant.

Is there a why to default it to DateTime.Now maybe?

Thanks

[Richard Slade]

Hello,

Can you share the version you are using and your code? If for example you add the following to a new project with just a RadGridView on the page

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    Me.RadGridView1.Columns.Add(New GridViewTextBoxColumn("A"))
    Me.RadGridView1.Columns.Add(New GridViewTextBoxColumn("B"))
    Me.RadGridView1.Columns.Add(New GridViewDateTimeColumn("C"))
    Me.RadGridView1.Rows.Add("A1", "B1", Nothing)
    Me.RadGridView1.Rows.Add("A2", "B2", Nothing)
    Me.RadGridView1.Rows.Add("A2", "B2", Nothing)
End Sub

then the date defaults to today when the cell is in edit mode and you drop down the calendar. The cell value is currently Null.
Regards,
Richard

[Johan]

Hi,

I'm using version 2010.2.10.914 of the winform controls.

Here is my code:

GridViewDateTimeColumn col = new GridViewDateTimeColumn();

col.Name = node.Name;
col.FieldName = node.Name;
col.HeaderText = friendlyName;
col.FormatString = "{0:yyyy-MM-dd}";
col.Width = 150;

radGridView1.Columns.Add(col).

Hope this helps?

[Richard Slade]

Hi Ryno,

As we are using different versions, I want to ensure I know how you are populating the grid. Please could you also let me know this as it may affect the answer.
Thanks
Richard

[Johan]

Hi,

My grid datasource is coming from a dataset which I load from excel.

Here is the code:

DataSet dsData = new DataSet();

dsData.ReadXml("XMLFile.xml");
radGridView1.DataSource = dsData.Tables[0];

Thanks

[Richard Slade]

Hello,

If you set the value to null, this shouldn't happen. The date will be today, however, if the date is defined as

new DateTime();

then it seems the editor will always show 1753. At the moment, I haven't been able to change the date, despite setting the value of the RadDateTimeEditor when the CellEditorInitualized event is fired.

I'll keep having a look for you as I'm sure this should be straightforward and let you know if i can get it for you.
regards,
Richard

[Johan]

Thanks Richard!

Its really odd that this is happening... 

[Richard Slade]

Hello Ryno,

You can set the columns Null value by using

Column.NullValue = DateTime.Today;

but if your data has a date, and that date is

DateTime date = new DateTime();

then this date is not null, so it will display that value. The editor is displaying the value of the cell, which I think is normal. In this case I beleive you would need to set a default date in your data source. If you want the date to be today, then set the date to null, and set the null value for the column

Hope that helps
Richard

[Johan]

Thanks for this Richard.

The challenge I'm facing now is that datasource (DataSet) gets populate from XML via ReadXml(). At that point all the DataColumns in the DataTable is of type string and I can't change the data type once the DataTable is filled with data.

Again, thanks. You have been of great help.

[Richard Slade]

Hi. If you'd like to post a sample project I'll see what I can do with it. Richard

[Richard Slade]

Ryno,

If the type is coming out as string, then you could make the column in your data table null(able)?
regards,
Richard

[Johan]

Hi Richard,

I'm not sure I understand you correctly. What do you mean by making it nullable?

My columns in the datatable gets created dynamically when I read xml into the dataset and therefore I don't have control to change any of the data columns. I hope I make sense?! :-)

[Richard Slade]

Ok,

If you had control of the datatable then if the column is nullable, then you are able to control a null date. There must be blank dates (minimum dates) in your data therefore.
Richard

[Stefan]

Hello guys,

Thank you both for writing.

Let me check if I have understood correctly:
You have a xml that comes from Excel and then you load it in a DataSet which is the DataSource for RadGridView. When the source is loaded, it is displayed in RadGridView as the MinDate (1 Jan 1753) and you want to show the today date.

Since you can not access the data set, the other approach is to iterate over the cells and change the values of the desired cells after you bind the grid. To do that, subscribe to the DataBindingComplete event of RadGridView and use the following code snippet:

void radGridView1_DataBindingComplete(object sender, Telerik.WinControls.UI.GridViewBindingCompleteEventArgs e)
       {
           foreach (GridViewRowInfo rowInfo in radGridView1.Rows)
           {
               foreach (GridViewCellInfo cellInfo in rowInfo.Cells)
               {
                   if ((cellInfo.ColumnInfo.Name == "DateTime"))
                   {
                       if (cellInfo.Value.Equals(new DateTime()))
                       {
                           cellInfo.Value = DateTime.Now;
                       }
                   }
               }
           }
       }

Let me know if this works for you. 
 
All the best,
Stefan
the Telerik team

[Johan]

Hi guys

Sorry for only providing you with some feedback now...

Anyway, after a lot of investigation and debugging it was clear that something was wrong somewhere else and not necessarily at the point where I create and setting the column's formats etc.

As it turns out my problem was at the point where I set the grid's data source, in my case the DataTable. All my data from the XML which I loaded in the dataset was of type String...

The approach I took was to create the DataTable programmatically by setting each column to the correct data type first and then only load the XML into the DataTable.

DataTable tbl = new DataTable("MyTable");

tbl.Columns.Add("tb_BarCode", typeof(String));
tbl.Columns.Add("dt_PurchaseDate", typeof(DateTime));

tbl.ReadXml(myXMLFile);

Obviously you need to make sure that the XML is in the correct format. What I did was to create the DataTable as per above example, set the columns and added some some data and then wrote the DataTable to XML to see what the correct format should look like.

By correcting the format and types of my grid's datasource (the DataTable) solved pretty much all my issues I had with formatting etc.

Regards