Help with dropdownlist [modified]

[ASPnoob]

Hi, Suppose I have pulled out data from a database into a data reader and load the DropDownList as follows.

Dim ddDR As OdbcDataReader = Nothing
Dim ddOdbcConnection As New OdbcConnection("server=(local);database=[dbname];user id=username;password=password;connection reset=false;connection lifetime=5;min pool size=1;max pool size=50;")
Dim ddOdbcCommand As New OdbcCommand("SELECT * FROM TableName", ddOdbcConnection)
ddOdbcConnection.Open()
ddDR = ddOdbcCommand.ExecuteReader(CommandBehavior.CloseConnection)
DropDownList1.DataSource = ddDR
DropDownList1.DataTextField = "DisplayValueFieldFromDB"
DropDownList1.DataValueField = "DataValueFieldFromDB"
DropDownList1.DataBind()

What I would like to do now is read the Data from the DropDownList. I've read that the values can be retrieved as DropDownList.Items[index] - replace the index with a number, which can go up to the maximum number of data members. I am not sure what the author meant by that could you please explain? Thank you in advance for your help. -- modified at 1:01 Thursday 28th June, 2007

[postmaster programmingknowledge com]

See if following link has any help http://www.programmingknowledge.com/dataControl.aspx[^]