Load picture from SQL database asp.net C#

Question

I have avatars stored in a database. I have used the the data type image for the avatars. I want to load the avatar of a user into an image control, but i cant get it to work. I have tried this code without any luck:

public void GetUserAvatar()
    {
        string username = Convert.ToString(Session["username"]);

        var image = from u in dc.Users
                    where u.username == username
                    select u.image;
        imgAvatar.Controls.Add(image);
    }

I think i might have to save the images to a folder and then save the file path in the database instead. This seems to be easier and smoother. Any ideas?

I ended up saving the image to a folder and then saving the path to the database. My code for image uploading now looks like this:

public void addImage()
    {
        if (fuAvatar.PostedFile.ContentType.ToLower().StartsWith
            ("image") && fuAvatar.HasFile)
        {
            string saveLocation = Server.MapPath("savedAvatars/");
            string fileExtension = System.IO.Path.GetExtension(fuAvatar.FileName);
            string fileName = Convert.ToString(Session["userid"]);
            string savePath = saveLocation + fileName + fileExtension;
            fuAvatar.SaveAs(savePath);

            string imageDBPath = fileName + fileExtension;

            LinqClass1DataContext dc = new LinqClass1DataContext();
            int userid = Convert.ToInt32(Session["userid"]);
            var tblUser = (from u in dc.Users
                           where u.userid == userid
                           select u).First();
            tblUser.imagePath = @"\savedAvatars\"+imageDBPath;
            dc.SubmitChanges();
            lblResult.Text = "Avatar lastet opp!";
        }
        else lblResult.Text = "Avatar ikke lastet opp!";
    }

And to load the picture:

public void GetUserAvatar()
   {
       int userid = Convert.ToInt32(Session["userid"]);

       var varPath = dc.Users.Single(u => (u.userid == userid)).imagePath;

       string imagePath = Convert.ToString(varPath);
       imgAvatar.ImageUrl = imagePath;
   }

Any reason as to why you are storing the actual image in the database? Surely storing a file path would be better? — Neil Knight
– Neil Knight, Commented Mar 27, 2012 at 8:40

Alex · Accepted Answer · 2012-03-27 08:43:55Z

3

you should add a generic handler file (.ashx) and write in it something like that:

string sql = "select image from table1";
SqlCommand command = new SqlCommand(sql, con);
SqlDataReader dReader = command.ExecuteReader();
dReader.Read();
context.Response.BinaryWrite((byte[])dReader["Source"]);
dReader.Close();

then in your page do something like this:

img.ImageUrl = "Handler.ashx;

answered Mar 27, 2012 at 8:43

Alex

6,18913 gold badges46 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Twistar Over a year ago

Do I have to create a new method in this file or can I just use the public void ProcessRequest(HttpContext context)?

Alex Over a year ago

you don't need to create a new method, actually you should use the ProcessRequest method :)

lko Over a year ago

A little more info can be found here: codeproject.com/Articles/33310/…

Adrian Iftode · Accepted Answer · 2012-03-27 08:45:50Z

0

http://www.dotnetcurry.com/ShowArticle.aspx?ID=129 read this article, first I've found. Basically you need to create a handler which responds with the raw image.

answered Mar 27, 2012 at 8:45

Adrian Iftode

15.7k4 gold badges51 silver badges73 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 11:48:50Z

0

Please find the answer in below link.

Get images from database using Handler

You will have to create a handler which will load the image and u can pass the source to image tag.

edited May 23, 2017 at 11:48

CommunityBot

11 silver badge

answered Mar 27, 2012 at 8:49

Murtaza

3,0752 gold badges28 silver badges39 bronze badges

Collectives™ on Stack Overflow

Load picture from SQL database asp.net C#

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related