Avoiding Page Post back when Inserting a data in a table C#

Question

Hello I need help how to avoid post back when the code execute the insert statement. I don't want the page to refresh when I insert the data The insert statement works. My codes is attached Thanks

Eric Mbiada · Answer

Hi Dharmraj Please find attached the capture screen of the error I am getting. I checked post method is calling insertData.aspx/AddConsent because I am getting the message box Any help please Eric

Dharmraj Thakur · Answer

One mistake is here... url: '/insertData.aspx/AddConsent' start with / means root of the directory then pagename.aspx... Try it and still nothing happening then go to inspect element > network and see weather post method calling or not and if calling then any error occuring or not?

Eric Mbiada · Answer

Hi Dharmraj Thanks for you reply . I tried you code but the data is not inserting in the table. I am getting an empty message box with no value. I think I am not too far but I am missing something. I attached the 2 pages I am usinging Thanks for your help

Dharmraj Thakur · Answer

Just make use of json in your code and use simple button instead of submit button... Your html code: table class = auto-style84 > tr > td class = auto-style85 > strong > MBID strong > td > td class = auto-style86 > strong > Consent Name strong > td > td class = auto-style87 > span class = auto-style98 > strong > Consent Date strong > td > tr > tr > td class = auto-style177 > asp:TextBox ID = txtConsentMBID runat = server Height = 28px Width = 161px ReadOnly = True CssClass = auto-style142 > asp:TextBox > td > td class = auto-style176 > asp:DropDownList ID = DropDownListConsent runat = server DataSourceID = SqlDataSource1 DataTextField = ConsentName DataValueField = ConsentID Height = 36px Width = 175px CssClass = auto-style142 > asp:DropDownList > asp:SqlDataSource ID = SqlDataSource1 runat = server ConnectionString =   SelectCommand = SELECT * FROM [Consent] ORDER BY [ConsentID] DESC > asp:SqlDataSource > td > td class = auto-style93 > asp:TextBox ID = txtPatientConsentDate runat = server Height = 26px Width = 161px CssClass = auto-style142 > asp:TextBox > td > tr > tr > td class = auto-style80 > input type = button class = btn btn-lg btn-block ID = btnAddConsent Height = 43px onClick = insertData() value = Add Consent Width = 166px class = auto-style142 /> td > tr > table > Javascript code: function insertData() { var dataArr = { MBID : $( #txtConsentMBID ).val() ConsentID :$( #DropDownListConsent ).val() ConsentDate :$( #txtPatientConsentDate ).val() }; $.ajax({ type: 'POST'  url: 'PageName.aspx/AddConsent'  data: JSON.stringify(dataArr) contentType: 'application/json; charset=utf-8'  dataType: 'json'  success: function (msg) { alert(msg); } }); } Note: change url of your webpage ( url: 'PageName.aspx/AddConsent') Your C# method: public string AddConsent( string MBID string ConsentID string ConsentDate) { if (ConsentValidation()) { using (SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings[ Molecular ].ConnectionString)) { con.Open(); using (SqlCommand sc = new SqlCommand(@ insert into ConsentGroup (MBID ConsentID ConsentDate ConsentWithdraw) values(@MBID @ConsentID  @ConsentDate 'NO' )  con)) { sc.Parameters.AddWithValue( @MBID Convert.toInt32(MBID); sc.Parameters.AddWithValue( @ConsentID  Convert.toInt32(ConsentID)); sc.Parameters.AddWithValue( @ConsentDate  Convert.toDateTime(ConsentDate)); sc.ExecuteNonQuery(); Response.Write(   ); } con.Close(); } } return Successfully Inserted ; }

Dharmraj Thakur · Answer

I think insert sould be successful.. check here what you are getting from controller success: function (msg) { JSON.stringify(msgnull5); } And see what is pasing and whats happening after save...