SqlDataSource refusing to cooperate

Question

I'm trying to populate a drop down list with data from an SQL database but I fail miserably. Code seems ok to me but refuses to work.

   SqlDataSource sql_Names = new SqlDataSource(WebConfigurationManager.ConnectionStrings[1].ConnectionString, "SELECT name FROM Names");
            sql_Names.DataSourceMode = SqlDataSourceMode.DataReader;
            ddl_names.DataSource = sql_Names;
            ddl_names.DataBind();

The database connection is working. It creates the right amount of entries (same as the number of rows in the DB) in the drop down list but insted of the values it fills every element of the list with "System.Data.DataRecordInternal" (or "System.Data.DataRowView" if the mode is set to DataSet).

Please help...

Ta01 · Accepted Answer · 2011-01-07 20:28:02Z

3

You need to set the DataTextField and DataValueFields appropriately

try

ddl_names.DataTextField = "name";
ddl_names.DataValueField = "name";

before the databind

answered Jan 7, 2011 at 20:28

Ta01

31.7k13 gold badges74 silver badges100 bronze badges

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

Comments

theChrisKent · Accepted Answer · 2011-01-07 20:28:08Z

1

you need to set the ddl_names.DataTextField and ddl_names.DataValueField properties. So your final code should look like this:

SqlDataSource sql_Names = new SqlDataSource(WebConfigurationManager.ConnectionStrings[1].ConnectionString, "SELECT name FROM Names");
sql_Names.DataSourceMode = SqlDataSourceMode.DataReader;
ddl_names.DataTextField = "name";
ddl_names.DataValueField = "name";
ddl_names.DataSource = sql_Names;
ddl_names.DataBind();

answered Jan 7, 2011 at 20:28

theChrisKent

15.1k3 gold badges64 silver badges62 bronze badges

Collectives™ on Stack Overflow

SqlDataSource refusing to cooperate

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related