Quickest method for populating a Listbox in ASP
Posted on 2004-03-29
I am building a reporting tool. Each report can be filtered by a postcode or multiple postcodes.
I am successfully populating a multiselect listbox in asp with over 2500 postcodes using the following code
<SELECT MULTIPLE id="lstPostcode" name="lstPostcode" value="lstPostcode" size=2 onclick="DeSelectPostcodeChkbox()" style="HEIGHT: 70px; WIDTH: 80px">
Do while not rsPostcode.eof
Response.Write "<Option Selected Value='" & Trim(rsPostcode("Postcode")) & "'>" & Trim(rsPostcode("Postcode")) & "</Option>" & vbcrlf
However it is very slow in the live environment. Is there a quicker way to code this or can someone offer a alternative solution?