Stop JavaScript code running when C# validation failed

Question

Hello

I am trying to stop the JavaScript code to run when the data is found in the table

(dt.Rows.Count > 0). At the moment the code is not inserting data in the database (that what

I want) but the JavaScript continues running because I am still getting the successful insert

message.Please see de code attached

Thanks for your help

Eric

Attachment: insertConsent.rar

Manas Mohapatra · Answer

Few code changes: Javascript button id= btnAddConsent value= Add Consent onclick= insertData(); /> function insertData() { var MBID = document.getElementById( txtConsentMBID ).value; var ConsentID = document.getElementById( DropDownListConsent ).value; var ConsentDate = document.getElementById( txtPatientConsentDate ).value; var xmlhttp = new XMLHttpRequest(); xmlhttp.onreadystatechange = function () { if (xmlhttp.readyState == 4 && xmlhttp.status == 200) { alert(xmlhttp.responseText); } } xmlhttp.open( GET  insertConsent.aspx?mb= + MBID +  &ci=  + ConsentID + &cd= + ConsentDate false ); xmlhttp.send( null ); ConsentID = document.getElementById( DropDownListConsent ).value =  ; ConsentDate = document.getElementById( txtPatientConsentDate ).value =  ; } C# code bool status= false ; using (SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings[ Molecular ].ConnectionString)) { MBID = Request.QueryString[ mb ].ToString(); ConsentID = Request.QueryString[ ci ].ToString(); ConsentDate = Request.QueryString[ cd ].ToString(); con.Open(); using (SqlCommand sc = new SqlCommand(@  select * from ConsentGroup where ConsentID = @ConsentID and MBID=@MBID   con)) { sc.Parameters.AddWithValue( @MBID  MBID); sc.Parameters.AddWithValue( @ConsentID  ConsentID); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(sc); da.Fill(dt); if (dt.Rows.Count { using (SqlCommand sc1 = new SqlCommand(@insert into ConsentGroup (MBID ConsentID ConsentDate ConsentWithdraw ConsentConfirm) values( ' + MBID + '  ' + ConsentID + '  ' + ConsentDate + '  'NO'  'YES' ) con)) { sc1.ExecuteNonQuery(); } status= true ; } } } if (status){ // this message should displayed when count is more that 1 Response.Write( Consent Added Successfully ); } else { Response.Write( This Patient already has this Concent saved in the Database' ); } http://www.c-sharpcorner.com/UploadFile/manas1/implementing-ajax-concept-in-Asp-Net-using-xmlhttprequest/

Manas Mohapatra · Answer

I think you need to write code inside page_load method. If that doesn't resolve your problem use jQuery AJAX. Follow below link that may help you: https://www.mikesdotnetting.com/article/40/asp-net-and-ajax-using-xmlhttprequest If it helps please accept the answer...

Eric Mbiada · Answer

Hi Manas Thanks for your help. The code works but I have an issue with the message displaying. The message is displaying HTML tags in the message box Any idea how to solve this issue Thanks Eric