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.
Submit an article or tip