From: "V G" <x.solarwind.x@gmail.com>
> Very simple question: Every time my "Search" button is pressed in the
> program, should I create (and close at the end) a new database connection=
?
> Is this good programming practice? Or should I have one open database
> connection for the lifetime (while the program is open) of the program an=
d
> execute multiple queries (in sequence) from that single connection?

The .NET "way" seems to be creating connections on demand.

I don't like that and tend to create a connection up front and use it=20
multiple times.

However, for the type of application you are writing I would do whatever is=
=20
easiest. That would probably be doing it the .NET way and creating=20
connections as needed.

-- Bob Ammerman
RAm Systems

--=20
http://www.piclist.com PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist
.