Afternoon-
I'm writing some code for the first time using Asp.net 2.0 to get a datareader to pass some info to labels on my form.

The connectionstring I am using works with everything else, but not with this example. I keep getting the "System.InvalidOperationException: The ConnectionString property has not been initialized" message. What's wrong with my code?:
Thanks!
Sam

Dim strID As String
  strID = Me.ddl_name.SelectedValue

Dim sqlConn As SqlConnection = New SqlConnection(ConfigurationManager.AppSettings.Get ("connectionString"))
Dim cmdSelectRider As SqlCommand
 cmdSelectRider = New SqlCommand("SELECT * from members where [ID]='" & strID.ToString & "'", sqlConn)

sqlConn.Open()
Dim drRider As SqlDataReader
 drRider = cmdSelectRider.ExecuteReader()
        While drRider.Read
            lbl_first_name.Text = drRider("first_name")
            lbl_last_name.Text = drRider("last_name")
        End While

Hi there,

Did you store the connectionstring in the <appSettings> node or in the <connectionStrings> node in the web.config file?

Normally, you would use the connectionStrings section, but your code is accessing the appSettings:

ConfigurationManager.AppSettings.Get("connectionSt ring")

should be something like:

ConfigurationManager.ConnectionStrings("connection String").ConnectionString

Hope this helps,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
While typing this post, I was listening to: Techno Rave Entrance by Blade (From the album: Blade Soundtrack) What's This?

Imar-
Right you are. Works well! I finally figured out that that was what it was, but just couldn't get the syntax right. thanks for the help!
Sam