Questions | Solutions | Experts

Select Categories Below

.net [

]

asp.net [

]

browsers [

]

C# [

]

CSS [

]

Databases [

]

email [

]

Errors [

]

HTML [

]

information tec... [

]

Question

Status: Closed Points: 125 Time: 12:16 - Jul 01, 2007

bc030400030

How i load a column values from Database table into dropdown list?

In Asp.NET 2.0 how i load a column from database table into dropdown list? if any one want to help me then please make the code for it i'll be very thankful to him.

Categories:

asp.net database
Databases Websites
asp web development

Answer Discussion

Answer Summaries

Q&A System for Websites and Corporate Collaboration

Generates significant organic traffic for websites
Saves companies money, resources, and time

PeterNZ

Date:: Jul 01, 2007

Time:: 23:56

I found this on the webpage http://www.aspfree.com/c/a/ASP.NET/ASPNE...

Me.DropDownList1.Items.Clear()
Dim da As New SqlDataAdapter("select productID,ProductName from Products", "data source=.;initial catalog=northwind;user id=sa")
Dim ds As New DataSet
da.Fill(ds, "Products")
da.Dispose()
Me.DropDownList1.DataSource = ds.Tables("Products")
Me.DropDownList1.DataTextField = "ProductName"
Me.DropDownList1.DataValueField = "ProductID"
Me.DropDownList1.DataBind()

Hope this helps

Cheers

Peter

bc030400030

Date:: Jul 05, 2007

Time:: 03:42

thanks. it works.

Question Answered

This question has been closed, and points have been rewarded to the following experts:

PeterNZ:

125

You're welcome however to comment or give additional information or if you wish, you have the ability to write an Answer Summary for the Summary Area.

Answer this Question

New User

Email:
Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address

Registered User

Username:

Password:

Forgot Your Password?

No summaries have been submitted yet. Want to be the first?