Copying selected rows from one DGV to another DGV

Question

0.00/5 (No votes)

See more:

Hi,

Can anyone give me an idea of how to copy selected rows from one datagridview to another datagridview provided by the order rows should be displayed in the same order. Like the selected rows in from DGV1 will be

row 1
row 2
row 3

the DGV2 also display the copied rows in same order as above not like

row 3
row 2
row 1

Thanks in advance

Posted 8-Nov-11 0:44am

CyborgForever

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

E.F. Nijboer · Answer 1 · 2011-11-08T00:50:00

Solution 1

Have a look here about how to copy the rows:
http://social.msdn.microsoft.com/forums/en-US/csharpgeneral/thread/b10ba6b8-677c-4629-b1ed-ec45086d33dd[^]

...and to get the selected rows:
http://msdn.microsoft.com/en-us/library/x8x9zk5a.aspx[^]

Good luck!

Posted 8-Nov-11 0:50am

E.F. Nijboer

OriginalGriff · Answer 2 · 2011-11-08T00:59:00

Solution 2

I assume this is happening because you are looping through the source DGV and using the Add method to append them to the destination?
The easiest way is not to use Add, but Insert instead - that way you can specify exactly where in the Rows list you want the items.

Posted 8-Nov-11 0:59am

OriginalGriff

Comments

CyborgForever 8-Nov-11 23:34pm

Can u pls help me out in the syntax. Because what I've done is I added the selected rows to a Datatable and then bound the DT to DGV.

OriginalGriff 9-Nov-11 4:02am

The DataTable.Rows Collection also has an Insert method...

CyborgForever 9-Nov-11 6:07am

I tried the insertion(ref to my above solution) but this does'nt work when the datagridview from which I'm getting the selected rows is not bound.

P.Salini · Answer 3 · 2011-11-08T01:00:00

Check this

http://bytes.com/topic/c-sharp/answers/899342-how-copy-rows-one-datagridview-another[^]

http://stackoverflow.com/questions/6891267/copying-rows-from-one-datagridview-to-another[^]

http://stackoverflow.com/questions/6172867/copy-data-from-one-datagridview-to-another-in-c-sharp[^]

http://social.msdn.microsoft.com/Forums/en-US/winformsdatacontrols/thread/ae9bee8d-e2ac-43c5-9b6d-c799d4abb2a3/[^]

CyborgForever · Answer 4 · 2011-11-08T18:43:00

C#

selectedRowCount = dgv.Rows.GetRowCount(DataGridViewElementStates.Selected);
                if (selectedRowCount > 0)
                {
                    DataRow[] dRows = new DataRow[dgv.SelectedRows.Count];
                    for (int i = 0; i < dgv.SelectedRows.Count; i++)
                        dRows[i] = ((DataRowView)dgv.SelectedRows[i].DataBoundItem).Row;
                    foreach (DataRow dgvRow in dRows)
                    {
                        dgvNew.Rows.Insert(0, dgvRow.ItemArray);
                    }
                    dgvNew.Refresh();

                }

Copying selected rows from one DGV to another DGV

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0