GridView Data Binding in ASP.NET Using WCF Service

In this article I will explain how to bind data in a GridView from a SQL Server database using a WCF Service.

Introduction

In this article first we will create a WCF service to get data from a SQL Server table. Then we will bind the data to a GridView control.

Step 1:

Create a new WCF Service Application

GrdWCF1.jpg

Note: I am using Microsoft Visual Web Developer 2010 Express

Step 2:

Add the following code in IService1.cs:

GrdWCF2.jpg

Step 3:

Add the following code in Service1.svc.cs:

GrdWCF3.jpg

Note: Add your connection string to the Web.config file:

GrdWCF4.jpg

Step 4:

Run the application to open the WCF Test Client:

GrdWCF5.jpg

Copy the path of Service1.svc.

Step 5:

We have created a WCF service to retrieve data from a database. Now we will create an ASP.NET Web Application and add (by dragging) a GridView control to the Default.aspx as below:

GrdWCF6.jpg

Step 6:

  • Add a WCF service reference in the project
  • Right-click on the Service References in Solution Explorer
  • Select Add Service Reference
  • Paste the location of Service1.svc in the Address box copied in Step 4
  • Click on Go
  • Click on OK

GrdWCF7.jpg

Step 7:


Add the following code in Default.aspx.cs:

GrdWCF8.jpg

The final output:

GrdWCF9.jpg