How to move selected rows of one datagridview to another datagridview.

Question

1.00/5 (1 vote)

See more:

I have 2 datagridview (dgvFrom and dgvTo) and 2 buttons with right and left arrows. dgvfrom is populated from dataset. Now when I select rows in dgvFrom and click right arrow button, selected rows should move to dgvTo grid and those selected rows should get deleted from dgvFrom grid.and vice versa for left arrow button.Can any1 help me with this.

Posted 31-Dec-12 19:24pm

Rachna0309

Add a Solution

Comments

Sergey Alexandrovich Kryukov 1-Jan-13 1:53am

What did you try so far? What was the problem?
—SA

Rachna0309 1-Jan-13 1:57am

For Each selRow As DataGridViewRow In dgvFrom.SelectedRows
dgvTo.Rows.Add(selRow)
dgvFrom.Rows.Remove(selRow)
Next

I have tried with this code but it gives me error:
No row can be added without column.

Sergey Alexandrovich Kryukov 1-Jan-13 2:05am

Probably this is a problem of dfvTo; you did not add proper columns to it.
—SA

Rachna0309 1-Jan-13 2:06am

how to add columns to dgvto grid.

Sergey Alexandrovich Kryukov 1-Jan-13 2:10am

Look, if you already have dgvFrom, you already know how to add columns...
—SA

Rachna0309 1-Jan-13 2:15am

I have added columns in dgvfrom from dataset that was filled using query.Do i need to add columns in dgvto from datagridview design?

Sergey Alexandrovich Kryukov 1-Jan-13 2:21am

As you need to add the same rows, you should have the same columns, apparently.
—SA

Rachna0309 1-Jan-13 3:17am

Hello....can any1 provide me the solution?

Sergey Alexandrovich Kryukov 1-Jan-13 3:31am

You already have all key points. What else do you need. Just put it all together.
—SA

Rachna0309 1-Jan-13 2:25am

If I add columns in dgvTo from design I get the error below:
Row provided already belongs to a DataGridView control.

Sergey Alexandrovich Kryukov 1-Jan-13 3:30am

You need to create a row from scratch using just the data from another row.
—SA

Rachna0309 1-Jan-13 3:36am

Can you please put down the code for this?

Sergey Alexandrovich Kryukov 1-Jan-13 3:44am

In VB.NET. Honestly, don't want to add it to the installation of VS. Never install it and will hardly ever do it, sorry...
Look, one little effort and you will get it right. After all, you are the one most interested in that. Additionally, you will get a little practice solving some problems...
—SA

Rachna0309 1-Jan-13 3:38am

What if my dgvTo is also databound?

Sergey Alexandrovich Kryukov 1-Jan-13 3:41am

Probably won't work. Unbound it. Binding with a data source and manipulations with rows (or whatever) are contradictory, can't you see it? Or do it all with binding only: create a special data source which gives you desired result and refresh the control.
—SA

2 solutions

Solution 1

You need to remove them in one grid view and create in another one. Rows are not controls; in contrast to controls, you cannot "re-parent" them.

—SA

Posted 31-Dec-12 19:52pm

Sergey Alexandrovich Kryukov

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)

Rahul K Singh · Accepted Answer · 2012-12-31T22:11:00

Hi,
this code might help you.

Dim DsTo As New DataSet '' '' Dataset for to DatagridView

'' '' Code on button Click
      for DgvToFor Each r As DataGridViewRow In DGVFrom.SelectedRows
           Dim Drto As DataRow = DsTo.Tables(0).NewRow
           For c As Integer = 0 To DGVFrom.ColumnCount - 1
               Drto(c) = r.Cells(c).Value
           Next
           DsTo.Tables(0).Rows.Add(Drto)
           DGVFrom.Rows.Remove(r)
       Next

RKS