formatting radgriddateView

[mampus]

Hi there,
is there any way to set the default year when the radgriddateview is load.??
here my problem: i Have column call  "birthday"...i want to set the default year when loaded to 1980..
how i do that..???

[Emanuel Varga]

Hello Mampus,

You could just set the NullValue when you are creating the column, like so:

var dateTimeColumn = new GridViewDateTimeColumn("Date");
dateTimeColumn.NullValue = new DateTime(2000, 1, 1);
radGridView1.Columns.Add(dateTimeColumn);

Hope this helps, if you have any other questions or comments, please let me know,

Best Regards,
Emanuel Varga

[Abba]

I know this is older post.  But related to this, is there a way to do it when binding data from a datatable to the grid?

Or is the way to loop thru the columns created and set NullValue

Or is the way to set in cellFormatting if DbNull make value "SOMETHING"

 

Thanks,

[Dimitar]

Hi Abba,

Thank you for writing.

When the columns are autogenerated you only need to cast the column to the proper type in order to set the NullVallue:

protected override void OnLoad(EventArgs e)
{
    base.OnLoad(e);
    foreach (var item in radGridView1.Columns)
    {
        if (item is GridViewDateTimeColumn)
        {
            GridViewDateTimeColumn col = item as GridViewDateTimeColumn;
            col.NullValue = new DateTime(2000, 1, 1);
        }
    }
}

I hope this helps.

Regards,
Dimitar
Telerik