Help Questions | Solutions | Experts

Select Categories Below

.net [

]

Bluetooth [

]

browsers [

]

C# [

]

computer [

]

Errors [

]

forms [

]

HTML [

]

information tec... [

]

internet [

]

Start Your Own Q&A Site

Create your own Q&A site easily, allowing you to quickly grow a new community around any subject matter or generate new organic traffic for your existing website.

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:

Databases Websites
asp web development
database

Answer Discussion

Tutorials

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 a Tutorial in the Tutorial 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 tutorials have been submitted yet. Want to be the first?