如何更新数据库值 [英] how to update database value

问题描述

这是我的代码

This is my code

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

推荐答案

//Call userdetails() funtion in page load

if(!IsPostBack)
{
userdetails();
}

这篇关于如何更新数据库值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！