protected void Page_Load(object sender, EventArgs e) { userdetails(); } public void userdetails() { con.Open(); SqlCommand cmd = new SqlCommand("select * from freeuserdetails where UserName='" + Session["username"] + "'", con); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { txtuname.Text = dr["UserName"].ToString(); txtmailid.Text = dr["MailId"].ToString(); txtdob.Text = dr["DOB"].ToString(); txtmobileno.Text = dr["MobileNo"].ToString(); txtaddress.Text = dr["Address"].ToString(); cmd.Dispose(); } con.Close(); } protected void btnupdate_Click(object sender, ImageClickEventArgs e) { con.Open(); SqlCommand cmd = new SqlCommand("update freeuserdetails set MailId='" + txtmailid.Text + "',DOB='" + txtdob.Text + "',MobileNo='" + txtmobileno.Text + "',Address='" + txtaddress.Text + "' where UserName='" + txtuname.Text + "'", con); cmd.ExecuteNonQuery(); con.Close(); }
//Call userdetails() funtion in page load if(!IsPostBack) { userdetails(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)