How to equate a database record set value to a drop down list in asp

Sir,
here i am creating a shopping cart taking the value from the msaccess database like proid, name, descri.etc i am able to equate record set value ie rs(0) to a check box and i would like to ask you how to equate the same rs(0) to the drop down list box.
Please help me soon sir..
thank you

I) If u want to populate ur dropdown with reordset then use:-
this is an examle where i populate poduct names into dropdown and use product id to any particular option's value.
<select name="product">
<option value="">-----------------</option>
<%Do while not rs.eof %>
<option value="<%=rs("ProductID")%>"><%=rs("ProductName")%></option>
<%
rs.movenext
Loop
%>
</select>

II) if u want to show any particular option selected onload then two options:
First is using vbscript only:-
use if statement
<select name="product">
<option value="">-----------------</option>
<%Do while not rs.eof %>
<% if strprodid = rs("ProductId") then %>
<option value="<%=rs("ProductID")%>" selected>
<%=rs("ProductName")%>
</option>
<% else %>
<option value="<%=rs("ProductID")%>">
<%=rs("ProductName")%>
</option>
<%
end if
rs.movenext
Loop
%>
</select>

where strprodid contains product id which u want to select.it could be dynamically sent through querystring.

Secondly it could be done thro' javascript

function onload()
{
var i;
var ind = document.frm.productid.value;
for (i=0;i<document.frm.product.length;i++)
{
if(document.frm.product.options[i].value == ind)
{
document.frm.product.options[i].selected = true;
}
}
}
this function could be called at the loading of page in body tag.
here productid is hidden text box containing dynamic value

i hope this information willl be useful