How to access multiple tables in VB.NET?

How to access multiple tables in VB.NET?
We have 4 tables(in MSAccess) of which one is not related to any other table.
To access all the 4 tables from a windows form should we have more than one data adapter and data set?

OR

Can we have independent data adapters and sets for each table?
Pls let me know in detail.

you can use the same DataAdapter to load multiple DataSet's.

Thank you very much mr.crpietschmann

Closing of Forms.

My problem is this:

When a new form(say Form2) pops up on clicking a button on the previous form(say Form1), I need to get the Form1 closed automatically.

I found the close method but it closes all the forms.Also there is Hide mehtod , but i dont know how to use that. Will this Hide help in solving the problem?

Pls let me know

To close the form you are in only add Me.Close () to your exit button.

For example


Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Me.Close()
End Sub

In the event that shows form2:

Private Sub btnShowForm2(........
Dim form2 as new form2
Me.ActiveForm.Hide() 'Hide Form1
Form2.Showdialog() 'Show Form2
End Sub

Hi,

"When a new form(say Form2) pops up on clicking a button on the previous form(say Form1), I need to get the Form1 closed automatically.

I found the close method but it closes all the forms.Also there is Hide mehtod , but i dont know how to use that. Will this Hide help in solving the problem?"

I think you may find that you have not started your application correctly. If you use the following code in a module and use the sub main as the startup, you will be able to close any form without affecting the others.


Public frm1 as new Form1
Public Sub Main()
Application.Run(frm1)
end sub

Regards,