Accessing multiple datasets through multiple forms 1

[Vandy02]

I have a dataset called now that consists of three tables.
(now, "EMP")
(now, "DEPT")
(now, "SAL")
These are filled from remote db.

I am able to click within a datagrid (consisting of "DEPT") and then edit the values on a separte form with text boxes. This works very well through the use of managerbase and currency manager. What I would like to do is have the second form display a grid with "EMP" data along with the editable fields from the "DEPT".

Form 1:

DEPT GRID:

DEPTNO LOCATION


Click on a record and display second form

Form 2:

DeptNo editable field
Location editable field

EMP GRID:

EMPNAME DEPTNO

In the same fashion I will be doing the same with respect to "EMP" and "SAL" on a third form....

I guess that what I am trying to do is pass multiple tables or dataviews to forms...

Or do I have another way to access the datasets through multiple forms?

Thanks

 

[andrea96]

I don't know if this is the best way...
If I need to use a dataset in multiple forms, I declare it as a public dataset in a module.

 

[Vandy02]

would you be able to provide me short example of how to do that?

this sounds like the better situation for sure

 

[andrea96]

I have a module called FormFuctions that I use for any variables, funtions, or subs that I need to access from multiple forms.

Module FormFunctions
    Public DataSet1 As New DataSet
End Module

Then, in the forms, you just refer to the dataset normally. For example, to bind your datagrid:

DataGrid1.SetDataBinding(DataSet1, "myTableName")

Hope this helps.

 

[Vandy02]

thanks...

i also tried something else that seemed to work...

in the main form:

Public now as dataset

then I made the private sub that populated the dataset to public...and it carried over..

thanks again