Call Stored Procedure with JavaScript in ASP.Net

Question

How to call any Stored Procedure with parameters AND without parameters using Javascript My requirement is There is an asp button on my web page when user clicks on it then a Javascript shall run which will execute a Stored Procedure to update the value in database Initially I have to create a sample code for this requirementPlease let me know if any other detail is needed Please note that I am using SQL server databasePlease help me to achieve it Thanks in advance

MMP · Accepted Answer

Hi Richa Kindly use WebService to call your procedureHere is the sample code function loginAjax     var emailId  documentgetElementById34emailId34value    var password  documentgetElementById34password34value    if emailId  3434 ampamp password  3434         ajax            url 39LoginServiceasmxValidateUser139            type 39POST39            data JSONstringify EmailId emailId password password             dataType 34json34            contentType 34applicationjson charsetutf834            success function data                 if datad  34EmptyFields34                     documentgetElementById34loginErrorMessageId34styledisplay  34block34                    documentgetElementById34loginErrorMessageId34innerHTML  34Please fill both fields34                                if datad  34134                     document

dharmendr · Answer

Hi RichaPlease refer the below article and in place of in line query use storedprocedureInsert Update Data to Database with jQuery AJAX and WebMethod in ASPNetASPNet jQuery AJAX CRUD Select Insert Edit Update and Delete in ASPNet GridView using jQuery AJAX

Call Stored Procedure with JavaScript in ASP.Net

Insert (Update) Data to Database with jQuery AJAX and WebMethod in ASP.Net

ASP.Net jQuery AJAX CRUD: Select Insert Edit Update and Delete in ASP.Net GridView using jQuery AJAX

Company

Explore

Follow us

Contact Us