Hi, can anyone show me a sample database class that suitable for MS Access ? From the book, all database classes is for SQL.

I need a database class that suitable for Access, and then my web
application will use that class to access database.
And maybe in the future, when the database is upgraded to SQL, then I just modify the class instead of update every page to change all Oledb to SQL.

Can anyone help ?

Thanks,
Tee

When you access SQL server you would use the System.Data.SQLClient namespace, as it seems you are aware. When you access Access you would use System.Data.OleDb or System.Data.Odbc namespace. Otherwise it's pretty much the same.

DataSet is not special for MS-SQL & Access has no special DataSet too! There r just a schema to fill. so u just make a DataSet & fill it & its not important what DB u use.
Bye the way u can make DataSet from ur Access DB using VS.NET: Make a connection in Server-Explorer to ur Access DB & Expand it till u reach desired Table, & then drog it to ur DataSet.
HTH.

Always:),
Hovik Melkomian.