Image attributes

[Rob T]

I have a page that can upload or display a particular image from a SQL
server....works fine. Data is stored as a binary data type.

I'm looking for a simple way to find out what some of the attributes of the
image are, such has the size, x & y dimensions.

Thanks. -Rob T.

[Kevin Spencer]

You would probably want to load the image into a System.Drawing.Image, and
get these attributes from the properties of the instance.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Rob T" <RT*********@DONTwalchemSPAM.com> wrote in message
news:ON**************@tk2msftngp13.phx.gbl...

I have a page that can upload or display a particular image from a SQL
server....works fine. Data is stored as a binary data type.

I'm looking for a simple way to find out what some of the attributes of the image are, such has the size, x & y dimensions.

Thanks. -Rob T.

[Rob T]

Thanks. I'm not too familiar with playing around with images..is there some
place you can point me to on loading SQL images into a bitmap? Thanks.

PS.
The current code I use to display an image is something like this...

Dim cnnCUS As SqlConnection 'connection to the CUS DB
Dim strSQL As String 'text SQL statement
Dim cmdSQL As SqlCommand 'SQL command
Dim dtrRS As SqlDataReader 'Data reader (record set)

cnnCUS = New SqlConnection(Session("cnnCUS"))

strSQL = "select Img, ImgType from FormImg where ImgID='" &
Request("ImgID") & "'"
cmdSQL = New SqlCommand(strSQL, cnnCUS)
cnnCUS.Open()
dtrRS = cmdSQL.ExecuteReader
If dtrRS.Read = True Then
Response.ContentType = dtrRS.Item("ImgType")
Response.BinaryWrite(dtrRS.Item("Img"))
End If
dtrRS.Close()
cnnCUS.Close()

"Kevin Spencer" <ks******@takempis.com> wrote in message
news:u7**************@tk2msftngp13.phx.gbl...

You would probably want to load the image into a System.Drawing.Image, and
get these attributes from the properties of the instance.

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Rob T" <RT*********@DONTwalchemSPAM.com> wrote in message
news:ON**************@tk2msftngp13.phx.gbl...

I have a page that can upload or display a particular image from a SQL
server....works fine. Data is stored as a binary data type.

I'm looking for a simple way to find out what some of the attributes of

the

image are, such has the size, x & y dimensions.

Thanks. -Rob T.

[Kevin Spencer]

Hi Rob,

I personally have never done this. However, the freely downloadable .Net SDK
should have all the information you need to figure out how:

http://www.microsoft.com/downloads/d...displaylang=en

I read it every day. :-)

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Rob T" <RT*********@DONTwalchemSPAM.com> wrote in message
news:ON*************@TK2MSFTNGP09.phx.gbl...

Thanks. I'm not too familiar with playing around with images..is there some place you can point me to on loading SQL images into a bitmap? Thanks.

PS.
The current code I use to display an image is something like this...

Dim cnnCUS As SqlConnection 'connection to the CUS DB
Dim strSQL As String 'text SQL statement
Dim cmdSQL As SqlCommand 'SQL command
Dim dtrRS As SqlDataReader 'Data reader (record set)

cnnCUS = New SqlConnection(Session("cnnCUS"))

strSQL = "select Img, ImgType from FormImg where ImgID='" &
Request("ImgID") & "'"
cmdSQL = New SqlCommand(strSQL, cnnCUS)
cnnCUS.Open()
dtrRS = cmdSQL.ExecuteReader
If dtrRS.Read = True Then
Response.ContentType = dtrRS.Item("ImgType")
Response.BinaryWrite(dtrRS.Item("Img"))
End If
dtrRS.Close()
cnnCUS.Close()

"Kevin Spencer" <ks******@takempis.com> wrote in message
news:u7**************@tk2msftngp13.phx.gbl...

You would probably want to load the image into a System.Drawing.Image, and get these attributes from the properties of the instance.

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Rob T" <RT*********@DONTwalchemSPAM.com> wrote in message
news:ON**************@tk2msftngp13.phx.gbl...

I have a page that can upload or display a particular image from a SQL
server....works fine. Data is stored as a binary data type.

I'm looking for a simple way to find out what some of the attributes

of the

image are, such has the size, x & y dimensions.

Thanks. -Rob T.