How we can retrieve the image from the database?

Question

How we can retrieve the image from the database on image button of asp.net page?

when we are enter the emailid and password on the login page, the next page show the user name . i want to display both image and username.

image is stored in the database in image datatype...

Conan Henson · Answer

im little confused by the above code, if you wanna retrieve the image form the database on image button of asp.net page, you can get some template this image processing , good luck.

Satyapriya Nayak · Answer

Stored procedure CREATE PROCEDURE insert_employee ( @UserName varchar(50), @Password varchar(50), @address varchar(50), @image varchar(50) ) AS Insert into employee values(@UserName,@Password,@address,@image) CREATE PROCEDURE update_employee ( @id int, @UserName varchar(50), @address varchar(50) ) AS update employee set UserName=@UserName,address=@address where id=@id CREATE PROCEDURE delete_employee (@id int) AS Delete from employee where id=@id Default.aspx Untitled Page Name ControlToValidate="txt_name" ErrorMessage="Please enter the name"> Password ControlToValidate="txt_password" ErrorMessage="Please enter the password"> Address ControlToValidate="txt_address" ErrorMessage="Please enter the address"> Image ControlToValidate="FileUpload1" ErrorMessage="Please browse the image"> Text="Insert" /> onrowcancelingedit="GridView1_RowCancelingEdit" onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating" onselectedindexchanging="GridView1_SelectedIndexChanging" BackColor="#CC3300" ForeColor="Black"> Text=' '> ' Visible="False"> '> ' Visible="False"> '> '> ' height="50px" width="50px"/> CommandName="Update">Update CommandName="Cancel">Cancel CommandName="Edit">Edit CommandName="Delete" onclientclick="return confirm('Are you sure you want to delete this record')">Delete Login Default.aspx.cs using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; using System.IO; namespace Display_image_username_after_login { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string s1; string path; SqlConnection cnn = new SqlConnection(); SqlCommand com = new SqlCommand(); SqlDataAdapter sqlda; DataTable dt; int id; string name; string address; string image; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { bindgrid(); } } protected void btn_insert_Click(object sender, EventArgs e) { if (FileUpload1.PostedFile.ContentLength > 0) { s1 = Path.GetFileName(FileUpload1.FileName); path = Server.MapPath("images") + "/" + s1; FileUpload1.SaveAs(path); } SqlConnection con = new SqlConnection(strConnString); con.Open(); SqlCommand com = new SqlCommand("insert_employee", con); com.CommandType = CommandType.StoredProcedure; com.Connection = con; com.Parameters.AddWithValue("@UserName", txt_name.Text); com.Parameters.AddWithValue("@Password", txt_password.Text); com.Parameters.AddWithValue("@address", txt_address.Text); com.Parameters.AddWithValue("@image", s1); com.ExecuteNonQuery(); com.Dispose(); bindgrid(); con.Close(); clear(); } private void clear() { txt_name.Text = ""; txt_password.Text = ""; txt_address.Text = ""; } private void bindgrid() { SqlConnection con = new SqlConnection(strConnString); con.Open(); sqlda = new SqlDataAdapter("SELECT * FROM employee ", con); dt = new DataTable(); sqlda.Fill(dt); sqlda.Dispose(); GridView1.DataSource = dt; GridView1.DataBind(); con.Close(); } protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); try { id = Convert.ToInt32(((Label)(GridView1.Rows[e.RowIndex].FindControl("label2"))).Text); SqlCommand com = new SqlCommand("delete_employee", con); com.CommandType = CommandType.StoredProcedure; com.Connection = con; com.Parameters.Add("@id", SqlDbType.Int).Value = id; SqlDataAdapter sqlda = new SqlDataAdapter("select * from employee where id=@id", con); sqlda.SelectCommand.Parameters.Add("@id", SqlDbType.Int).Value = id; DataSet ds = new DataSet(); sqlda.Fill(ds); try { image = Convert.ToString(ds.Tables[0].Rows[0]["image"]); File.Delete(Server.MapPath("images") + "\" + image); } catch (Exception) { } com.ExecuteNonQuery(); com.Dispose(); bindgrid(); } catch (Exception) { } } protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { GridView1.EditIndex = -1; bindgrid(); } protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { GridView1.EditIndex = e.NewEditIndex; bindgrid(); } protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); id = Convert.ToInt32(((Label)(GridView1.Rows[e.RowIndex].FindControl("label4"))).Text); name = (((TextBox)(GridView1.Rows[e.RowIndex].FindControl("txt_name"))).Text); address = (((TextBox)(GridView1.Rows[e.RowIndex].FindControl("txt_address"))).Text); SqlCommand com = new SqlCommand("update_employee", con); com.CommandType = CommandType.StoredProcedure; com.Connection = con; com.Parameters.Add("@id", SqlDbType.Int).Value = id; com.Parameters.Add("@UserName", SqlDbType.VarChar, 50).Value = name; com.Parameters.Add("@address", SqlDbType.VarChar, 50).Value = address; com.ExecuteNonQuery(); com.Dispose(); con.Close(); GridView1.EditIndex = -1; bindgrid(); } protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e) { GridView1.PageIndex = e.NewSelectedIndex; bindgrid(); } } } Login.aspx Untitled Page Width="100px" BackColor="#FFFF66" ForeColor="#FF3300"> ControlToValidate="TextBox_user_name" ErrorMessage="Please enter the UserName"> Width="100px" BackColor="#FFFF66" ForeColor="#FF3300"> TextMode="Password" Width="100px"> ControlToValidate="TextBox_password" ErrorMessage="Please enter the Password"> BackColor="#CCFF99" onclick="btn_login_Click" /> Login.aspx.cs using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Display_image_username_after_login { public partial class Login : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string str; SqlCommand com; protected void btn_login_Click(object sender, EventArgs e) { object obj = null; SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "select count(*) from employee where UserName=@UserName and Password =@Password"; com = new SqlCommand(str, con); com.CommandType = CommandType.Text; Session["UserName"] = TextBox_user_name.Text; com.Parameters.AddWithValue("@UserName", Session["UserName"]); com.Parameters.AddWithValue("@Password", TextBox_password.Text); obj = com.ExecuteScalar(); if ((int)(obj) != 0) { Response.Redirect("Welcome.aspx"); } else { lb1.Text = "Invalid User name and Password"; clear(); } con.Close(); } private void clear() { TextBox_user_name.Text = ""; TextBox_password.Text = ""; } } } Welcome.aspx Untitled Page BackColor="#CC3300" ForeColor="Black" ShowHeader="False" > ' height="50px" width="50px"/> Welcome.aspx.cs using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Display_image_username_after_login { public partial class Welcome : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string str; SqlDataAdapter sqlda; DataTable dt; protected void Page_Load(object sender, EventArgs e) { lb1.Text = " " + "WELLCOME :: " + " " + " " + Session["UserName"] + " "; if (!IsPostBack) { bindgrid(); } } private void bindgrid() { string UserName = (string)Session["UserName"]; SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "select image from employee where UserName='" + UserName + "'"; sqlda = new SqlDataAdapter(str, con); dt = new DataTable(); sqlda.Fill(dt); sqlda.Dispose(); GridView1.DataSource = dt; GridView1.DataBind(); con.Close(); } } }

Satyapriya Nayak · Answer

http://www.codeproject.com/Articles/59054/Profiles-in-NET-with-Images http://www.c-sharpcorner.com/UploadFile/satyapriyanayak/display-username-along-with-photo-after-successful-login/