dropdown in fully editable datagrid

[Mike C]

I've been grappling with this for days and hope someone has some suggestions.
I have a datagrid that I'd like to place entirely in edit mode so people
don't have to update data row by row. I've accomplished this but my dropdown
list is no longer bound to the data source. It just defaults to the first
item in the dropdown list source table. Thanks!

<asp:TemplateColumn HeaderText="COMPANY">
<ItemTemplate>
<asp:Label runat="server"
id="lblAccountID"
Visible="False"
Text='<%# DataBinder.Eval(Container.DataItem, "AccountID") %>'/>
<asp:DropDownList id=ddlCompany runat="server"
DataValueField="CompanyID"
DataTextField="CompanyDesc"
OnPreRender="SetDropDownIndex"
DataSource="<%# BindTheCountry() %>"
SelectedIndex='<%# GetSelIndex(Container.DataItem("AccountID")) %>'>
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateColumn>

The BindTheCountry() sub in my code behind (I know, it's named awkwardly) is
below. This is just a lookup table for the dropdown list.

Public Function BindTheCountry()
Dim _SqlConnection As New SqlConnection(strConn)
Dim cmdCustomers As SqlCommand = New SqlCommand("SELECT Statement",
_SqlConnection)
cmdCustomers.CommandType = CommandType.Text
_SqlConnection.Open()
Return cmdCustomers.ExecuteReader(CommandBehavior.CloseCo nnection)
End Function

The data in the SQL table I'm trying to bind to is also in the code behind:
Public Sub BindCompetition(ByVal _ID As String)
Dim _SqlCompetition As String = "SELECT Statement WHERE AccountID =
" & _ID & ""
Dim _Ds As New DataSet
Dim _SqlCompetitionConnection As New SqlConnection(strConn)
Dim _SqlCompetitionCommand As New SqlCommand(_SqlCompetition,
_SqlCompetitionConnection)
Dim _SqlCompetitionDataAdapter As New
SqlDataAdapter(_SqlCompetitionCommand)
_SqlCompetitionConnection.Open()
_SqlCompetitionDataAdapter.Fill(_Ds)
dgCompetitorStatus.DataSource = _Ds
dgCompetitorStatus.DataBind()
End Sub