mdb file in resource folder

Question

Hi
I had one .mdb file and I want to put it in resource.resx foler.I want to know how to retrive data from it.

I know how to deal with text file but for mdb file if we use oledb connection string then how to give datasource path..?

Bechir Bejaoui · Answer

Normally we use the ResourceManager.GetObject() method to deal with objects other than strings ResourceManager rm = new ResorceManager (typeOf(myObject)); then myObject = (myObject)rm.GetObject(); But In your case I think that it isnt a good idea to embed an access database witin a resx file beaucause in order to deal with your mdb file. You have to install the Visual tools for office inorder to have the possibility to define an access dataBase type and so forth. It costs a lot in term of code and time. It should be better to store the connection string into a resx file rather than stroing the entire dbase.