DevStudent

Create a new webservice which creates two files in appcode folder. they are service and iservice.
operationcontract is the method that is shared.

code in iservice.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.Text;

using System.Data;
using System.Data.SqlClient;

// NOTE: You can use the "Rename" command on the "Refactor" menu to change the interface name "IConnectService" in both code and config file together.
[ServiceContract]
public interface IConnectService
{
    [OperationContract]
    string InsertUserRegDetails(string emailid,string pwd,string gender);

}

code inside service.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.Text;

using System.Data;
using System.Data.SqlClient;
using System.Configuration;
// NOTE: You can use the "Rename" command on the "Refactor" menu to change the

class name "ConnectService" in code, svc and config file together.
public class ConnectService : IConnectService
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings

["ConStr"].ConnectionString);

    public string InsertUserRegDetails(string emailid, string pwd, string gender)
    {
        string Status;
        if (con.State == ConnectionState.Closed)
        {
            con.Open();
        }

        SqlCommand cmd = new SqlCommand("insert into tbl_Register values

(@emailid,@pwd,@gender)", con);

        cmd.Parameters.AddWithValue("@emailid", emailid);
        cmd.Parameters.AddWithValue("@pwd", pwd);
        cmd.Parameters.AddWithValue("@gender", gender);
        int result = cmd.ExecuteNonQuery();
        if (result == 1)
        {
            Status = emailid + " registered successfully";
        }
        else
        {
            Status = emailid + " could not be registered";
        }
        con.Close();
        return Status;
    }
    }