How do you use a table that is populated in form1 in form 2?

Question

1.00/5 (1 vote)

See more:

So, as of right now I am having problems manually binding to a table that is filtered. in form 1 I have the filter set with an sql query. If I do not run the filter code I can navigate and select rows using gridview. Once I use the filter the record selected comes out to be record 1-5 depending if I select the 5th row or not. how can someone reference the filtered table in form1 to use in form2?

What I have tried:

I have tried to create another table in form2, but I can't use it cause it will reference all records.

Posted 17-Aug-17 17:15pm

Member 11856456

Updated 17-Aug-17 21:42pm

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)

Atlapure Ambrish · Accepted Answer · 2017-08-17T21:42:00

Try below code..

Public Class frm1
     Public dtSongs As DataTable

     'the datatable is filled in the form somewhere

     Public Sub OpenForm3
          Dim frmTemp As New frm3(Me)

          frmTemp.Show()
     End Sub
End Class

'Form 3
Public Class frm3
     Dim myInstanceOffrm1 As frm1

     Public Sub New(ByVal Passfrm1 As frm1)

          myInstanceOffrm1 = Passfrm1

     End Sub

     Public Sub GetForm1DataTable()
          'Access the DataTable
          myInstanceOffrm1.dtSongs        
          
     End Sub
End Class