Using RadGrid Batch edit mode with different column type in each row

[Kunchit]

I am trying to use Batch edit mode in RadGrid. My problem is I need to display and edit different types of data in the same column of each row. I can query the data and set the Datasource of RadGrid programatically to display the data successfully. However, I don't know how to set the EditItemTemplate to let user edit the cell data depends on showing data type, eg. RadDropDownList for Status, RadTextBox for OrderNumber, RadNumericTextbox for Amount. My scenario is

Item          |     January    |  February    |    .....

---------------------------------------------------------- 

Status       |

Order#      |

Amount     |

What is the best way to implement this?

Thank you in advance.

[Konstantin Dikov]

Hello Kunchit,

RadGrid is not designed for such data editing and each column will have predefined editors, regardless of the edit mode. Furthermore, with Batch Editing, there will be only one editor generated for each column and the same editor will be moved along the edited cell.

The only thing that I could suggest is that you change your data structure and reverse the position of your columns and the rows, where each row will be different month and for each month you will entering the corresponding values for the Status, Order# and Amount columns.

Hope this helps.


Regards,
Konstantin Dikov
Telerik