How to fetch the image from database using linq , where image is stored in byte code in DataBase.

Here we are having a database model as dbtest, where pictures is the
Table name the Column name is img.
There is panel named ImgPanel where we are Getting the images

dbtestEntities db = new dbtestEntities();
var images = from p in db.Pictures
     select Image.FromStream(new MemoryStream(p.img.ToArray());

foreach (Image image in images)
{
    ImgPanel.Controls.Add(image);
}

Comments

Post a Comment

Popular posts from this blog

How to use lamda expression for updating using LINQ

This is small example showing how we use lamda expression in the programming section , Generally we use lamda expression when working wiht LINQ , or the classs of list type where need to get the data based on any where clause. public Boolean Update(string id) { int flag = 0; string str = DateTime.Now.Day + "-" + DateTime.Now.Month + "-" + DateTime.Now.Year; foreach (var c in obj.Task_Details.Where(x => x.task_no == id)) { c.task_date = str; flag = 1; c.status = "Complete"; } obj.SaveChanges(); if (flag == 1) { return true; } else { return false; } }
Read more

using session for login and logout in asp.net

firstly open the "Global.aspx". then create a function there  protected void Application_Start() { //we give the name of the session  here and declare it null ..username is the name of the session //we can change it according to our needs Sesssion["username"]=""; } now we can create the function where we are login as function boolean login( string username, string password) {   // firstly we match the login details from the database. if(username == logincredintialfromdb && password ==logincredintialfromdb ) { // the values are matched here so are assiging the value to the session variable Session["username"]= username ; return true; } else { return false; } }
Read more

How to post data in MVC using form collection for Beginners.

Here we can simply put the data into the form tag and give each component an name .We are creating a login form using the MVC Architecture. <form method="post" action="Name_of_the_function> <input type="text" name=username id=username> <input type="password" name =pass id=pass> <input id=submit type="submit"> on controller [httppost] public ActionResult Name_of_the_function(formcollection form) { string str=form["username"]; string str1= form["pass"]; }
Read more