Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
311 views
in Technique[技术] by (71.8m points)

c# - drag and drop cell from datagridview to another

I have 2 datagridviews and i want to copy cells from the datagridview1 to datagridview2 (a cell at a time).I′m able to select the cell I want and drag it to the datagridview2 but the value is not showing... I spent most of the night looking for a solution...Probably is a simple answer or I just need to sleep , but please help.... I have the following code

        private void dataGridView1_MouseDown(object sender, MouseEventArgs e)
    {
        if (e.Button == MouseButtons.Left)
        {
            DataGridView.HitTestInfo info = dataGridView1.HitTest(e.X, e.Y);
            if (info.RowIndex >= 0)
            {
                if (info.RowIndex >= 0 && info.ColumnIndex >= 0)
                {
                    string text = (String)
                           dataGridView1.Rows[info.RowIndex].Cells[info.ColumnIndex].Value;
                    if (text != null)
                        dataGridView1.DoDragDrop(text, DragDropEffects.Copy);
                }
            }
        }
    }

     private void dataGridView2_DragDrop(object sender, DragEventArgs e)
    {
        string cellvalue=e.Data.GetData(typeof(string)) as string;
        Point cursorLocation=this.PointToClient(new Point(e.X,e.Y));

        System.Windows.Forms.DataGridView.HitTestInfo hittest= dataGridView2.HitTest(cursorLocation.X,cursorLocation.Y);
        if (hittest.ColumnIndex != -1
            && hittest.RowIndex != -1)
            dataGridView2[hittest.ColumnIndex, hittest.RowIndex].Value = cellvalue;
    }

    private void dataGridView2_DragEnter(object sender, DragEventArgs e)
    {
        e.Effect = DragDropEffects.Copy;
    }

And the designer.cs i have

 // dataGridView1
        // 
        this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
        this.dataGridView1.Location = new System.Drawing.Point(12, 12);
        this.dataGridView1.Name = "dataGridView1";
        this.dataGridView1.Size = new System.Drawing.Size(299, 150);
        this.dataGridView1.TabIndex = 0;
        this.dataGridView1.MouseDown += new System.Windows.Forms.MouseEventHandler(this.dataGridView1_MouseDown);
        // 
        // dataGridView2
        // 
        this.dataGridView2.AllowDrop = true;
        this.dataGridView2.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
        this.dataGridView2.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
        this.Column1,
        this.Column2});
        this.dataGridView2.Location = new System.Drawing.Point(353, 141);
        this.dataGridView2.Name = "dataGridView2";
        this.dataGridView2.Size = new System.Drawing.Size(240, 150);
        this.dataGridView2.TabIndex = 5;
        this.dataGridView2.DragDrop += new System.Windows.Forms.DragEventHandler(this.dataGridView2_DragDrop);
        this.dataGridView2.DragEnter += new System.Windows.Forms.DragEventHandler(this.dataGridView2_DragEnter);
        // 
See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

You can use following code. I have tested it and it is working for copying cell data from one datagridview to another.

        private void dataGridView2_DragEnter(object sender, DragEventArgs e)
    {
        e.Effect = DragDropEffects.Copy;
    }

    /* Drag & Drop */
    private Rectangle dragBoxFromMouseDown;
    private object valueFromMouseDown;
    private void dataGridView1_MouseMove(object sender, MouseEventArgs e)
    {
        if ((e.Button & MouseButtons.Left) == MouseButtons.Left)
        {
            // If the mouse moves outside the rectangle, start the drag.
            if (dragBoxFromMouseDown != Rectangle.Empty && !dragBoxFromMouseDown.Contains(e.X, e.Y))
            {
                // Proceed with the drag and drop, passing in the list item.                    
                DragDropEffects dropEffect = dataGridView1.DoDragDrop(valueFromMouseDown, DragDropEffects.Copy);
            }
        }
    }

    private void dataGridView1_MouseDown(object sender, MouseEventArgs e)
    {
        // Get the index of the item the mouse is below.
        var hittestInfo = dataGridView1.HitTest(e.X, e.Y);

        if (hittestInfo.RowIndex != -1 && hittestInfo.ColumnIndex != -1)
        {
            valueFromMouseDown = dataGridView1.Rows[hittestInfo.RowIndex].Cells[hittestInfo.ColumnIndex].Value;
            if (valueFromMouseDown != null)
            {
                // Remember the point where the mouse down occurred. 
                // The DragSize indicates the size that the mouse can move 
                // before a drag event should be started.                
                Size dragSize = SystemInformation.DragSize;

                // Create a rectangle using the DragSize, with the mouse position being
                // at the center of the rectangle.
                dragBoxFromMouseDown = new Rectangle(new Point(e.X - (dragSize.Width / 2), e.Y - (dragSize.Height / 2)), dragSize);
            }
        }
        else
            // Reset the rectangle if the mouse is not over an item in the ListBox.
            dragBoxFromMouseDown = Rectangle.Empty;
    }

    private void dataGridView2_DragOver(object sender, DragEventArgs e)
    {
        e.Effect = DragDropEffects.Copy;
    }

    private void dataGridView2_DragDrop(object sender, DragEventArgs e)
    {
        // The mouse locations are relative to the screen, so they must be 
        // converted to client coordinates.
        Point clientPoint = dataGridView2.PointToClient(new Point(e.X, e.Y));

        // If the drag operation was a copy then add the row to the other control.
        if (e.Effect == DragDropEffects.Copy)
        {
            string cellvalue = e.Data.GetData(typeof(string)) as string;
            var hittest = dataGridView2.HitTest(clientPoint.X, clientPoint.Y);
            if (hittest.ColumnIndex != -1
                && hittest.RowIndex != -1)
                dataGridView2[hittest.ColumnIndex, hittest.RowIndex].Value = cellvalue;

        }
    }

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...