Hi all,

Totally off topic, but I'm writing a desktop program (in Visual C# for MS
SQL Server 2005, of all things), for a client who needs to search his
already existing database. Basically a search program for his database that
will present various import/export functions, search parameters, etc.

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 and
execute multiple queries (in sequence) from that single connection?

I know it doesn't *really* matter, but, you know, principles...
--=20
http://www.piclist.com PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist
.