MSAccess DB and DataSets - help

  • Thread starter Thread starter Julie Smith
  • Start date Start date
J

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.
 
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)
 
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
 
¤ 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)
 
Back
Top