DropDownList binding to SQL query

[bencooke]

Hi there,

I have a dropdownlist at the top pf my page I wish to be populated so that all the values are a particular column from my SQL query and all the text valeus ie what the user sees are from another column.

I have set up the connetion and a datatable ok, i think but am having problems. my code:



Dim myTable As New DataTable("myContactsTable")
Dim myOtherTable As New DataTable("myDDLTable")
objDataSet.Tables.Add(myTable)
objDataSet.Tables.Add(myOtherTable)

myContacts.DataSource = objDataSet.Tables("myContacts")
myContacts.DataBind()

myDDL.DataSource = myOtherTable
myDDL.DataBind()

... then later on :

<asp:DropDownList id="myDDL" runat="server"
DataValueField='Container.DataItem("countryCode")'
DataTextField='Container.DataItem("country")'
AutoPostBack="True">

</asp:DropDownList>


All I get is a blank dropdown list on the page :( can anyone help me?

thanks,

beNcooKe

[Trunks]

<asp:DropDownList id="myDDL" runat="server"
DataValueField="countryCode"
DataTextField="country"
AutoPostBack="True">

</asp:DropDownList>


Try that

[bencooke]

Thanks,

I just tried that but i get the same problem,

any other help?

beN

[pvb]

These need to be included before you call the DataBind method:
myContacts.DataTextField = "TheFieldYouWantDisplayedForTheOption"
myContacts.DataValueField = "TheFieldUsedAsTheValueForTheOption"