8.6. Binding Data to a Web Forms GridView Control

Problem

You want to bind the result set from a query to a GridView control and page through and sort the data.

Solution

Set the advanced properties of the GridView control and bind the data to the control. Handle the PageIndexChanging and Sorting events.

Follow these steps:

  1. Create a C# ASP.NET web application named BindWebFormGridView.

  2. Add the following control to the Default.aspx design surface:

    • GridView named contactGridView

    The completed layout of the Web Form page Default.aspx is shown in Figure 8-11.

    The code in Default.aspx in the project BindWebFormGridView is shown in Example 8-11.

    Layout for Default.aspx in BindWebFormGridView solution

    Figure 8-11. Layout for Default.aspx in BindWebFormGridView solution

Example 8-11. File: Default.aspx for BindWebFormGridView solution

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs"
    Inherits="BindWebFormGridView._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>
        <asp:GridView ID="contactGridView" runat="server"
            onpageindexchanging="contactGridView_PageIndexChanging"
            onsorting="contactGridView_Sorting">
        </asp:GridView>
    </div>
    </form>
</body>
</html>

The C# code-behind code in Default.aspx.cs in the project ...

Get ADO.NET 3.5 Cookbook, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial