[Solved] Grid inline edit Date Column

[Howard]

Dear Telerik Team,

I've a grid with inline editing. I need to put a datepicker in one of the columns, but the actual date data is stored in database as a string in "yyyyMMdd" format. I've looked into demo of ajax editing here, but it needs date as a actual datetime datatype. is there a way I can use date as string and still get the functionality?

Thank you

[Daniel]

Hello Niroj,

The field should be of DateTime type to use the DatePicker in edit mode. In order to use a  DatePicker 
in your scenario, you could use a ViewModel to convert the strings to valid dates. For example:

class Order {
        public string Date;
}

class OrderViewModel {
        public DateTime Date;
}

var orders = from o in GetOrders()
               select new OrderViewModel {
                      Date = Convert.ToDateTime(o.Date);
               }

Greetings,
Daniel
the Telerik team

[Howard]

Thanks Daniel, genius !!!