web.config and connections

[CookieNZ]

I am trying to use a web.config file to set the connection.

Dim cs As ConnectionStringSettings
cs = ConfigurationManager.ConnectionStrings("publicconnection")

Dim cn As New SqlConnection(cs.ConnectionString)

Dim myadapter As New SqlDataAdapter("select * from mainjobdetails", cs)
Dim mydataset As New DataSet

myadapter.Fill(mydataset, "Mydataset")

dbox1.datasource = mydataset.Tables(0).DefaultView
dbox1.databind()

However, I get an error when declaring the myadapter. VWB2005 gives an overload resolution error.

Any thoughts?

 

[ManicCW]

Replace this:

Dim myadapter AsNew SqlDataAdapter("select * from mainjobdetails", cs)

With this:

Dim myadapter AsNew SqlDataAdapter("select * from mainjobdetails", cn)

you use connection not connection string for dataadapter.