Fill grid cells based on selection made in other cell on the same row

[boldicu]

Hi,

I'm evaluating Kendo components for use in a MVC web project. I'm very happy with the grid but now I run into a problem and I don't know from where to start.
I'm trying to create a view to enter invoices. For the invoice lines I use the kendo grid in batch editing mode. On each line I need to search for a product and fill the row cells with product code, product name and other details.
I started with a EditorTemplate attached to the first column "ProductCode".

columns.Bound(o => o.Product).EditorTemplateName("ProductItemDropDownList").ClientTemplate("#=ProductCode#");

The editor template contains a dropdowlist:

@(Html.Kendo().DropDownList()
   .Name("ProductCode")
    .DataTextField("ProductCode")
    .DataValueField("ProductId")
    .DataSource(dataSource => dataSource.Read(read => read.Action("GetProducts", "Invoice")).ServerFiltering(true))
)

The first problem is the cell remains empty after I select a product code. 
I expected to have there the code of the product.
The second problem, I have no idea how to fill the rest of the cells representing product description, ...

Thank you,
Flaviu Boldea