Link to home
Start Free TrialLog in
Avatar of bskyum
bskyumFlag for Denmark

asked on

Display varbinary(max)

Hello, i made a fileupload in aspx.

when i upload a photo (.jpg or .png) i can see in my database the value of my cell changes from NULL to <binary data>.

When i try to display the data in my gridview <asp:imagefield it display the 'missing picture sign'.

i selected right, and i tried to upload very small pictures, but nothing helps.
<asp:ImageField DataImageUrlField="ComLogo" SortExpression="ComLogo">
                <HeaderStyle Font-Size="20" />
                <ItemStyle CssClass="Discountlogo" Height="100px" Width="100px" />
</asp:ImageField>

Open in new window

Avatar of kswathi
kswathi
Flag of India image

Check your file path while retrieving and saving.
Avatar of bskyum

ASKER

I checked the file path.

If i in my selection string delete aspnet.ComLogo and type 'test', the test is displayed in my column. (I changed the imagefield to a boundfield).

And when i leave the aspnet.ComLogo alone in a boundfield, it displayes:

System.Byte[]
ASKER CERTIFIED SOLUTION
Avatar of Manoj Patil
Manoj Patil
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bskyum

ASKER

i actually haven't wrote anything in my codebehind yet.

I make the sqldatasource in the aspx. and this codeproject is made in aspx.cs