VB.Net = Save windows form information to a database file. Then double click to open directly?

Question

With VB.net, I'm coding a simple application to get more used to the new .Net format.

I'd like to save all the information to a 'new' database file. Can anyone point me in the right direction as to how to create a database on the fly, once that is done i'll be able to connect to it no problem, but actually creating the file is proving difficult to work out.


Also, with vb.net and the newly created custom file, how can it be made to automatically open that information with the program?

Is there a method in installation to associate the file type with the new program? How can i check when the program loads if a database file has been 'double-clicked' and proceed to load the data?


Any pointers to the right information would be greatly appreciated!


Best regards,

Thomas Meier

I guess, i'm talking about a flat file...

The windows application has many different fields and content etc, then i need to save that to a file that could later be loaded by 'double clicking'. I assumed the easiest way would be to create a mini-database for each unique file, but this may be wrong, if there are alternatives please enlighten me =)

Answer 1

Create a database file?? Shouldn't the database server be doing that for you, or are you talking about creating some kind of flat file? Most database applications don't have to worry about files, they just open a ODBC or similar socket connection to a database server and issue SQL commands at it and let the DB app do all the heavy lifting with the file system...that's their job.

For the auto-open problem...just create a persistance file for your application to keep a memory of where the data it should load comes from and read in this persistance file if it exists. If it doesn't exist assume there is no data.

Answer 2

Prisoner of Old Mother England.
Sorry I can't help you but I liked your name.
I have a dig I'm getting ready to take to the office.
Cheers.