initialization problem

[Greg]

Hi,

This code gives the error: "The ConnectionString property has not been
initialized" in the line : d.Fill(ds).
The sConnectionString is defined in web.config and refers to a sqlserver mdf
file.

Imports System.Data
Imports System.Data.SqlClient
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Handles Me.Load

Dim d As SqlDataAdapter
Dim ds As DataSet
Dim sql As String
Dim sConnectionString As String
sConnectionString =
System.Configuration.ConfigurationManager.AppSetti ngs("prod")

sql = "SELECT * FROM [mytable]"
d = New SqlDataAdapter(sql, sConnectionString)
ds = New DataSet()
d.Fill(ds)
Any idea what's wrong? I cant find my error.
Thanks
Greg

[Greg]

I found it: the string is wrong:
sConnectionString =
System.Configuration.ConfigurationManager.Connecti onStrings("prod").ToString()

"Greg" <fe*@dqsd.gbschreef in bericht
news:eM**************@TK2MSFTNGP04.phx.gbl...

Hi,

This code gives the error: "The ConnectionString property has not been
initialized" in the line : d.Fill(ds).
The sConnectionString is defined in web.config and refers to a sqlserver
mdf file.

Imports System.Data
Imports System.Data.SqlClient
Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Me.Load

Dim d As SqlDataAdapter
Dim ds As DataSet
Dim sql As String
Dim sConnectionString As String
sConnectionString =
System.Configuration.ConfigurationManager.AppSetti ngs("prod")

sql = "SELECT * FROM [mytable]"
d = New SqlDataAdapter(sql, sConnectionString)
ds = New DataSet()
d.Fill(ds)
Any idea what's wrong? I cant find my error.
Thanks
Greg