Error in DropDownList using ASP.NET

Question

I have a DropDownList called (DDL) in ASP.net page, I want that DDL contains some records of a table in the data base.

So I did this :

DDL.DataSource = myDataReader

DDL.DataBind()

But it's giving me (5 records) "the number of records of the table" but like this :

System.Data.Common.DataRecordInternel
System.Data.Common.DataRecordInternel
System.Data.Common.DataRecordInternel
System.Data.Common.DataRecordInternel
System.Data.Common.DataRecordInternel

score 4 · Accepted Answer · answered May 27 '10 at 13:23

You should set DataTextField and DataValueField, otherwise data binding will perform .ToString() on every row and put it as item:

DDL.DataSource = myDataReader;
DDL.DataTextField = "[Text column name]";
DDL.DataValueField = "[Value column name]";
DDL.DataBind();

score 0 · Answer 2 · answered May 27 '10 at 13:21

0

you have to set the text and the key fields of the ddl before you databind

DDL.DataTextField = "textColumn";
DDL.DataValueField = "textColumn":

answered May 27 '10 at 13:21

derek

4,826
1
23
26

score 0 · Answer 3 · edited Nov 28 '12 at 08:49

0

The code : ddl.datasource=reader is just setting the content present in reader (array of columns of table) as the main source of data.
Now as ddl show only a single column in it so u need to write a piece of code which tells ddl that which column it has to display.
So you will write: ddl.textfield="column name which you want to show"; and ddl.valuefield="column name which you want as a reference to pass to database";

edited Nov 28 '12 at 08:49

Echilon

10,064
33
131
217

answered Mar 02 '11 at 15:36

amarjeet singh

1

Just FYI, you're answering a year-old question, and your answer duplicates the accepted answer. :) – Andomar Mar 03 '11 at 06:37

Error in DropDownList using ASP.NET

3 Answers3