<div>
Here's a sample:<br />
<br />
Dim rsList as ADODB.Recordset<br />
<br />
Set rsList = new ADODB.Recordset<br />
<br />
With rsList<br />
.Open &quot;SELECT CompanyName FROM Customers&quot;, &quot;PROVIDER=SQLOLEDB;Integra<wbr />ted Security=SSPI;DATABASE=Nor<wbr />thwind;SER<wbr />VER=(local<wbr />)&quot;, adOpenForwardOnly, adLockReadOnly, adCmdText<br />
<br />
While Not(.EOF)<br />
lstNames.AddItem .Fields(0).Value<br />
.MoveNext<br />
Wend<br />
End With
</div>


Here's a sample:

Dim rsList as ADODB.Recordset

Set rsList = new ADODB.Recordset

With rsList
.Open "SELECT CompanyName FROM Customers", "PROVIDER=SQLOLEDB;Integrated Security=SSPI;DATABASE=Northwind;SERVER=(local)", adOpenForwardOnly, adLockReadOnly, adCmdText

While Not(.EOF)
lstNames.AddItem .Fields(0).Value
.MoveNext
Wend
End With

<div>
I'm sorry, let me correct my question...i had succeeded to load the database field (Street Name field) into the listbox, i &nbsp;did the random function to the field using SQL statement, but the problem is it was sequential random, what i want is a random result that is different everytime I start the application, and one more problem is i could not put randomize keyword inside the SQL statement, is there anyway to do random function outside the SQL statement but affect the result ot Street Name and put the random result into the listbox ?
</div>


I'm sorry, let me correct my question...i had succeeded to load the database field (Street Name field) into the listbox, i  did the random function to the field using SQL statement, but the problem is it was sequential random, what i want is a random result that is different everytime I start the application, and one more problem is i could not put randomize keyword inside the SQL statement, is there anyway to do random function outside the SQL statement but affect the result ot Street Name and put the random result into the listbox ?

<div>
<div class="content wysiwyg-content">
how can i copy the record (e.g. Street Name field) in the database into the listbox ?
</div>
</div>


how can i copy the record (e.g. Street Name field) in the database into the listbox ?

copy file into listbox

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.