i created a data entry page and have a dropdownlist. the values would be sent to the next page o be published to a report. how can i convert values inserted with dropdownlists so i can display the text in the datatextfield to be bind with a label

Any idea how this conversion can be done?

Dim objdr As SqlDataReader
            Try
                conn.Open()
                objdr = objCmd4.ExecuteReader()
               dropdownlist.DataSource = objdr
               dropdownlist.DataTextField = "Officename"
                dropdownlist.DataValueField = "OfficeCode"
                dropdownlist.DataBind()
                objdr.Close()
                Dim item As ListItem = New ListItem("choose", "-1")
                Me. dropdownlist.Items.Insert(0, item)
            Catch err As Exception
                Response.Write("error: " & err.Message())
                Response.Redirect("errorpage.aspx")
            Finally
                conn.Close()
            End Try[/SIZE]

the dropdown list get feed form a table and inserted into another tables to do some processing. how can i link these tables to get the string bind to a label or textbox

Are you trying to get the text value of the item selected in the dropdownlist into your label or textbox or are you trying to databind information to a label or textbox?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========

Yes i wanted to get the text value of the selected dropdownlist :

"Officename"

and bind it to a label in the next page... once the user hit the submit button

You will need to use a session value to persist the value to the next page but you would get the value like this:

string foo = dropdownlist.SelectedItem.Text;

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========

thanks 4 the idea mate, but i'm thinking of implementing conversion function on the page something like this:

  Dim myConnection As New SqlConnection("data source=xxxx;initial catalog=xxxx;user id=sa;password=xxxxxx")
        myConnection.Open()
        Dim SQL As String
        SQL = ("SELECT OfficerType FROM OfficerTable where KodOfficer=" & _string & " ")
        Dim myCommand As New SqlCommand(SQL, myConnection)
        Dim myReader As SqlDataReader
        myReader = myCommand.ExecuteReader()
        myReader.Read()
        myConnection.Close()

and then bind them to a string .... something like this:

'dim stringResult as string
'stringResult = myReader(0).ToString

care to show me how to do this?

Well your logic won't change. Instead of _string in your above code use dropdownlist.SelectedItem.Text also, I would use ExecuteScalar() to return your value rather then opening a datareader just to get one value.

Here is an example of using ExecuteScalar()

http://www.aspfree.com/c/a/ASP-Code/...ed-Procedures/



================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========