Hi,
You have a couple of options here. First you could move the data
to an access database. Access is a file based database which does not
require any database server to be installed.
Sql express is a free version of sql server 2005 which will allow
you to attached a database file to the server. The computer running the
application is required to have sql express installed.
http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/emsqlexcustapp.asp
LINQ is a preview to a new techology to be offered in the next
version of visual basic which will allow you to query classes. You could
create a class which contains all the data in the database and store it in a
file. Understand this is a early beta and there is no guarantee that code
you write now will still work when LINQ is released. Here is a link to info
on LINQ. (I recommend you install betas on virtual pc or virtual server)
http://msdn.microsoft.com/netframework/future/linq/ Ken
--------------------
[quoted text, click to view] "VB.NET" wrote:
> "Ken Tucker [MVP]" <KenTuckerMVP@discussions.microsoft.com> wrote in message
> news:DC2E022E-DE0D-4C84-A0C8-EA43D8FE6CC1@microsoft.com...
> > Hi,
> >
> > If you store the data in random access file you will lose the
> > ability to query the data. I think it might be better to install a copy
> > of
> > mysql on your local machine and making a local copy of the database to
> > work
> > with. My Sql is open source and can be downloaded from dev.mysql.com.
> > Another option is move the database to sql express which is also free from
> > microsoft.
> >
> > Ken
> > ---------------
> >
> > "VB.NET" wrote:
> >
> >> I'm using a mysql database and connecting my vb.net program to the DB
> >> over a
> >> network connection. i would like to bring this data over to a vb.net
> >> random
> >> access file. does anyone know how to convert my DB into a binary file?
> >> and
> >> how to convert my code to use a file instead of the db?
>
> Is there any way to hold data, and do queries on it, but make it file based,
> so the data can be transported w/ the program?
>
>
