troubleshooting Question

MS VS-2005 DropDownList Value

Avatar of Mehram
MehramFlag for Pakistan asked on
Visual Basic.NET
1 Comment1 Solution189 ViewsLast Modified:
I am using DropDownList in webpage and coding following text which is not working:

        Dim AD As System.Data.SqlClient.SqlDataAdapter
        Dim DS As New System.Data.DataSet
        AD = New SqlClient.SqlDataAdapter("select distinct DischargingPoint from supreme_rate order by dischargingpoint asc", cnString)
        AD.Fill(DS, "supreme_rate")

        With DDDP
            .DataSource = DS.Tables("Supreme_rate ")
            .DataTextField = "dischargingPoint"
            .DataValueField = "dischargingPoint"
        End With

Ajay Sharma

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros