Click here to Skip to main content
15,867,704 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
C#
[System.Web.Services.WebMethod]
public static string Create(int id, string name, int age)
{
    DataTable dt = new DataTable();
    string strResult = string.Empty;
    using (SqlConnection con = new SqlConnection("Database=project;Data Source=.;Trusted_Connection=true"))
    {
        using (SqlCommand cmd = new SqlCommand("inserting", con))
        {
           
                cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
                cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = name;
                cmd.Parameters.Add("@age", SqlDbType.Int).Value = age;

                cmd.CommandType = CommandType.StoredProcedure;
                SqlDataAdapter dataAdapter = new SqlDataAdapter();
                DataSet dataSet = new DataSet();
                dataAdapter.SelectCommand = cmd;
                dataAdapter.Fill(dataSet);
                dt = dataSet.Tables[0];

                if (dt.Rows.Count > 0)
                {
                    if (Convert.ToString(dt.Rows[0][0]).Contains("error"))
                    {
                        strResult = Convert.ToString(dt.Rows[0][0]);
                        strResult = strResult.Replace("<error>", "");
                        strResult = strResult.Replace("</error>", "");
                    }

                }
            }
            
        }
               return strResult;
}
Posted
Updated 25-May-14 19:39pm
v2

See this:
C#
$(document).ready(function () {
  $("#btnCreate").click(function (e) {
    e.preventDefault();                                                       
    $.ajax({
           type: 'POST',
           url: '../Create',
           contentType: 'application/json;charset=utf-8',
           data: "{ 'id' : '" + id+ "','name' : '" + name+ "', 'age' : '" + age+ "'}",//this parameters should be passed to web method
           dataType: 'json',
           success: function (JsonData) {
           //////your code after success
           }
           });
   });
});
 
Share this answer
 
v3
(document).ready(function () {
$("#btnCreate").click(function (e) {
e.preventDefault();
$.ajax({
type: 'POST',
url: 'webmethod.aspx/Create',
contentType: 'application/json;charset=utf-8',
data: "{ 'PersonID' : '" + PersonID + "','ZipCode' : '" + ZipCode + "', 'FirstName' : '" + FirstName + "', 'LastName' : '" + LastName + "'}",
dataType: 'json',
success: function (JsonData) {
if (JsonData.d !== "success") {
alert(JsonData.d);
}
datasource1.read();
},
error: function (JsonData) {
alert(JsonData.Id);

}
});
});
});

......................



this is my web method

[System.Web.Services.WebMethod]
public static string Create(int PersonID, int ZipCode,string FirstName,string LastName)
{
DataTable dt = new DataTable();
string strResult = string.Empty;
using (SqlConnection con = new SqlConnection("Database=project;Data Source=.;Trusted_Connection=true"))
{
using (SqlCommand cmd = new SqlCommand("create1", con))
{
con.Open();

cmd.Parameters.Add("@PersonID", SqlDbType.Int).Value = PersonID;
cmd.Parameters.Add("@ZipCode", SqlDbType.Int).Value = ZipCode;
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar).Value =FirstName ;
cmd.Parameters.Add("@LastName", SqlDbType.Int).Value = LastName;

cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter dataAdapter = new SqlDataAdapter();
DataSet dataSet = new DataSet();
dataAdapter.SelectCommand = cmd;
dataAdapter.Fill(dataSet);
dt = dataSet.Tables[0];

if (dt.Rows.Count > 0)
{
if (Convert.ToString(dt.Rows[0][0]).Contains("error"))
{
strResult = Convert.ToString(dt.Rows[0][0]);
strResult = strResult.Replace("<error>", "");
strResult = strResult.Replace("", "");
}

}
}

}
return strResult;
}



create button isnt called while executing can u please help me.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900