To read and write data from
Access database
the
Typed DataSet
feature can be used. With typed dataset a
strongly typed class
is made for each
Table
and
Row
so that the columns of the
Table
can be accessed like
properties
without hard coding the Column names as strings.
A
Walkthrough on Creating a Dataset with the Dataset Designer
is given here
http://msdn.microsoft.com/en-us/library/ms171897(v=vs.80).aspx[
^] in which
Access version of Northwind
sample database can be used as stated in the
Note
on that article.
After creation of typed data set, to fill and save each data table
corresponding TableAdapter
has to be used due to
strongly typed
nature of the
DataTable
. However, in this CodeProject article
General purpose class to fill DataTable(s) from DataBase and to save DataTable(s) to DataBase using reflection[
^]
a general purpose class is given to read data from database and write data to database
for all tables of the database
using
Type DataSet
.
An example with MS Accesss database
is also given in the article.
I think it may be helpful.