hi,
   hello, specially to the author of beginning vb.net 2005, i have a little question regarding data connection from vb.net to ms access, in vb.net 2003 you can easily drag and drop the data connection components (data adapter,data set, data connection..etc) on toolbars, in more advance, how can i have a connection from my database in terms of codes. my problem in drag and drop components is when i relocate my database(ms access) to other location the system will search for data source search on previous location. In what way can resolve this by using code, and where ever folder in my project folder place the database the system will find it, thus bin folder should be the right place for databse location?

h@ckerz

__________________
................ h@ckerz ....................
If you can\'t join them.....HACK them
..................................................

Well if you want you can put in your code a default location..if it fails ("Have A TRY/Catch block")then have a Open prompt so, therefore you can search through the drive or even another computer drive (if you are in a LAN) and then set the file and use the location of the new file (your MS access file) to become the new Source connection based on where you just put it in.

Also, you can save the connection string as a setting, then once the user selects a different DB location, the program will update the settings and won't have to continually look for the database.

Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.
Albert Einstein
US (German-born) physicist (1879 - 1955)

can i write a class that will search for my database in current folder.. but how?


................ h@ckerz ....................
If you can't join them.....HACK them
..................................................

Yes. You can easily search for the mdb file in the "current" folder and build your connection string based on the file being there. What part of this are you having problems with?

Woody Z
http://www.learntoprogramnow.com

the thing that i want to do is, i'll a system and make it a installer.... so where ever pc i want to installer the system that i do, i could. i also want to know, what should i do if i were in developing stage im using the directory c:\folder name to locate my mdb, then make it installer.. the thing that i want is, when i install the system in other directory othe than c:\folder name, how could the system look for the mdb if in developing stage im using c:\folder name?

................ h@ckerz ....................
If you can't join them.....HACK them
..................................................