question about custom controls

[Guest]

hey all,

i was wondering if this was worth doing or what implications might be. if i
had a form that has 6 or more table lookups inside drop down lists would 6
custom controls be a lot of overhead. ( i mean these drop down lists are used
a lot in different places which i think would warrant custom control drop
down lists). and the table lookups are to basically 1 or 2 tables. would that
mean 6 different connections would be open?

just trying to get some ideas.

thanks,
rodchar

 

[Cor Ligthert]

Rodchar,

In dotnet there is not any need to have a connection open for a dropdownlist
and therefore I don't understand the question?

Moreover when we think that an aspnet application is stateless these
dropdownlist can only have 6 datatables in a dataset or even only one with 6
defaultviews when it is about the same database table, and therefore you
make the question even more complicated.

Therefore maybe you can explain it in another way.

Cor

 

[Guest]

well,

what i was thinking was to create a custom control that inherits the drop
down list. then in the custom control i would write the code to connect to
the database and populate the drop down list with proper records all at the
start of run time.

i saw this on a webcast and thought i'd give a try but wasn't sure if 6 of
these would cause some overhead.

 

[Cor Ligthert]

Rodchar,

I would never implement in my control a connection to the database even when
it was only for the connectionpooling.

Just my thought,

Cor

 

[Guest]

thanks Cor.

Rodchar,

I would never implement in my control a connection to the database even when
it was only for the connectionpooling.

Just my thought,

Cor