I have a database of products, each product is in a category. When I go to edit the products I&#039;ve got a dropdown list which has all the categories listed - this list comes from another database table. How do I get set the selected item of the dropdown to the cat_id of the product?<BR><BR>I&#039;m using a datareader to get the product details and have used a dataadapter for the dropdown but I&#039;m not sure if this is the right way to do it.<BR><BR>On the same page I&#039;ve also got 2 radio buttons and I also need to set this according to what is in the products database. I&#039;ve tried using the following code but it&#039;s not working:<BR><BR>If dtrSub("prod_status") = "active" Then<BR>radActive.Checked = True<BR>End If<BR><BR>If dtrSub("prod_status") = "pending" Then<BR>radPend.Checked = True<BR>End If<BR><BR>Regardless of what is in the database field, the first item is always selected. Any ideas?