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 idnameaddress 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