streaming images

[msuk]

All,

I have a ADO.NET dataset that contains a jpeg (blob data) and some fields
that describe the jpeg. I would like to stream the blob data straight to my
ASP.NET 1.1 webform without first saving to disk and display the fields as
labels on the same page is this possible?

Thanks
Msuk

[Eliyahu Goldin]

Provided you have a data reader open on the record and the image field is
the first in the record, all you need is just:

System.Data.Sql Types.SqlBinary image = reader.GetSqlBi nary(0);

if (!image.IsNull && image.Value.Len gth 0)

{

this.Response.C ontentType = "image/gif";

this.Response.B inaryWrite (image.Value);

}

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

"msuk" <ms**@discussio ns.microsoft.co mwrote in message
news:87******** *************** ***********@mic rosoft.com...

All,

I have a ADO.NET dataset that contains a jpeg (blob data) and some fields
that describe the jpeg. I would like to stream the blob data straight to
my
ASP.NET 1.1 webform without first saving to disk and display the fields as
labels on the same page is this possible?

Thanks
Msuk

[msuk]

Hi,

I have a remote component that I call that returns me a Dataset whereby the
first field is the image - will this still work using your method?

Thanks
Msuk

"Eliyahu Goldin" wrote:

Provided you have a data reader open on the record and the image field is
the first in the record, all you need is just:

System.Data.Sql Types.SqlBinary image = reader.GetSqlBi nary(0);

if (!image.IsNull && image.Value.Len gth 0)

{

this.Response.C ontentType = "image/gif";

this.Response.B inaryWrite (image.Value);

}

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

"msuk" <ms**@discussio ns.microsoft.co mwrote in message
news:87******** *************** ***********@mic rosoft.com...

All,

I have a ADO.NET dataset that contains a jpeg (blob data) and some fields
that describe the jpeg. I would like to stream the blob data straight to
my
ASP.NET 1.1 webform without first saving to disk and display the fields as
labels on the same page is this possible?

Thanks
Msuk

[Eliyahu Goldin]

The example shows you how to get binary data to the response stream. It is
up to you how to derive the data.
--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

"msuk" <ms**@discussio ns.microsoft.co mwrote in message
news:88******** *************** ***********@mic rosoft.com...

Hi,

I have a remote component that I call that returns me a Dataset whereby
the
first field is the image - will this still work using your method?

Thanks
Msuk

"Eliyahu Goldin" wrote:

>Provided you have a data reader open on the record and the image field is
the first in the record, all you need is just:

System.Data.Sq lTypes.SqlBinar y image = reader.GetSqlBi nary(0);

if (!image.IsNull && image.Value.Len gth 0)

{

this.Response. ContentType = "image/gif";

this.Response. BinaryWrite (image.Value);

}

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

"msuk" <ms**@discussio ns.microsoft.co mwrote in message
news:87******* *************** ************@mi crosoft.com...

All,

I have a ADO.NET dataset that contains a jpeg (blob data) and some
fields
that describe the jpeg. I would like to stream the blob data straight
to
my
ASP.NET 1.1 webform without first saving to disk and display the fields
as
labels on the same page is this possible?

Thanks
Msuk

[msuk]

Hi,

I am getting a cast error see below

Dim myArt As DataTable
myArt = dsArtWork.Table s("Art")
Dim myRow As DataRow = myArt.Rows(0)

Dim image As SqlBinary
image = myRow("image") ---fails here

Response.Conten tType = "image/jpeg"

Me.Response.Bin aryWrite(image. Value)

Can you please help?

Thanks
"Eliyahu Goldin" wrote:

The example shows you how to get binary data to the response stream. It is
up to you how to derive the data.
--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

"msuk" <ms**@discussio ns.microsoft.co mwrote in message
news:88******** *************** ***********@mic rosoft.com...

Hi,

I have a remote component that I call that returns me a Dataset whereby
the
first field is the image - will this still work using your method?

Thanks
Msuk

"Eliyahu Goldin" wrote:

Provided you have a data reader open on the record and the image field is
the first in the record, all you need is just:

System.Data.Sql Types.SqlBinary image = reader.GetSqlBi nary(0);

if (!image.IsNull && image.Value.Len gth 0)

{

this.Response.C ontentType = "image/gif";

this.Response.B inaryWrite (image.Value);

}

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

"msuk" <ms**@discussio ns.microsoft.co mwrote in message
news:87******** *************** ***********@mic rosoft.com...
All,

I have a ADO.NET dataset that contains a jpeg (blob data) and some
fields
that describe the jpeg. I would like to stream the blob data straight
to
my
ASP.NET 1.1 webform without first saving to disk and display the fields
as
labels on the same page is this possible?

Thanks
Msuk

[Demetri]

image = myRow("image") ---fails here

Why does it fail there? What is the error message?

--
-Demetri
"msuk" wrote:

Hi,

I am getting a cast error see below

Dim myArt As DataTable
myArt = dsArtWork.Table s("Art")
Dim myRow As DataRow = myArt.Rows(0)

Dim image As SqlBinary
image = myRow("image") ---fails here

Response.Conten tType = "image/jpeg"

Me.Response.Bin aryWrite(image. Value)

Can you please help?

Thanks
"Eliyahu Goldin" wrote:

The example shows you how to get binary data to the response stream. It is
up to you how to derive the data.
--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

"msuk" <ms**@discussio ns.microsoft.co mwrote in message
news:88******** *************** ***********@mic rosoft.com...

Hi,
>
I have a remote component that I call that returns me a Dataset whereby
the
first field is the image - will this still work using your method?
>
Thanks
Msuk
>
"Eliyahu Goldin" wrote:
>
>Provided you have a data reader open on the record and the image field is
>the first in the record, all you need is just:
>>
>System.Data.Sq lTypes.SqlBinar y image = reader.GetSqlBi nary(0);
>>
>if (!image.IsNull && image.Value.Len gth 0)
>>
>{
>>
>this.Response. ContentType = "image/gif";
>>
>this.Response. BinaryWrite (image.Value);
>>
>}
>>
>--
>Eliyahu Goldin,
>Software Developer & Consultant
>Microsoft MVP [ASP.NET]
>>
>"msuk" <ms**@discussio ns.microsoft.co mwrote in message
>news:87******* *************** ************@mi crosoft.com...
All,
>
I have a ADO.NET dataset that contains a jpeg (blob data) and some
fields
that describe the jpeg. I would like to stream the blob data straight
to
my
ASP.NET 1.1 webform without first saving to disk and display the fields
as
labels on the same page is this possible?
>
Thanks
Msuk
>>
>>
>>

[Ray Booysen]

Are you sure there is a column in the row called "image"?

msuk wrote:

Hi,

I am getting a cast error see below

Dim myArt As DataTable
myArt = dsArtWork.Table s("Art")
Dim myRow As DataRow = myArt.Rows(0)

Dim image As SqlBinary
image = myRow("image") ---fails here

Response.Conten tType = "image/jpeg"

Me.Response.Bin aryWrite(image. Value)

Can you please help?

Thanks
"Eliyahu Goldin" wrote:

>The example shows you how to get binary data to the response stream. It is
up to you how to derive the data.
--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

"msuk" <ms**@discussio ns.microsoft.co mwrote in message
news:88******* *************** ************@mi crosoft.com...

>>Hi,

I have a remote component that I call that returns me a Dataset whereby
the
first field is the image - will this still work using your method?

Thanks
Msuk

"Eliyahu Goldin" wrote:

Provided you have a data reader open on the record and the image field is
the first in the record, all you need is just:

System.Data. SqlTypes.SqlBin ary image = reader.GetSqlBi nary(0);

if (!image.IsNull && image.Value.Len gth 0)

{

this.Respons e.ContentType = "image/gif";

this.Respons e.BinaryWrite (image.Value);

}

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

"msuk" <ms**@discussio ns.microsoft.co mwrote in message
news:87***** *************** **************@ microsoft.com.. .
All,
>
I have a ADO.NET dataset that contains a jpeg (blob data) and some
fields
that describe the jpeg. I would like to stream the blob data straight
to
my
ASP.NET 1.1 webform without first saving to disk and display the fields
as
labels on the same page is this possible?
>
Thanks
Msuk

[msuk]

All,

This is the error I am getting

Server Error in '/' Application.
--------------------------------------------------------------------------------

Specified cast is not valid.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.InvalidC astException: Specified cast is not valid.

I have checked myRow("image") and it contains an array of bytes.

Any ideas

Thanks
Msuk

"Ray Booysen" wrote:

Are you sure there is a column in the row called "image"?

msuk wrote:

Hi,

I am getting a cast error see below

Dim myArt As DataTable
myArt = dsArtWork.Table s("Art")
Dim myRow As DataRow = myArt.Rows(0)

Dim image As SqlBinary
image = myRow("image") ---fails here

Response.Conten tType = "image/jpeg"

Me.Response.Bin aryWrite(image. Value)

Can you please help?

Thanks
"Eliyahu Goldin" wrote:

The example shows you how to get binary data to the response stream. It is
up to you how to derive the data.
--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

"msuk" <ms**@discussio ns.microsoft.co mwrote in message
news:88******** *************** ***********@mic rosoft.com...
Hi,

I have a remote component that I call that returns me a Dataset whereby
the
first field is the image - will this still work using your method?

Thanks
Msuk

"Eliyahu Goldin" wrote:

Provided you have a data reader open on the record and the image field is
the first in the record, all you need is just:

System.Data.S qlTypes.SqlBina ry image = reader.GetSqlBi nary(0);

if (!image.IsNull && image.Value.Len gth 0)

{

this.Response .ContentType = "image/gif";

this.Response .BinaryWrite (image.Value);

}

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

"msuk" <ms**@discussio ns.microsoft.co mwrote in message
news:87****** *************** *************@m icrosoft.com...
All,

I have a ADO.NET dataset that contains a jpeg (blob data) and some
fields
that describe the jpeg. I would like to stream the blob data straight
to
my
ASP.NET 1.1 webform without first saving to disk and display the fields
as
labels on the same page is this possible?

Thanks
Msuk

[Eliyahu Goldin]

You need to typecast myRow("image") to the type you are reading it into.
--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

"msuk" <ms**@discussio ns.microsoft.co mwrote in message
news:B5******** *************** ***********@mic rosoft.com...

All,

This is the error I am getting

Server Error in '/' Application.
--------------------------------------------------------------------------------

Specified cast is not valid.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about
the error and where it originated in the code.

Exception Details: System.InvalidC astException: Specified cast is not
valid.

I have checked myRow("image") and it contains an array of bytes.

Any ideas

Thanks
Msuk

"Ray Booysen" wrote:

>Are you sure there is a column in the row called "image"?

msuk wrote:

Hi,

I am getting a cast error see below

Dim myArt As DataTable
myArt = dsArtWork.Table s("Art")
Dim myRow As DataRow = myArt.Rows(0)

Dim image As SqlBinary
image = myRow("image") ---fails here

Response.Conten tType = "image/jpeg"

Me.Response.Bin aryWrite(image. Value)

Can you please help?

Thanks
"Eliyahu Goldin" wrote:

The example shows you how to get binary data to the response stream.
It is
up to you how to derive the data.
--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

"msuk" <ms**@discussio ns.microsoft.co mwrote in message
news:88******* *************** ************@mi crosoft.com...
Hi,

I have a remote component that I call that returns me a Dataset
whereby
the
first field is the image - will this still work using your method?

Thanks
Msuk

"Eliyahu Goldin" wrote:

Provided you have a data reader open on the record and the image
field is
the first in the record, all you need is just:

System.Data. SqlTypes.SqlBin ary image = reader.GetSqlBi nary(0);

if (!image.IsNull && image.Value.Len gth 0)

{

this.Respons e.ContentType = "image/gif";

this.Respons e.BinaryWrite (image.Value);

}

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

"msuk" <ms**@discussio ns.microsoft.co mwrote in message
news:87***** *************** **************@ microsoft.com.. .
All,
>
I have a ADO.NET dataset that contains a jpeg (blob data) and some
fields
that describe the jpeg. I would like to stream the blob data
straight
to
my
ASP.NET 1.1 webform without first saving to disk and display the
fields
as
labels on the same page is this possible?
>
Thanks
Msuk

[msuk]

Hi,

I tried the following and still got the same error:

DirectCast(myRo w("image"), SqlTypes.SqlBin ary)

Thanks
Msuk

"msuk" wrote:

All,

This is the error I am getting

Server Error in '/' Application.
--------------------------------------------------------------------------------

Specified cast is not valid.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.InvalidC astException: Specified cast is not valid.

I have checked myRow("image") and it contains an array of bytes.

Any ideas

Thanks
Msuk

"Ray Booysen" wrote:

Are you sure there is a column in the row called "image"?

msuk wrote:

Hi,
>
I am getting a cast error see below
>
Dim myArt As DataTable
myArt = dsArtWork.Table s("Art")
Dim myRow As DataRow = myArt.Rows(0)
>
Dim image As SqlBinary
image = myRow("image") ---fails here
>
Response.Conten tType = "image/jpeg"
>
Me.Response.Bin aryWrite(image. Value)
>
Can you please help?
>
Thanks
"Eliyahu Goldin" wrote:
>
>The example shows you how to get binary data to the response stream. It is
>up to you how to derive the data.
>--
>Eliyahu Goldin,
>Software Developer & Consultant
>Microsoft MVP [ASP.NET]
>>
>"msuk" <ms**@discussio ns.microsoft.co mwrote in message
>news:88******* *************** ************@mi crosoft.com...
>>Hi,
>>>
>>I have a remote component that I call that returns me a Dataset whereby
>>the
>>first field is the image - will this still work using your method?
>>>
>>Thanks
>>Msuk
>>>
>>"Eliyahu Goldin" wrote:
>>>
>>>Provided you have a data reader open on the record and the image field is
>>>the first in the record, all you need is just:
>>>>
>>>System.Data. SqlTypes.SqlBin ary image = reader.GetSqlBi nary(0);
>>>>
>>>if (!image.IsNull && image.Value.Len gth 0)
>>>>
>>>{
>>>>
>>>this.Respons e.ContentType = "image/gif";
>>>>
>>>this.Respons e.BinaryWrite (image.Value);
>>>>
>>>}
>>>>
>>>--
>>>Eliyahu Goldin,
>>>Software Developer & Consultant
>>>Microsoft MVP [ASP.NET]
>>>>
>>>"msuk" <ms**@discussio ns.microsoft.co mwrote in message
>>>news:87***** *************** **************@ microsoft.com.. .
>>>>All,
>>>>>
>>>>I have a ADO.NET dataset that contains a jpeg (blob data) and some
>>>>fields
>>>>that describe the jpeg. I would like to stream the blob data straight
>>>>to
>>>>my
>>>>ASP.NET 1.1 webform without first saving to disk and display the fields
>>>>as
>>>>labels on the same page is this possible?
>>>>>
>>>>Thanks
>>>>Msuk
>>>>
>>>>
>>
>>