how to copy rows from datagridview to other in vb

Question

0.00/5 (No votes)

See more:

VB

i want to copy rows from one datagridview in form1 to another datagridview in form2

Posted 7-Aug-15 22:17pm

Member 11894724

Add a Solution

1 solution

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)

OriginalGriff · Answer 1 · 2015-08-07T22:36:00

Solution 1

The first thing you need is the instance of Form2: the one that is being displayed.
Somewhere, you have created it, and displayed it, either using Show:

VB

Dim f2 As New Form2()
f2.Show()

Or you are going to use ShowDialog:

VB

Dim f2 As New Form2()
f2.ShowDialog()

In either case, you need the f2 variable available when you want to do the copy. In the second case, that's probably trivial because you will be setting the values between the create and display of the form.

Add a Public method to your Form2:

VB

Public Sub AddRow(row As DataGridViewRow)
	myDataGridView.Rows.Add(row)
End Sub

Then call that in a loop from Form1:

VB

Dim f2 As New Form2()
For Each row As DataGridViewRow In mySourceDataGridView.Rows
	f2.AddRow(row)
Next
f2.ShowDialog()

Posted 7-Aug-15 22:36pm

OriginalGriff

Updated 7-Aug-15 23:06pm

v2

Comments

[no name] 8-Aug-15 4:58am

that didn't work ,

OriginalGriff 8-Aug-15 5:05am

"that didn't work" is not a helpful error report. It tells me nothing.

So what happened when you tried? Anything? Any error message? Effects?
I can't see your screen, access your HDD, or read your mind! :laugh:

[no name] 8-Aug-15 5:01am

please help me

[no name] 8-Aug-15 5:01am

can you write full code for me !! ?

[no name] 8-Aug-15 5:14am

this is the error : Unable to cast object of type 'System.Data.DataRowView' to type 'System.Windows.Forms.DataGridViewRow'.

[no name] 8-Aug-15 5:18am

this is my code :

form1

Public Class Form1

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'T1DataSet.Table1' table. You can move, or remove it, as needed.
Me.Table1TableAdapter.Fill(Me.T1DataSet.Table1)

End Sub

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim f2 As New Form2()
For Each row As DataGridViewRow In Me.Table1BindingSource
f2.AddRow(row)
Next
f2.ShowDialog()
End Sub
End Class

form2

Public Class Form2

Private Sub Form2_Load(sender As Object, e As EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'T2DataSet.Table1' table. You can move, or remove it, as needed.
Me.Table1TableAdapter.Fill(Me.T2DataSet.Table1)

End Sub
Public Sub AddRow(row As DataGridViewRow)
DataGridView1.Rows.Add(row)
End Sub
End Class

[no name] 8-Aug-15 5:37am

can you enter my pc ?
(teamviewr)

[no name] 8-Aug-15 5:45am

i think the problem in my binding source name

my source name is table1bindingsource , what i should write

OriginalGriff 8-Aug-15 6:00am

Why are you trying to use the binding source instead of the Rows collection?

[no name] 8-Aug-15 6:09am

my datagridview1 datasource name is : table1bindingsource1

tools :

button1 : copy
datagridview1
datagridview1

forms :
form1 - button : copy , datagridview1
form2 - datagridview2

can you help me , and write the code for me with my tools name !

please !

thank you bro