Dataset for local Desktop App

Everything that I've read about creating datasets so far has been geared to accessing a database on a server over a network or the net. But the app that I'm writing is a self contained database program designed to run on a single computer.

The only kind of adapters that I can see appear to be designed for connecting to DB's on a remote server. The 2 connectors that I see are the OleDbDataAdapter and SqlDataAdapter.

How do I connect a dataset to a local DB or is it all one and the same and I just missed a turn some where?


Thank you

David

You use the OleDbDataAdapter for any any DB, the SqlDbDataAdapter is optimized for SQL server. Once you drop the Ole data adapter on the for a wizard will popup and walk you through the setup. It is really easy.