Dropdown list not working

[Binod Nair]

Hi All,

This is what I am trying to do.I have an aspx page with the the following
code block.

<aspropDownList id="DropDownList1" runat="server" DataSource="<%#
GetUsers%>" DataTextField="user_email" DataValueField="user_id">
</aspropDownList>

GetUsers is defined in the .vb file

Public Function GetUsers() As DataSet

Dim ds As DataSet
ds =
SqlHelper.ExecuteDataset(ConfigurationSettings.AppSettings("ConnectionString
"), CommandType.Text, "select user_id , user_email from users")
Return ds

End Function


I am kind of frustrated that I cannot make this thing work.What am I doing
wrong ?

--binod

 

[Patrick Steele [MVP]]

Hi All,

This is what I am trying to do.I have an aspx page with the the following
code block.

<aspropDownList id="DropDownList1" runat="server" DataSource="<%#
GetUsers%>" DataTextField="user_email" DataValueField="user_id">
</aspropDownList>

GetUsers is defined in the .vb file

Public Function GetUsers() As DataSet

Dim ds As DataSet
ds =
SqlHelper.ExecuteDataset(ConfigurationSettings.AppSettings("ConnectionString
"), CommandType.Text, "select user_id , user_email from users")
Return ds

End Function


I am kind of frustrated that I cannot make this thing work.What am I doing
wrong ?

Are you ever calling DataBind()?