Hi All,

I am trying to bind data from SQL Server 2005 database to a DropDownList.

But for some reason, instead of displaying the data, the DropDownList displays "System.Data.Common.DataRecordInternal".

Here is the code that I use. I tried the same code to bind the data to GridView and it worked.

Protected

Screenshot is also available:

http://img233.imageshack.us/my.php?image=erroryz6.jpg

Thanks for the help.

Just as an alternative, you may want to consider the module SQLGridSelectedView .. this module allows the user to define dropdown selection to filter primary selects ... very powerful.  A free version exists that provides this functionality -- see www.tressleworks.ca      I have aslo found this module to be a great way to prove SQL commands while creating custom modules. 

Paul.

Please ignore my previous post.

Resolved.

Thanks to Scott for pointing out the problem :).

It is indeed DataTextField="testColumn" that was missing.