Photo upload

Question

i have employee details screen in that screen i want to upload Employee photo using c# with example.

Satyapriya Nayak · Answer

Hi narasiman, Try this... Default.aspx Untitled Page Employee Details Name Address Image File Text="Insert" onclick="btn_insert_Click"> 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; namespace Details_with_photo { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string str; SqlCommand com; protected void btn_insert_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strConnString); int len = Upload.PostedFile.ContentLength; byte[] pic = new byte[len + 1]; Upload.PostedFile.InputStream.Read(pic, 0, len); con.Open(); str = "insert into employee values (@name,@address,@photo)"; com=new SqlCommand(str, con); com.Parameters.AddWithValue("@name", txtname.Text); com.Parameters.AddWithValue("@address", txtaddress.Text); com.Parameters.AddWithValue("@photo", pic); com.ExecuteNonQuery(); con.Close(); lblmsg.Text = "Employee Details Inserted Successfully!"; Response.Redirect("employee.aspx"); } } } employee.aspx Untitled Page Details of Employee Id : Name : Address : '/> employee.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 Details_with_photo { public partial class employee : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string str; SqlCommand com; protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "select id,name,address from employee"; com = new SqlCommand(str, con); SqlDataReader reader; reader = com.ExecuteReader(); repeater1.DataSource = reader; repeater1.DataBind(); con.Close(); } } } image.aspx Untitled Page image.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.Drawing; using System.Drawing.Imaging; using System.IO; using System.Data.SqlClient; namespace Details_with_photo { public partial class image : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string str; SqlCommand com; protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "select photo from employee where id = '" + Request.QueryString["id"] + "'"; com=new SqlCommand(str, con); MemoryStream stream = new MemoryStream(); byte[] image = (byte[])com.ExecuteScalar(); stream.Write(image, 0, image.Length); Bitmap bitmap = new Bitmap(stream); Response.ContentType = "image/Jpeg"; bitmap.Save(Response.OutputStream, ImageFormat.Jpeg); con.Close(); stream.Close(); } } } Thanks If this post helps you mark it as answer