How to retrieve an Image from MS SQL Server to bind in Gridview ASP.NET by using LINQ to SQL?

Question

I have a binary file which stores in the customerPicture column that has Image as a datatype in the CUSTOMERs table.

I have saved an image by using this line of code in LINQ to SQL.

Dim db = new MyCompanyDataContext
Dim newCus = new CUSTOMERs
Dim filebyte As Byte() = fileUploader.FileBytes
Dim fileBinary As New System.Data.Linq.Binary(filebyte)
newCus.customerPicture = fileBinary

Then now I want to retrieve this binary file to bind in the gridview in ASP.NET by using LINQ to SQL, but I don't know how. Can you please show me some ways to reach the solution?

Mani · Accepted Answer · 2009-09-25 15:00:08Z

you can use Httphandler to retrive the images from the database.

            <ItemTemplate>
                <asp:Image ID="imgPhoto" runat="server"/>
            </ItemTemplate>

If you have a Image as an ItemTemplate in the datagrid.

In the ItemDataBound event of the datagrid call the "HttpHandler" to display the image.In the below code I am finding the image control and assinging the imageUrl as the HttpHandler file path.I am also passing the id as querystring to the HttpHandlerFile.



        System.Web.UI.WebControls.Image photoImage = (System.Web.UI.WebControls.Image)e.Item.FindControl("imgPhoto");
        photoImage.ImageUrl = "ImageHandler.ashx?PhotoID=" + id.ToString();

And in the HttpHandler file use Linq to retrive the Image and display it.

public void ProcessRequest (HttpContext context) { context.Response.ContentType = "image/jpeg";



    int photoId = -1;
    //Check the query string.
    if (context.Request.QueryString["PhotoId"] != null && context.Request.QueryString["PhotoId"] != "")
    {
        photoId = Convert.ToInt32(context.Request.QueryString["PhotoID"]);
    }

    if (photoId != -1)
    {
        MovieDataContext db = new MovieDataContext();
        //Get the movie record based on the ID
        MovieTable movie = db.MovieTables.First(m => m.ID == photoId);

        System.Data.Linq.Binary fileBinary = movie.Photo;
        byte[] fileByte = fileBinary.ToArray();
        //displays the Image.
        context.Response.BinaryWrite(fileByte);
    }
}

As this HttpHandler file is mapped to the imageURL in the datagrid , you can see the images displayed in the datagrid.

amantur · Accepted Answer · 2009-06-17 07:26:18Z

0

Try this:

dim ms as new MemoryStream
ms.Write(fileBinary.ToArray(),0,fileBinary.Length)

dim img as Image
img = Image.FromStream(ms)

newCus.customerPicture = img

answered Jun 17, 2009 at 7:26

amantur

40.6k22 gold badges136 silver badges192 bronze badges

Collectives™ on Stack Overflow

How to retrieve an Image from MS SQL Server to bind in Gridview ASP.NET by using LINQ to SQL?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related