Ad:

ASP.NET Discussion Thread
Unsolved
Views: 24901

Feb 19th, 2008

Populate DropDown List from Sql Database

Expand Post »

I am trying to populate a drop downlist on my page with data in flightnum from the table Air_Flight, my dropdownlist keeps having System.Data.Datarow in the dropdownlist. Im pretty sure im one line of code away from getting the actual values in the dropdownlist, I am just not sure which line of code it is. Also the dropdownlist sees how many records are in the db. For instance if i have the flight numbers '123' , '987', '487' it will have 3 System.Data.Datarow line in the dropdownlist and if I had another flight_num it will then have 4 System.Data.Datarow in the dropdownlist.

ASP.NET Syntax (Toggle Plain Text)
sql = "Select flightnum from Air_flight"
        ddlflightnum.DataSource = objdb.getDataSet(sql)
        ddlflightnum.DataBind()
sql = "Select flightnum from Air_flight"
        ddlflightnum.DataSource = objdb.getDataSet(sql)
        ddlflightnum.DataBind()

Any help is appreciated!

Similar Threads

Populating & Retrieving Data in a listbox : ASP.NET (w/ VB.NET) in ASP.NET
Using Code 5 System to create forms...I got 3 problems in PHP
Using Code 5 System to create forms...I got 3 problems in ASP.NET
Using Code 5 System to create forms...I got 3 problems in JavaScript / DHTML / AJAX

firebirds98

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

15 posts
since Feb 2008

Permalink

Feb 19th, 2008

-1

Re: Populate DropDown List from Sql Database

Please Delete this thread I figured it out I needed the line of code

ddlflightnum.DataValueField = "flightnum"

firebirds98

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

15 posts
since Feb 2008

Permalink

Feb 19th, 2008

Re: Populate DropDown List from Sql Database

Yup, you cannot populate a DropDownList like that. Code for that is as follows:

ASP.NET Syntax (Toggle Plain Text)
Dim conn As New SqlConnection( connection )
Dim cmdSelect As New SqlCommand( ""Select flightnum from Air_flight", conn )
Dim dtrReader As SqlDataReader
 
Try
  conn.Open()
 
  dtrReader = cmdSelect.ExecuteReader()
 
  if dtrReader.HasRows then
    ddlflightnum.DataSource = dtrReader
    ddlflightnum.DataValueField = "flightnum"
    ddlflightnum.DataTextField = "flightnum"
    ddlflightnum.DataBind()
  end if
 
  dtrReader.Close()
  conn.Close()
Catch
End Try
 
Dim conn As New SqlConnection( connection )
Dim cmdSelect As New SqlCommand( ""Select flightnum from Air_flight", conn )
Dim dtrReader As SqlDataReader

Try
  conn.Open()

  dtrReader = cmdSelect.ExecuteReader()

  if dtrReader.HasRows then
    ddlflightnum.DataSource = dtrReader
    ddlflightnum.DataValueField = "flightnum"
    ddlflightnum.DataTextField = "flightnum"
    ddlflightnum.DataBind()
  end if

  dtrReader.Close()
  conn.Close()
Catch
End Try

Now if you do not specify DataTextField, it will default to the DataValueField.

You can populate it through a dataset how you were as well, but I would try to steer you away from datasets as it takes up a lot of resources and the above code is much more efficient.

SheSaidImaPregy

Reputation Points: 43

Solved Threads: 68

Veteran Poster

Offline

1,080 posts
since Sep 2007

Permalink

Feb 20th, 2008

Re: Populate DropDown List from Sql Database

hi firebirds98,
You can populate DropDownlList from Sql database as follows.

connection_object.start_connection()
datareader_object = connection_object.executequery("SELECT city_name from City")
DropDownList1.Items.Clear()
While dr.Read
DropDownList1.Items.Add(dr(0))
End While
dr.Close()
connection_object.close_connection()

Hope this will help you.
Thanks & Regards
Dilipv

dilipv

Reputation Points: 10

Solved Threads: 4

Light Poster

Offline

30 posts
since Feb 2008

Permalink

Aug 5th, 2011

Re: Populate DropDown List from Sql Database

Click to Expand / Collapse Quote originally posted by firebirds98 ...

Please Delete this thread I figured it out I needed the line of code

ddlflightnum.DataValueField = "flightnum"

Delete? you should mark it as solved since you've got the right thing

Netcode

Reputation Points: 43

Solved Threads: 67

Veteran Poster

Offline

1,014 posts
since Jun 2009

Permalink

Aug 5th, 2011

Re: Populate DropDown List from Sql Database

This thread was from 2008 and was only resurrected by someone promoting their blog. That post has been deleted and I am closing this thread to prevent any further confusion.

Ezzaral

Moderator

Featured Poster

Reputation Points: 3239

Solved Threads: 839

Posting Genius

Offline

6,761 posts
since May 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

This thread is currently closed and is not accepting any new replies.

Previous Thread in ASP.NET Forum Timeline: insert,update,delete & select

Next Thread in ASP.NET Forum Timeline: how to handle the database when multiusers are inserting data at same time

DaniWeb Message

Cancel Changes

User Name
Password