drag drop rows in RadGrid

[Susi]

Dear All,

I have two RadGridView in WindowsForms namely radGridView1 and radGridView2.
 
I have data in radGridView1 and also i need to drag and drop radGridView1 row to radGridView2 wise single row and multi row.

And also no data in radGridView2.

My coding are mentioned below.

private void Form1_Load(object sender, EventArgs e)
       {
           DataTable dt = new DataTable();
           dt = c.getdata();
           radGridView1.DataSource = dt;
       }
public DataTable getdata()
       {
           con.Open();
           cmd = new SqlCommand("select * from employee", con);
           sda = new SqlDataAdapter(cmd);
           sda.Fill(dt);

           con.Close();
           return dt;
       }

How to implement this?

Thanks in Advance..!

[Princy]

Hi Susi,

There is an example demonstrating drag & drop between grids in winforms demo application. It is located under GridView >> Rows >> Rows Drag & Drop. Following is the sample code with reference to the demo.

C#:

private void dragDropService_PreviewDragDrop(object sender, RadDropEventArgs e)
        {
            SnapshotDragItem dragInstance = e.DragInstance as SnapshotDragItem;

            if (dragInstance == null)
            {
                return;
            }

            RadItem dropTarget = e.HitTarget as RadItem;
            RadGridView targetGrid = dropTarget.ElementTree.Control as RadGridView;

            if (targetGrid == null)
            {
                return;
            }

            RadGridView dragGrid = dragInstance.Item.ElementTree.Control as RadGridView;

            if (targetGrid != dragGrid)
            {
                e.Handled = true;

                CustomGridBehavior behavior = (CustomGridBehavior)dragGrid.GridBehavior;
                GridDataRowElement dropTargetRow = dropTarget as GridDataRowElement;
                int index = dropTargetRow != null ? this.GetTargetRowIndex(dropTargetRow, e.DropLocation) : targetGrid.RowCount;
                this.MoveRows(targetGrid, dragGrid, behavior.SelectedRows, index);
            }
        }

private void dragDropService_PreviewDragOver(object sender, RadDragOverEventArgs e)
        {
            if (e.DragInstance is SnapshotDragItem)
            {
                e.CanDrop = e.HitTarget is GridDataRowElement || e.HitTarget is GridTableElement || e.HitTarget is GridSummaryRowElement;
            }
        }

private void dragDropService_PreviewDragHint(object sender, PreviewDragHintEventArgs e)
        {
            SnapshotDragItem dragInstance = e.DragInstance as SnapshotDragItem;

            if (dragInstance == null)
            {
                return;
            }

            GridViewRowInfo rowInfo = e.DragInstance.GetDataContext() as GridViewRowInfo;

            if (rowInfo != null && rowInfo.ViewTemplate.MasterTemplate.SelectedRows.Count > 1)
            {
                e.DragHint = new Bitmap(this.imageList1.Images[6]);
                e.UseDefaultHint = false;
            }
        }

Hope this helps.

Regards,
Princy.

[Susi]

Thanks for your reply but i am binding Gridview with DataTable from database.I need this kind of bindings to implement this scenario.

Thanks in Advance...!

[Svett]

Hello Sucindran,

Presently, RadGridView does not support drag and drop of rows in data bound mode. Nevertheless, you can use a code library that demonstrates how you can customize the control to enable this scenario. You can find it here.

Regards,
Svett
the Telerik team