Bind SQL datasource to DropDownList - Extend It! ( Programming in VS2005 & 2008, ASP.Net 2.0 )

Forum General DotNetN... Extend It! ( Pr... Bind SQL datasource to DropDownList

5/11/2008 2:47 AM

	aR
12 posts

Bind SQL datasource to DropDownList

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

mySqlString.Append(

dropdown_Make.DataSource = DataProvider.Instance().ExecuteSQL(mySqlString.ToString())

dropdown_Make.DataBind()

Sub btn_Load_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_Load.ClickDim mySqlString As New StringBuilder()"SELECT testColumn FROM testTable")End Sub

Screenshot is also available:

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

Thanks for the help.

5/11/2008 6:21 AM

	Scott Stokes
108 posts
www.adverageous.com

Re: Bind SQL datasource to DropDownList

Did you set the column names for DataTextField and DataValueField on the Dropdownlist?

Such as:

asp:DropDownList ID="ddAddAdminFolders" runat="server" DataTextField="DefaultTitle" DataValueField="FolderID"></asp:DropDownList>

5/11/2008 7:14 AM

	Paul Scarlett
183 posts
www.tressleworks.ca

Re: Bind SQL datasource to DropDownList

Modified By Paul Scarlett on 5/11/2008 10:15:52 AM)

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.

5/12/2008 6:25 AM

	aR
12 posts

Re: Bind SQL datasource to DropDownList

Scott Stokes wrote

Did you set the column names for DataTextField and DataValueField on the Dropdownlist?

Such as:

asp:DropDownList ID="ddAddAdminFolders" runat="server" DataTextField="DefaultTitle" DataValueField="FolderID">asp:DropDownList>

No.

Btw, what does 'DefaultTitle' and 'FolderID' refer to?

Any other ideas?

5/12/2008 6:43 AM

	aR
12 posts

Re: Bind SQL datasource to DropDownList

Please ignore my previous post.

Resolved.

Thanks to Scott for pointing out the problem :).

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

Page 1 of 1

Forum

General DotNetN...

Extend It! ( Pr...

Bind SQL datasource to DropDownList