how to retrieve selected value of dropdownlist filled from datasource in asp.net

[Neerav shah]

How to retrieve selected value of dropdownlist filled from datasource in asp.net?

        Dim str1 As String = "SELECT UserName FROM Login WHERE Category = 'Property'"
        Dim cmd1 As New SqlCommand(str1, conn)
        Dim myreader1 As SqlDataReader
        conn.Open()
 
        myreader1 = cmd1.ExecuteReader()
 
        DDLCat.DataSource = myreader1
 
        DDLCat.DataValueField = "UserName"
 
        DDLCat.DataTextField = myreader1.ToString()
 
        DDLCat.DataBind()
 
 
        conn.Close()

[aspdotnetuser]

DataValueField and DataTextField are distinguished incase to have different values for display and selection.

In your case both can be same since you dont expect other than the value from ddl..moreover you have not queried any other column values from database to bind against "UserName"..

DDLCat.DataValueField = "UserName"
DDLCat.DataTextField = "UserName"