Bind Drop Down List to SQLDataSource

Question

I am struggling to bind a Drop Down List to a Data Source. Please see the code below:

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

If I run the SQL statement in SQL Studio Manager then many results are returned. What am I doing wrong?

I have spent some time Googling this. For example I looked at this question: Populating an ASP.Net DropDownList using VB.Net coding in code-behind file

Community · Accepted Answer · 2017-05-23 11:57:45Z

0

Just adding more info to lincolnk's answer. You need to do this - 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()

edited May 23, 2017 at 11:57

CommunityBot

11 silver badge

answered Nov 3, 2014 at 17:42

Arindam Nayak

7,4904 gold badges36 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

w0051977 Over a year ago

Thanks, but the drop down list is still empty.

Arindam Nayak Over a year ago

@w0051977, are you sure this SQL SELECT dateadded distinct convert(varchar,dateadded,103) as dateadded dbNicheDuplicates is working in management console?

w0051977 Over a year ago

Sorry, my fault. There were two tables: dbNicheDuplicates and dbo.dbNicheDuplicate. dbo.dbNicheDuplicate had no data.

lincolnk · Accepted Answer · 2014-11-03 17:31:02Z

0

You are not setting DataSource.

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

You don't list what type of objects your working with so I'm not sure exactly what the missing statement is.

answered Nov 3, 2014 at 17:31

lincolnk

11.2k4 gold badges43 silver badges63 bronze badges

Collectives™ on Stack Overflow

Bind Drop Down List to SQLDataSource

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related