将下拉列表绑定到SQLDataSource

Question

我在努力将下拉列表绑定到数据源。请参阅下面的代码：

Private _ConString As String 

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load 
     _ConString = ConfigurationManager.ConnectionStrings("GeniedbConnection").ConnectionString 
     SqlDataSourceNicheDuplicates.ConnectionString = _ConString 
     SqlDataSourceCreatedDate.ConnectionString = _ConString 
     SqlDataSourceCreatedDate.SelectCommand = "SELECT dateadded distinct convert(varchar,dateadded,103) as dateadded dbNicheDuplicates" 
     DDLCreatedDate.DataTextField = "dateadded" 
     DDLCreatedDate.DataValueField = "dateadded" 
     DDLCreatedDate.DataBind() 
end sub 

如果我在SQL Studio Manager中运行SQL语句，那么会返回许多结果。我究竟做错了什么？

我花了一些时间用谷歌搜索这个。例如，我看着这个问题：Populating an ASP.Net DropDownList using VB.Net coding in code-behind file

Answer 1

只需将更多的信息添加到lincolnk's的答案。您需要这样做 - DDLCreatedDate.DataSource = SqlDataSourceCreatedDate;

SqlDataSourceCreatedDate.SelectCommand = "SELECT dateadded distinct convert(varchar,dateadded,103) as dateadded dbNicheDuplicates" 
DDLCreatedDate.DataSource = SqlDataSourceCreatedDate; 
DDLCreatedDate.DataTextField = "dateadded" 
DDLCreatedDate.DataValueField = "dateadded" 
DDLCreatedDate.DataBind() 

Answer 2

您未设置DataSource。

DDLCreatedDate.DataSource = <results> 
DDLCreatedDate.DataBind() 

你没有列出你的工作对象的类型，所以我不确定缺少的语句到底是什么。