Copy some selected rows from one grid to another grid

[Sourav]

In grid there have some multiple records. Now I am selecting some rows. I want to copy only those selectable rows in another grid.
How I can do this. Please help.

Thanks in advance.

[Paul]

Has anyone implemented this? I am looking for the same thing.

Thank you in advance.

[Marko]

I am looking for the same thing too.

-Marko

[Paul]

I figured it out. With multiselect you can't do drag and drop, so you'll have to use a click event to copy the selected rows from one grid to another. Here's the javascript code:

        $('#btnAddMulti').click(function () {
 
            var sourcegrid = $('#searchgrid').data('kendoGrid');        //SOURCE GRID
            var destinationgrid = $('#selectedgrid').data('kendoGrid'); // DESTINATION GRID
 
            sourcegrid.select().each(function () {
                var dataItem = sourcegrid.dataItem($(this));
                destinationgrid.dataSource.add(dataItem);       // DESTINATION DATASOURCE
            });
            destinationgrid.refresh();                          // MUST REFRESH THE DESTINATION GRID
            alert('refreshed');
 
        });

I hope this helps.

[Marko]

Hi,

Thanks Paul for example, it works.

Is it possible to avoid duplicates (liike. same product name) in destination grid? So, that items can be copied only once. In asp.net I'm using Insert event to check if item already exists.

-Marko

[Paul]

Marko, I just implemented this as well, it's pretty easy:

           $('#btnAddMulti').click(function () {
 
               var sourcegrid = $('#searchgrid').data('kendoGrid');        //SOURCE GRID
               var destinationgrid = $('#selectedgrid').data('kendoGrid'); // DESTINATION GRID
 
               sourcegrid.select().each(function () {
                   var dataItem = sourcegrid.dataItem($(this));

                   //*******************
                   // Check to make sure it's not in there
                   var column = dataItem.ProductId; // whatever the name of the unique id for your data source
                   if (destinationgrid.dataSource.get(column) == null)
                       destinationgrid.dataSource.add(dataItem);       // DESTINATION DATASOURCE
            	   else
                	alert('already exists');

                   //*******************
               });
               destinationgrid.refresh();                          // MUST REFRESH THE DESTINATION GRID
               alert('refreshed');
           });
Here's my data source to see the "ProductId":
           var dataSource = new kendo.data.DataSource({
               data: data.datalist,
               schema: {
                   model: {
                       id: "ProductId",
                       fields: {
                           ProductId: { type: 'int', nullable: false },
                           ProductName: { type: 'string', editable: false, nullable: true }
                       }
                   }
               }
           });

[Ricardo]

is not my post but thanks, I served a lot of your example

[jonathan]

Hey guys,

I have implemented your above example, but am editing the destination grid by cell.  When you edit a cell in the destination grid, it updates the source as well.  Is there a way around this?