Ok, sounds right.
What I'm doing is creating an autocomplete textbox. Each time a character
is typed, I need to check the DB for near matches.
My fear is that opening a connection each time a character is typed is
going to be expensive, so in this case, I'd probably want to keep the
conn open.
What do ya think?
>Absolutely - you'd want to abstract that out into a data access class.
>
>If I recall, you and Bonnie and I (and maybe some others) had a lengthy exchange back around 1/21 or 1/22 of this past January on this subject. (Only reason I remember the specific date is because we were getting pounded with two feet of snow that day!)
>
>Kevin
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people