Insert and Show Data in GridView using WCF in ASP.NET

Ans:-
Here insert data into DB and Get Data from DB using WCF web services. In below UI of the application..

For this create one Website as->File->New Website->Give Website Name as WcfTesting->ok
                                              ->select Wcf Services from new template
                                              ->automatically 4 files will create in Solution Explorer
                                             ->as I) Service.cs and IService.cs in App_Code folder
                                                     II)App_Data folder
                                                     III)Service and Web.config file.

Then write code in

IService.cs:-

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

// NOTE: If you change the interface name "IService" here, you must also update the reference to "IService" in Web.config.
[ServiceContract]
public interface IService
{

[OperationContract]
    List<TestDetails> GetTestData();

[OperationContract]
    string InsertGetTestData(TestDetails testInfo);

// TODO: Add your service operations here
}

// Use a data contract as illustrated in the sample below to add composite types to service operations.
public class TestDetails
{
    int id;
    string name = string.Empty;
    string descrptn = string.Empty;
 
    [DataMember]
    public string Name
    {
        get { return name; }
        set { name = value; }
    }
    [DataMember]
    public int Id
    {
        get { return id; }
        set { id = value; }
    }
    [DataMember]
    public string Descrptn
    {
        get { return descrptn; }
        set { descrptn = value; }
    }
}

Web.Config:-

<connectionStrings>
<add name="conStr" connectionString="server=.;database=subsdb;user id=sa;pwd=123"/></connectionStrings>

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: If you change the class name "Service" here, you must also update the reference to "Service" in Web.config and in the associated .svc file.
public class Service : IService
{
    private string strConnection = ConfigurationManager.ConnectionStrings["conStr"].ToString();
    public List<TestDetails> GetTestData()
    {
        List<TestDetails> testdetails = new List<TestDetails>();
        using (SqlConnection con = new SqlConnection(strConnection))
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("select * from test", con);
         
            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++)
                {
                    TestDetails testInfo = new TestDetails();
                    testInfo.Id = Convert.ToInt32(dt.Rows[i]["id"].ToString());
                    testInfo.Name = dt.Rows[i]["name"].ToString();
                    testInfo.Descrptn = dt.Rows[i]["descrptn"].ToString();

                    testdetails.Add(testInfo);
                }
            }
            con.Close();
        }
        return testdetails;
    }
    public string InsertGetTestData(TestDetails testInfo)
    {
        string strMessage = string.Empty;
        using (SqlConnection con = new SqlConnection(strConnection))
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("insert into test(id,name,descrptn) values(@id,@name,@descrptn)", con);
            cmd.Parameters.AddWithValue("@id", testInfo.Id);
            cmd.Parameters.AddWithValue("@name", testInfo.Name);
            cmd.Parameters.AddWithValue("@descrptn", testInfo.Descrptn);

            int result = cmd.ExecuteNonQuery();
            if (result == 1)
            {
                strMessage = testInfo.Id + " Details inserted successfully";
            }
            else
            {
                strMessage = testInfo.Name + " Details not inserted successfully";
            }
            con.Close();
        }
        return strMessage;
    }

}

After Completion upto this Build this Website and then run and copy that url For consuming this services to another Web application/Console application...

So i am creating another Website here to consume above WCF services.

For this create one Website as->File->New Website->Give Website Name as Website1->ok
                                              ->add new Item->In here add New Web Page from new template
                                                as(Default.aspx)

For consuming above services into this website,Right click and select Add Service References and then Paste above copied link and then clicked go.....and then give service name as....ServiceReference1.And then add this ServiceReference1 to Namespace.

Then write code in

Default.aspx:-

<%@ 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>Call Wcf Service to the Website Page</title>
</head>
<body>
    <form id="form1" runat="server">
   <div>
<table align="center">
<tr>
<td colspan="2" align="center">
<b>User Registration</b>
</td>
</tr>
<tr>
<td>
ID:
</td>
<td>
<asp:TextBox ID="txtId" runat="server"/>
</td>
</tr>
<tr>
<td>
Name:
</td>
<td>
<asp:TextBox ID="txtName" runat="server"/>
</td>
</tr>
<tr>
<td>
Desc:
</td>
<td>
<asp:TextBox ID="txtDesc" runat="server"/>
</td>
</tr>

<tr>
<td>
<asp:Button ID="btnSubmit" runat="server" Text="Submit" onclick="btnSubmit_Click" />
</td>
</tr>
<tr>
<td colspan="2">
<asp:Label ID="lblResult" runat="server"/>
</td>
</tr>
<tr>
<td colspan="2">
<asp:GridView runat="server" ID="gvDetails" AutoGenerateColumns="false">
<RowStyle BackColor="#EFF3FB" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:BoundField HeaderText="ID" DataField="id" />
<asp:BoundField HeaderText="Name" DataField="name" />
<asp:BoundField HeaderText="Description" DataField="descrptn" />

</Columns>
</asp:GridView>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
 
Default.aspx.cs:-

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Collections.Generic;
using ServiceReference1;

public partial class _Default : System.Web.UI.Page
{

    ServiceReference1.ServiceClient proxy = new ServiceClient();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindTestDetails();
        }
    }
    void BindTestDetails()
    {
        List<TestDetails> testdetails = new List<TestDetails>();

        gvDetails.DataSource = proxy.GetTestData();
        gvDetails.DataBind();
    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        TestDetails testInfo = new TestDetails();
        testInfo.Id = Convert.ToInt32(txtId.Text);
        testInfo.Name = txtName.Text;
        testInfo.Descrptn = txtDesc.Text;

        string result = proxy.InsertGetTestData(testInfo);
        lblResult.Text = result;
        BindTestDetails();
        txtId.Text = string.Empty;
        txtName.Text = string.Empty;
        txtDesc.Text = string.Empty;
        }
}



Create Table:-

create table test(id int,name varchar(30),descrptn varchar(30))