<div>
<div class="content wysiwyg-content">
I am building a reporting tool. &nbsp;Each report can be filtered by a postcode or multiple postcodes.<br />
<br />
I am successfully populating a multiselect listbox in asp with over 2500 postcodes using the following code<br />
<br />
&lt;SELECT MULTIPLE id=&quot;lstPostcode&quot; name=&quot;lstPostcode&quot; value=&quot;lstPostcode&quot; size=2 onclick=&quot;DeSelectPostcodeC<wbr />hkbox()&quot; style=&quot;HEIGHT: 70px; WIDTH: 80px&quot;&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;%<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Do while not rsPostcode.eof<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Response.Write &quot;&lt;Option Selected Value='&quot; &amp;&nbsp;Trim(rsPostcode(&quot;Postcode&quot;<wbr />)) &amp;&nbsp;&quot;'&gt;&quot; &amp;&nbsp;Trim(rsPostcode(&quot;Postcode&quot;<wbr />)) &amp;&nbsp;&quot;&lt;/Option&gt;&quot; &amp;&nbsp;vbcrlf<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rsPostcode.MoveNext<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;loop<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rspostcode.close<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;%&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/SELECT&gt;<br />
<br />
However it is very slow in the live environment. &nbsp;Is there a quicker way to code this or can someone offer a alternative solution? &nbsp;
</div>
</div>


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
		rsPostcode.MoveNext
	loop
	rspostcode.close
	%>
	 </SELECT>

However it is very slow in the live environment.  Is there a quicker way to code this or can someone offer a alternative solution?  

Quickest method for populating a Listbox in ASP

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.