how to Store image in database and display on user account

Question

hi friends, I want to store an image in database and display on user account when user logined.like facebook or other....

Pankaj Pandey · Answer

hello for your solution there is two ways. first store image in a folder and save path of that image regarding that account to database. second one convert image into binary and save it in database and when you are fetching info. regarding account also fetch binary data and convert it into image and show to profile pic. first way is simple and second way is a little standerd way for you i am giving a link which may help you. http://www.c-sharpcorner.com/Blogs/11642/convert-image-into-a-binary-file-and-save-in-txt-file.aspx m ark as answered if helpfull

Rohit Kapdi · Answer

hi Arun, if u want to store the image in the database other then doing the conversion to byte and back from byte. you can simply store the image name in the table name (i.e arun.jpg if the image name arun.jpg) and upload the image on server in a folder and when the that user logs in then u can directly give the link for the image in that folder.

Satyapriya Nayak · Answer

http://www.c-sharpcorner.com/UploadFile/satyapriyanayak/display-username-along-with-photo-after-successful-login/

Anurag Sarkar · Answer

http://www.aspdotnet-suresh.com/2011/01/how-to-insert-images-into-database-and.html http://www.codeproject.com/Articles/9686/Save-An-Image-Into-SQL-Server-2000-Database For checking which image is to be displayed for current user you should set image id for every user.You can check out these two links for help. Thanks

varun vimal sharan · Answer

Don't store the image in your database, it takes lots of space and is costly too. So store the data on your server, and save the link in the database. Convert 'myphoto: to varchar' instead of binary data. you just have to provide the selected data to image.ImageUrl. it really works

Arun Kurmi · Answer

hi friends,thanks but i have found all these reply with gridview.I just successfull to store image as to database but unable to display image on image control when user logined. suppose these are my database then what to do.... table name:user_info id: 101 name: arun e_id: arun.arun@arun.arun myphoto: img_name:tulsi

how to Store image in database and display on user account

Answers (6)