[Solved] Update code not working on ASP.Net Button Click

micah says:

protected void btnsave_Click(object sender, EventArgs e)

{

    String strConnString = ConfigurationManager.ConnectionStrings["DB"].ConnectionString;

    SqlConnection conn4 = new SqlConnection(strConnString);

    SqlCommand cmdD = new SqlCommand();

    cmdD.CommandType = CommandType.Text;

    cmdD.CommandText = "UPDATE User3 SET Name=@Name,Email=@Email,UserName=@UserName,Password=@Password,Department=@Department,CreatedDate=@CreatedDate,LastLoginDate=@LastLoginDate WHERE UserID= @UserID";

 

    cmdD.Parameters.AddWithValue("@UserID", ddljob.SelectedItem.Text.Trim());

    cmdD.Parameters.AddWithValue("@Name", txtName.Text.Trim());

    cmdD.Parameters.AddWithValue("@UserName", txtUserName.Text.Trim());

    cmdD.Parameters.AddWithValue("@Email", txtemail.Text.Trim());

    cmdD.Parameters.AddWithValue("@Department", ddldepartment.SelectedItem.Text.Trim());

    cmdD.Parameters.AddWithValue("@Password", Encrypt(txtPassword.Text.Trim()));

    cmdD.Parameters.AddWithValue("@CreatedDate", txtdate.Text.Trim());

    cmdD.Parameters.AddWithValue("@LastLoginDate", txtdate.Text.Trim());

    cmdD.Connection = conn4;

    try

    {

        conn4.Open();

        // tbljobs.EmptyDataText = "No Records Found";

        //  tbljobs.DataSource = cmdD.ExecuteReader();

        //tbljobs.DataBind();

        ScriptManager.RegisterClientScriptBlock(btnsave, this.GetType(), "alert", "<script>alert('Data Updated Successfully ... !!')</script>", false);

        // lblMessage2.Text = "Inserted Quantity Is Higher than  stock " + GetQuantity().ToString();

 

    }

    catch (Exception ex)

    {

        throw ex;

    }//

    finally

    {

        conn4.Close();

        conn4.Dispose();

Call the ExecuteNonQuery of command object to update the record. Change with below code.

protected void btnsave_Click(object sender, EventArgs e)
{
    String strConnString = ConfigurationManager.ConnectionStrings["DB"].ConnectionString;
    SqlConnection conn4 = new SqlConnection(strConnString);
    SqlCommand cmdD = new SqlCommand();
    cmdD.CommandType = CommandType.Text;
    cmdD.CommandText = "UPDATE User3 SET Name=@Name,Email=@Email,UserName=@UserName,Password=@Password,Department=@Department,CreatedDate=@CreatedDate,LastLoginDate=@LastLoginDate WHERE UserID= @UserID";
 
    cmdD.Parameters.AddWithValue("@UserID", ddljob.SelectedItem.Text.Trim());
    cmdD.Parameters.AddWithValue("@Name", txtName.Text.Trim());
    cmdD.Parameters.AddWithValue("@UserName", txtUserName.Text.Trim());
    cmdD.Parameters.AddWithValue("@Email", txtemail.Text.Trim());
    cmdD.Parameters.AddWithValue("@Department", ddldepartment.SelectedItem.Text.Trim());
    cmdD.Parameters.AddWithValue("@Password", Encrypt(txtPassword.Text.Trim()));
    cmdD.Parameters.AddWithValue("@CreatedDate", txtdate.Text.Trim());
    cmdD.Parameters.AddWithValue("@LastLoginDate", txtdate.Text.Trim());
    cmdD.Connection = conn4;
    try
    {
        conn4.Open();
        cmdD.ExecuteNonQuery();
        conn4.Close();
        ScriptManager.RegisterClientScriptBlock(btnsave, this.GetType(), "alert", "<script>alert('Data Updated Successfully ... !!')</script>", false);
        // lblMessage2.Text = "Inserted Quantity Is Higher than  stock " + GetQuantity().ToString();
 
    }
    catch (Exception ex)
    {
        throw ex;
    }//
    finally
    {
        conn4.Close();
        conn4.Dispose();