Data inserting using web service !!!!

{{txtName}}

using System;

using System.Collections.Generic;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.Web.Script.Serialization;

using System.Web.Services;

namespace WebApplication1

{

///

/// Summary description for employeeService

///

[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 employeeService : System.Web.Services.WebService

{

[WebMethod]

public void addEmployee(Employee emp)

{

//string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;

using (SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True"))

{

SqlCommand cmd = new SqlCommand("spInsertEmployee", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add(new SqlParameter()

{

ParameterName = "@Name",

Value = emp.Name

});

cmd.Parameters.Add(new SqlParameter()

{

ParameterName = "@Gender",

Value = emp.Gender

});

cmd.Parameters.Add(new SqlParameter()

{

ParameterName = "@Salary",

Value = emp.Salary

});

con.Open();

cmd.ExecuteNonQuery();

}

}

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

namespace WebApplication1

{

public class Employee

{

public string Name { get; set; }

public string Gender { get; set; }

public string Salary { get; set; }

}

}

 

====

 

Can any one tell the next process ...