How to save & Retrive Images using linq to sql
In this article i will try to explain you that how to save image in database and then how to retrieve it using linq query.In this method we save image in A folder and image name in database also.You can also bind this image in gridview.
We all know that there is lot's of methods for save and retrieve images,but all method contain different logic behind,
If we want to save&retrieve image then we can do this with 2 methods,
1)We simply save image(imageurl) in database and simply retrieve it in image control of asp.net
2)We save image in a folder then retrieve that image
there is also a mix way i given ,which is simple,
I use both method,we save image name in database and save image in a folder
So this way we save&retrieve image.
Here is the simply code for that.
Here evenementen is the folder name where image is saved
for upload image use this control
<asp:FileUpload ID="fuBanner" runat="server" >
Save image in database.
EventBL r = new EventBL();
var path=Server.MapPath("Images/" + fuBanner.FileName);
fuBanner.SaveAs(path);
r.Banner_SignUp_Page = fuBanner.FileName;
So Now image name is stored in database,In database only imagename is saved.
For retrieve image.put this code into .aspx file
<asp:Image ID="Image1" runat="server"
style="width: 500px; height: 400px; border:1px;" onload="Image_OnLoad" />
put this code into .cs file
protected void Page_Load(object sender, EventArgs e)
{
EventManagerDataContext db = new EventManagerDataContext();
var result1 = from a in db.EMR_INVITATIONs
join b in db.EMR_EVENTs on a.EventID equals b.EventID
where b.EventID == (int)Session["eventid"]
select new
{
Banner =b.Banner_SignUp_Page
};
var ev = result1.First();
Image1.ImageUrl = "~/evenementen/Images/" + ev.Banner;
protected void Image_OnLoad(object sender, EventArgs e)
{
EventManagerDataContext db = new EventManagerDataContext();
var result1 = from a in db.EMR_INVITATIONs
join b in db.EMR_EVENTs on a.EventID equals b.EventID
where b.EventID == (int)Session["eventid"]
select new
{
Banner = b.Banner_SignUp_Page
};
var ev = result1.First();
Image1.ImageUrl = "~/evenementen/Images/" + ev.Banner;
// Image1.ImageUrl = Server.MapPath("~/evenementen/Images/" + ev.Banner);
}
So using this code we can simply save and retrieve image.
I hope you Enjoy it ,if any query then please let me know
Thanks&Regards,
Ketan Italiya