Click here to Skip to main content
15,868,141 members
Please Sign up or sign in to vote.
2.00/5 (1 vote)
See more:
Dear All,
here popup not working after update is not coming "Saved Sucessfully"

please reply me here what mistake and what right or any examples please reply me


C#
protected void btnSave_Click(object sender, EventArgs e)
    {
        string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        string strUpdate = "UPDATE SignUpTable SET Mobilenumber=@Mobilenumber, DateOfBirth=@DateOfBirth, Gender=@Gender, CurrentCity = @CurrentCity, WHERE Username = @Username";
        //Create SQL connection
        SqlConnection con = new SqlConnection(connectionString);
        //Create SQL Command And Sql Parameters
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = strUpdate;

        SqlParameter Mobilenumber = new SqlParameter("@Mobilenumber", SqlDbType.NVarChar);
        Mobilenumber.Value = txtMobilenumber.Text.ToString();
        cmd.Parameters.Add(Mobilenumber);
        

        SqlParameter DateOfBirth = new SqlParameter("@DateOfBirth", SqlDbType.NVarChar);
        DateOfBirth.Value = txtDOB.Text.ToString();
        cmd.Parameters.Add(DateOfBirth);

        SqlParameter Gender = new SqlParameter("@Gender", SqlDbType.NVarChar);
        Gender.Value = RadioButtonList1.Text.ToString();
        cmd.Parameters.Add(Gender);

        SqlParameter CurrentCity = new SqlParameter("@CurrentCity", SqlDbType.NVarChar);
        CurrentCity.Value = txtCurrentCity.Text.ToString();
        cmd.Parameters.Add(CurrentCity);
       

        SqlParameter Username = new SqlParameter("@Username", SqlDbType.NVarChar);
        Username.Value = lblEmail.Text.ToString();
        cmd.Parameters.Add(Username);

        try
        {
            con.Open();
            int result = cmd.ExecuteNonQuery();
            //Response.Redirect("About.aspx");
            ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('Saved Successfully')", true);
        }
        catch (SqlException ex)
        {
            string errorMessage = "Error in updation";
            errorMessage += ex.Message;
            throw new Exception(errorMessage);
        }
        finally
        {
            con.Close();
        }
    }
Posted
Updated 24-Oct-14 18:32pm
v2
Comments
DamithSL 25-Oct-14 0:55am    
are you using update panel?
member10000 25-Oct-14 1:22am    
no am not used

1 solution

using lable

replace: lable.text="saved sucess fully";
 
Share this answer
 
v2

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