Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: WCF
I have created a service in that i wrote the methods to get the employee details by selecting the employeer id . how can we add that service to aspx code. and also to get that emp details in gridview we need to write sql command where it should be in the service or in the code.
 

IService1.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.Configuration;
 
namespace Employee
{
    // NOTE: If you change the interface name "IService1" here, you must also update the reference to "IService1" in App.config.
    [ServiceContract]
    public interface IService1
    {
        [OperationContract]
        DataSet GetEmployeerid();
 
        [OperationContract]
        List<CompositeType> GetDataUsingDataContract(CompositeType composite);
 
        // TODO: Add your service operations here
    }
 
    // Use a data contract as illustrated in the sample below to add composite types to service operations
    [DataContract]
    public class CompositeType
    {
          int   empid;
         string ename;
         string address;
         string city ;
         string state ;
         string employeerid;
 
        [DataMember]
         public int Empid
        {
            get { return empid; }
            set { empid = value; }
        }
 
        [DataMember]
        public string Ename
        {
            get { return ename; }
            set { ename = value; }
        }
        [DataMember]
        public string Address
        {
            get { return address; }
            set { address = value; }
        }
        [DataMember]
        public string City
        {
            get { return city; }
            set { city = value; }
        }
        [DataMember]
        public string State
        {
            get { return state; }
            set { state = value; }
        }
        [DataMember]
        public string Employeerid
        {
            get { return employeerid; }
            set { employeerid = value; }
        }
    }
}
Service1.cs:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
 
namespace Employee
{
    // NOTE: If you change the class name "Service1" here, you must also update the reference to "Service1" in App.config.
    public class Service1 : IService1
    {
        public  DataSet GetEmployeerid()
        {
            String strConnection = ConfigurationManager.ConnectionStrings["MyConsString"].ConnectionString;
            SqlConnection conn = new SqlConnection(strConnection);
            SqlCommand cmd = new SqlCommand("select * from Employeertable where Employeerid=@Employeerid ", conn);
             conn.Open();
            SqlDataAdapter da=new SqlDataAdapter(cmd);            
             DataSet ds = new DataSet ();
             da.Fill(ds);
             return ds;
    
        }
 
        public List<compositetype> GetDataUsingDataContract(CompositeType composite)
        {
            List<compositetype> CompositeType = new List<compositetype>();
 
            {
                String strConnection = ConfigurationManager.ConnectionStrings["MyConsString"].ConnectionString;
                SqlConnection conn = new SqlConnection(strConnection);
                SqlCommand cmd = new SqlCommand("select * from Employeetable ", conn);
                conn.Open();
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataTable dt = new DataTable();
                da.Fill(dt);
                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        CompositeType obj = new CompositeType();
                        obj.Empid = Convert.ToInt32(dt.Rows[i]["Empid"].ToString());
                        obj.Ename = dt.Rows[i]["Ename"].ToString();
                        obj.Address = dt.Rows[i]["Address"].ToString();
                        obj.City = dt.Rows[i]["City"].ToString();
                        obj.State = dt.Rows[i]["State"].ToString();
                        obj.Employeerid = dt.Rows[i]["Employeerid"].ToString();
                        CompositeType.Add(obj);
                    }
                }
                conn.Close();
            }
            return CompositeType;
        }
 
        }
    }
Design view:
<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
&nbsp;<asp:Label ID="Label1" runat="server" Text="Employeerid">
    </asp:Label>&nbsp;&nbsp;
        <asp:DropDownList ID="DropDownList1" runat="server" Height="20px" Width="192px">
         <asp:ListItem>...Select...</asp:ListItem>
            <asp:ListItem>TCD</asp:ListItem>
            <asp:ListItem>Hmsa</asp:ListItem>
             <asp:ListItem>Dell</asp:ListItem>
        </asp:DropDownList>
&nbsp;
        <asp:Button ID="Button1" runat="server" Text="Search"  />
        <br />
        <br />
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
            <Columns>
 
                <asp:BoundField DataField="Empid" HeaderText="Empid" />
                <asp:BoundField DataField="Ename" HeaderText="Ename" />
                <asp:BoundField DataField="Address" HeaderText="Address" />
                <asp:BoundField DataField="City" HeaderText="City" />
                <asp:BoundField DataField="State" HeaderText="State" />
                <asp:BoundField DataField="Employeerid" HeaderText="Employeerid" />
            </Columns>
        </asp:GridView>
 
    </div>
    </form>
</body>
</html>
Posted 4-Jan-13 19:30pm
Edited 4-Jan-13 19:53pm
v2

1 solution

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

Solution 1

If you are using Visual Studio and just want to test this service, simply go to add web reference and add the project as service.
In a more real time scenario, you should ideally look at hosting the web service in IIS and then testing against it using your client.
 
Look at the WCF Client for testing too.
 
Check out the following links -
http://a1ashiish-csharp.blogspot.com/2012/01/cnet-how-to-test-wcf-web-service-in.html[^]
http://blogs.msdn.com/b/jmeier/archive/2007/10/15/how-to-create-a-hello-world-wcf-service-using-visual-studio.aspx[^]
http://visualstudiomagazine.com/articles/2012/09/11/host-wcf-service-library-in-asp-net.aspx[^]
http://blogs.msdn.com/b/wcftoolsteamblog/archive/2010/01/04/tips-for-launching-wcf-test-client.aspx[^]
  Permalink  
Comments
dhritirao1221 at 5-Jan-13 1:45am
   
Select * from Employeertable INNER JOIN Employeetable on Employeertable.Employeerid= Employeetable.Employeerid where Employeertable.Employeerid='"+DropDownList1.SelectedItem.ToString()+"'"
 
this is my sql command to get he details of employees based on the employeerid selected in drop down but where this statement i have to keep is it possible to keep in the service. but in service there will be no dropdown so how to do
Abhinav S at 5-Jan-13 2:02am
   
You will return the results from the service to the client program and then display the dropdown / data in this client.
Sandeep Mewara at 5-Jan-13 1:54am
   
My 5!
Abhinav S at 5-Jan-13 2:01am
   
Thank you Sandeep.

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

  Print Answers RSS
0 OriginalGriff 395
1 Prakriti Goyal 254
2 Yogesh Kumar Tyagi 224
3 Sergey Alexandrovich Kryukov 183
4 CPallini 160
0 OriginalGriff 6,742
1 Sergey Alexandrovich Kryukov 5,479
2 Maciej Los 3,474
3 Peter Leow 3,313
4 DamithSL 2,505


Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 5 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100