New to coding... How to source dropdown list options from SQL query.

Here is the code that I have so far... and it brings in the values from the query, but it displays each value in it's own row of the table instead of just having them as values in the dropdown list of the single row.

@{var db = Database.Open("CARD");
var Vendors = db.Query("SELECT VendorName FROM tbl_Vendors");}
<p style="text-align: center; font-family: verdana; font-size: 20px">Vendor</p>
<table border="1">
<tr bgcolor="beige">
<th>Vendor</th>
</tr>
@foreach (var row in Vendors)
{
<tr bgcolor="#E0E0E0">
<td>

<select id="dropdown" class="select-box" name="Vendor">
<option>@row.VendorName</option>
</select>
</td>
}

Thanks in advance for your help!

James