Knowledge Walls
Gopal Rao
Mumbai, Maharashtra, India
Passcode:
Jquery ajax web service call sharepoint example
9160 Views
Introduction 
In this example i am calling the web sevice through ajax jquery.When click the button, the value from the text box taken as json and sent to the webservice through post method.The value stored in sql table(gopal). 
Html- type this code in content editor web part
	<script src="http://ajax.cdnjs.com/ajax/libs/json2/20110223/json2.js"/>
	<script src="http://code.jquery.com/jquery-1.9.1.js" type="text/javascript"></script>
	<script type="text/javascript">
	function CallService()
	{  
	jQuery.support.cors = true;
	     $.ajax({
	             type: "POST",
	             url:"http://localhost:16264/Service1.asmx/getdata1" ,
	             data:JSON.stringify({Name:$("#gope").val()}),
	             contentType: "application/json; charset=utf-8",
	             dataType: "json",
	             complete:comletesuc,
	             success: OnSuccess,
	             error: OnError        
	               });
	         function comletesuc(data, status)
	           { alert("Completed");
	                          }
	         function OnSuccess(data, status,xhttp)
	          {             if(data.d="SUCCESS"){
	             alert("You account has successfully created with password 12345");}
	else
	{ alert("Not success");
	}
	          }
	         function OnError(request, status, error)  
	         {
	             alert("This is an error");
	         }
	     }
	</script>
	<div>Name:<input type="text" id="gope" /></div>
	<div><input type="button" id="gope_sub" value="submit" onclick="return CallService();" /></div>
Web service-function
	 public string getdata1(string Name)
	       {
	           string status = "";
	           SqlConnection con = new SqlConnection("Data Source=dgfusgf;Initial Catalog=master;User
	id=gopal;Password=password");
	           SqlCommand cmd = new SqlCommand();
	           con.Open();
	           cmd.Connection = con;
	           cmd.CommandType = CommandType.Text;
	           cmd.CommandText = "insert into gopal values('" + Name + "')";
	           int res = cmd.ExecuteNonQuery();
	           con.Close();
	           if (res == 1)
	           {
	               status = "SUCCESS";
	           }
	           else
	           {
	               status = "FAILURE";
	           }
	           return status;
	       }
Next Topics
Next lessons of current book.
Best Lessons of "Microsoft sharepoint"
Top lessons which are viewed more times.
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details