Jquery to access web service method

namespace WebService

{

///

/// Summary description for Service1

///

[WebService(Namespace = "http://tempuri.org/")]

[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

[System.ComponentModel.ToolboxItem(false)]

// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.

[System.Web.Script.Services.ScriptService]

public class Service1 : System.Web.Services.WebService

{

SqlConnection _databaseConnection;

string _conString = (string)ConfigurationSettings.AppSettings["connectionString"];

[WebMethod]

[ScriptMethod(ResponseFormat = ResponseFormat.Json)]

public void GetUserDetails(string _name, string _city, string _phone, string _email)

{

_databaseConnection = new SqlConnection(_conString);

_databaseConnection.Open();

SqlCommand objCommand = new SqlCommand();

objCommand.CommandText = "sp_itbldetails";

objCommand.CommandType = CommandType.StoredProcedure;

objCommand.Connection = _databaseConnection;

objCommand.Parameters.Add("@tae_Name", SqlDbType.VarChar).Value = _name;

objCommand.Parameters.Add("@tae_Phone", SqlDbType.VarChar).Value = _phone;

objCommand.Parameters.Add("@tae_City", SqlDbType.VarChar).Value = _city;

objCommand.Parameters.Add("@tae_Email", SqlDbType.VarChar).Value = _email;

try

{

objCommand.ExecuteNonQuery();

objCommand.Dispose();

}

catch

{

}

finally

{

_databaseConnection.Close();

}

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

samanta12y ago
namespace WebService
{
///
/// Summary description for Service1
///
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
[System.Web.Script.Services.ScriptService]
public class Service1 : System.Web.Services.WebService
{
SqlConnection _databaseConnection;
string _conString = (string)ConfigurationSettings.AppSettings["connectionString"];

[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public void GetUserDetails(string _name, string _city, string _phone, string _email)
{
_databaseConnection = new SqlConnection(_conString);
_databaseConnection.Open();
SqlCommand objCommand = new SqlCommand();
objCommand.CommandText = "sp_itbldetails";
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.Connection = _databaseConnection;

objCommand.Parameters.Add("@tae_Name", SqlDbType.VarChar).Value = _name;
objCommand.Parameters.Add("@tae_Phone", SqlDbType.VarChar).Value = _phone;
objCommand.Parameters.Add("@tae_City", SqlDbType.VarChar).Value = _city;
objCommand.Parameters.Add("@tae_Email", SqlDbType.VarChar).Value = _email;

try
{

objCommand.ExecuteNonQuery();
objCommand.Dispose();

}
catch
{

}

finally
{
_databaseConnection.Close();
}

}
}
}
Sanjeeb Lenka12y ago
plz provide also your webservice code . full page
samanta12y ago
this is my code to access web service method
Riyaz Akhtar12y ago
Check this article,
http://surajdeshpande.wordpress.com/2013/08/09/call-web-service-using-jquery-in-asp-net/

let us know if it doesn't work
Tirthak Shah12y ago
Please Provide Some Of Your Code.
samanta12y ago
i tried that but still not got any solution
Tirthak Shah12y ago
http://forums.asp.net/t/1934215.aspx?Using+jQuery+ajax+to+call+asmx+webservice+methods

Please Refer This.I Think U miss jquery.