Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: WCF
Iservice1.cs :
 

 
namespace Employeer
{
    // NOTE: If you change the interface name "IService1" here, you must also update the reference to "IService1" in Web.config.
    [ServiceContract]
    public interface IService1
    {
 
        [OperationContract]
          Employee GetEmployee();
 
    }
    [DataContract]
    public class Employee
    {
        [DataMember]
        public int Empid { get; set; }
        public string Name { get; set; }
        public string Address { get; set; }
        public string City { get; set; }
        public string State { get; set; }
        public string Employeerid { get; set; }
    }
 
}
 
Service1.svc.cs:
 

namespace Employeer
{
    // NOTE: If you change the class name "Service1" here, you must also update the reference to "Service1" in Web.config and in the associated .svc file.
    public class Service1: IService1
    {
        String strConnection = ConfigurationManager.ConnectionStrings["MyConsString"].ConnectionString;
        SqlConnection conn = new SqlConnection(strConnection);
        public List<Employee> GetEmployee(int Employeerid)
        {
            List<Employee> objEmployees = new List<Employee>();
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand("select * from Employeetable where Employeerid Like '%'+@Employeerid+'%'", conn);
                cmd.Parameters.AddWithValue("@Employeerid", Employeerid);
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataTable dt = new DataTable();
                da.Fill(dt);
 

            }
        }
Posted 28-Dec-12 22:36pm
Edited 28-Dec-12 22:48pm
ProgramFOX118.4K
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

The error is pretty clear:
'Employeer.Service1' does not implement interface member 'Employeer.IService1.GetEmployee()'
Your Interface definition includes:
Employee GetEmployee();
but your class declares:
List<Employee> GetEmployee(int Employeerid) {...}
These are not the same overload: the Interface expects a method with no parameters that returns an Employee, you have only declared a method that takes an integer and returns a List of Employees.
Either change your interface definition, or your class, (or both) as is appropriate.
  Permalink  
Comments
dhritirao1221 at 29-Dec-12 4:55am
   
'Employeer.Service1.GetEmployee(int)': not all code paths return a value
now im getting this error
OriginalGriff at 29-Dec-12 5:05am
   
Without seeing the code you have written for it, I can't help...
dhritirao1221 at 29-Dec-12 5:13am
   
thanks for ur help
OriginalGriff at 29-Dec-12 5:29am
   
You're welcome!

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

  Print Answers RSS
0 CHill60 360
1 Sarvesh Kumar Gupta 238
2 OriginalGriff 163
3 Sergey Alexandrovich Kryukov 163
4 DamithSL 153


Advertise | Privacy | Mobile
Web01 | 2.8.140709.1 | Last Updated 29 Dec 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid