using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; public partial class profile : System.Web.UI.Page { SqlDataReader dr; SqlConnection con = new SqlConnection(@"Data Source=MAY-PC\SQLEXPRESS;Initial Catalog=demo;Integrated Security=True"); protected void Page_Load(object sender, EventArgs e) { pname.Text = Session["userid"].ToString(); read(); } protected void savebtn_Click(object sender, ImageClickEventArgs e) { //int imagefilelenth = FileUpload1.PostedFile.ContentLength; // byte[] imgarray = new byte[imagefilelenth]; // HttpPostedFile image = FileUpload1.PostedFile; //image.InputStream.Read(imgarray, 0, imagefilelenth); SqlCommand cmd = new SqlCommand("[update]", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@email", pemail.Text.ToString()); cmd.Parameters.AddWithValue("@dob", pdob.Text.ToString()); cmd.Parameters.AddWithValue("@gender", pgender.Text.ToString()); cmd.Parameters.AddWithValue("@city", city.Text.ToString()); cmd.Parameters.AddWithValue("@state", state.Text.ToString()); cmd.Parameters.AddWithValue("@country", country.Text.ToString()); cmd.Parameters.AddWithValue("@about", about.Text.ToString()); cmd.Parameters.AddWithValue("@books", books.Text.ToString()); cmd.Parameters.AddWithValue("@qualification", qualification.Text.ToString()); cmd.Parameters.AddWithValue("@number", number.Text.ToString()); //cmd.Parameters.AddWithValue("@image",imgarray); cmd.Parameters.AddWithValue("@username", pname.Text.ToString()); cmd.Parameters.AddWithValue("@designation", designation.Text.ToString()); cmd.Parameters.AddWithValue("@interest", interest.Text.ToString()); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } protected void cancelbtn_Click(object sender, ImageClickEventArgs e) { Response.Redirect("viewprofile1.aspx"); } protected void Button1_Click(object sender, EventArgs e) { if (FileUpload1.HasFile) { string path = "~/imguplod/" + (FileUpload1.FileName); FileUpload1.SaveAs(Server.MapPath(path)); Image1.ImageUrl = path; Session["image"] = (FileUpload1.FileName); } } private void read() { SqlCommand cmd = new SqlCommand("[select]", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@username", pname.Text.ToString()); con.Open(); dr = cmd.ExecuteReader(); if (dr != null && dr.HasRows) { dr.Read(); { pname.Text = (Convert.ToString(dr["username"])); pdob.Text = (Convert.ToString(dr["dob"])); pemail.Text = (Convert.ToString(dr["email"])); pgender.Text = (Convert.ToString(dr["gender"])); city.Text = (Convert.ToString(dr["city"])); state.Text = (Convert.ToString(dr["state"])); country.Text = (Convert.ToString(dr["country"])); designation.Text = (Convert.ToString(dr["designation"])); qualification.Text = (Convert.ToString(dr["qualification"])); about.Text = (Convert.ToString(dr["about"])); interest.Text = (Convert.ToString(dr["interest"])); books.Text = (Convert.ToString(dr["books"])); con.Close(); } } else { pname.Text = Session["userid"].ToString(); pemail.Text = Session["email"].ToString(); pgender.Text = Session["gender"].ToString(); pdob.Text = Session["dob"].ToString(); } } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)