C
csgraham74
Hi Guys,
I am currently building a web aplication in ASP.Net. On the onload
event of a page a have a function to populate the many drop down lists
on my page.
I have one parameter table which stores all the values e.g.
Title,Type,Status,Property,Occupation.
I am using a sql string and then populationg my drop down list
e.g.
strSQLQuery = "SELECT * FROM tbl_Parameters WHERE str_ParamType =
'Status'"
The problem that i am having is how best to populate each drop down
list efficiently as i am constantly opening and closing the connection
for each new sql String.
Can anyone point me in the best (or quickest and most efficinet) way to
populate multiple drop down list.
any thanks appreciated
CG
I am currently building a web aplication in ASP.Net. On the onload
event of a page a have a function to populate the many drop down lists
on my page.
I have one parameter table which stores all the values e.g.
Title,Type,Status,Property,Occupation.
I am using a sql string and then populationg my drop down list
e.g.
strSQLQuery = "SELECT * FROM tbl_Parameters WHERE str_ParamType =
'Status'"
The problem that i am having is how best to populate each drop down
list efficiently as i am constantly opening and closing the connection
for each new sql String.
Can anyone point me in the best (or quickest and most efficinet) way to
populate multiple drop down list.
any thanks appreciated
CG