How to insert image into sql server 2000

[foocc]

Hi there everyone,

I wanna ask how do i insert an image into sql server 2000, and then retrieve it using a gridview in asp.net 2005?

Please help. Many thanks.

[dip_developer]

Hi there everyone,

I wanna ask how do i insert an image into sql server 2000, and then retrieve it using a gridview in asp.net 2005?

Please help. Many thanks.

see this...hope it helps,....

http://chiragrdarji.wordpress.com/20...in-sql-server/

[rameshcse2005]

First u should upload a image & save the image name in Database table

and retrieve by mapping the path in grid view ....


For example .....

1 . Name the images & upload that images into Folder "UploadedImages" ,

2. Save the images name in Database table

3. while retrieving follow the step below ...

<asp:TemplateField>
<ItemTemplate>

<asp:Image ID="img" runat="server" AlternateText="Image Not Available" ImageUrl='<%# "UploadedImages/" + Eval("Image") %>' Width="125" Height="125"/><br /><br />

</ItemTemplate>
</asp:TemplateField>


hope this w'l help u .....