MSAccess DB and DataSets - help

[Julie Smith]

Hi,
I have VS.net 2005 express and I have created a new project. I made a new
folder and added and existing MS Access DB (Maintenance.mdb). VS.net happily
went and created a DataSet class for me (MaintenanceDataSet). My question
is:
How do I load the data from the Access DB so I can access it from the
application?

Thank you in advance.

 

[William \(Bill\) Vaughn]

Access has an upsizing wizard that can (only) get you started... there are
whole books on the subject (and no, I did not write any of them).

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)

 

[Cor Ligthert [MVP]]

Julie,

Create an OleDBConnection (conn) using an OleDB connectionstring
Create an OleDBAdapter (da) using that connection and an SQLString (Select *
from Tabelname)
Fill the dataset da.fill(maintenanceDataSet)

That is all.

Cor

 

[Paul Clement]

¤ Hi,
¤ I have VS.net 2005 express and I have created a new project. I made a new
¤ folder and added and existing MS Access DB (Maintenance.mdb). VS.net happily
¤ went and created a DataSet class for me (MaintenanceDataSet). My question
¤ is:
¤ How do I load the data from the Access DB so I can access it from the
¤ application?

What is it that you want to do with the data?

I would check out the documentation:

Walkthrough: Creating a Dataset with the Dataset Designer
http://msdn2.microsoft.com/en-us/library/ms171897(VS.80).aspx


Paul
~~~~
Microsoft MVP (Visual Basic)