ExecuteReader: Connection property has not been initialized

[MattB]

I'm trying to implement an example I found for displaying images stored in a
SQL database. The example code looks like this (in page_load):

Dim connstr As String = "Integrated Security=SSPI;Initial
Catalog=Northwind;Data Source=SERVER\netsdk"
Dim cnn As New SqlConnection(connstr)
Dim cmd As New SqlCommand
("select * from images where id=" & Request.QueryString("id"), cnn)
cnn.Open()
Dim dr As SqlDataReader = cmd.ExecuteReader()
dr.Read()
Dim bindata() As Byte = dr.GetValue(1)
Response.BinaryWrite(bindata)

I modified the connect string and query to fit my environment and ran the
page. I get that "ExecuteReader: Connection property has not been
initialized" error on this line: Dim dr As SqlDataReader =
cmd.ExecuteReader().

Can anyone tell me why or how to fix it? Thanks!

Matt

 

[Mark Fitzpatrick]

You created the connection objects and the command object, but you need to
set the connection property of the command object to equal your connection.
Otherwise, the command object has no knowledge about the connection.

cmd.Connection = cnn
cmd.Connection.Open()

that's the C# format but you should be able turn it into VB easily.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

 

[MattB]

Thanks!

You created the connection objects and the command object, but you
need to set the connection property of the command object to equal
your connection. Otherwise, the command object has no knowledge about
the connection.

cmd.Connection = cnn
cmd.Connection.Open()

that's the C# format but you should be able turn it into VB easily.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

 

[nada111]

Connection property has not been initialized

SelectCommand.Connection property has not been initialized.