how to show data saved sucessfully in asp dotnet after inser

Question

na

Vincent Maverick Durano · Answer

That depends on what Data Access mechanism you are using. If you are using the traditional ADO.NET, you could do something like this: private string GetConnectionString(){ return System.Configuration.ConfigurationManager.ConnectionStrings[ "DBConnectionString" ].ConnectionString; } private int InsertRecord(string name, string age, string gender, string city){ int affected = 0; string sqlStatement = "INSERT INTO YourTableName values(@name,@gender,@age,@city)" ; using (SqlConnection connection = new SqlConnection(GetConnectionString())){ using (SqlCommand cmd = new SqlCommand(sqlStatement ,connection)){ cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue( "@name" ,name); cmd.Parameters.AddWithValue( "@gender" ,gender); cmd.Parameters.AddWithValue( "@age" ,age); cmd.Parameters.AddWithValue( "@city" ,city); affected = cmd.ExecuteNonQuery(); } } return affected; } protected void Button1_Click(object sender, EventArgs e){ //perform forms validation check here InsertRecord(txtname.Text,txtage.Text,ddlGender.SelectedValue,ddlCity.SelectedValue); if (result > 0) Response.Write( "Data inserted successfully!" ); else //display something else }

Rafnas T P · Answer

hi, try below code to show message string script = "alert(\"Data Saved Successfully\");" ; ScriptManager.RegisterStartupScript( this , GetType(), "ServerControlScript" , script, true );

Pravat Kumar · Answer

Hello Sashi, please check below link. https://www.c-sharpcorner.com/UploadFile/009464/insert-data-into-database-using-Asp-Net-C-Sharp-and-stored-proced/

Sanwar Ranwa · Answer

Hello Sashi Please check this link https://www.aspsnippets.com/Articles/Display-Show-Success-Message-after-record-inserted-Form-Submit-in-ASPNet.aspx https://www.aspsnippets.com/Articles/Return-Identity-Auto-Increment-Column-value-after-record-insert-in-SQL-Server-Database-using-ADONet-with-C-and-VBNet.aspx

Jignesh Kumar · Answer

Please try below link https://www.aspsnippets.com/Articles/Display-Show-Success-Message-after-record-inserted-Form-Submit-in-ASPNet.aspx https://www.c-sharpcorner.com/code/2514/display-show-success-message-after-record-inserted-form-submit-in-asp-net.aspx

how to show data saved sucessfully in asp dotnet after inser

Answers (5)