Click here to Skip to main content
15,896,550 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
This is my code
C#
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();
    }


if i click the update button the old database values are updated ........
How to update the database values...
Posted

1 solution

C#
//Call userdetails() funtion in page load

if(!IsPostBack)
{
userdetails();
}
 
Share this answer
 
Comments
saravana__ 14-Mar-12 3:22am    
Thank You

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900