GuruStop.NET

/******************************************************************

 * The sample is provided AS IS without any warranty

 * All rights reserved (C) 2005, Mohamed Meligy

 * http://weblogs.asp.net/meligy

 * All rights reserved (C) 2010, Mohamed Meligy

 * http://gurustop.net

 * Distribution of this code without this note is prohibited.

 ******************************************************************/

//Default "using" set of a new System.Web.UI.Page Visual Studio 2005 template:

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

/// <summary>

/// To test the GridView behavior in action,

/// you need to have SQL Server Express installed (comes by default with VS2005),

/// and Northwind database attached to it

/// (attaches by default when you select "Quickstart Tutorials"

/// from the .NET Framework 2.0 SDK Programs menu, and choose to install them).

/// Alternatively, change the ConnectionString property of the SqlDataSource

/// to point to another installed instance

/// of SqlServer 2000 or SqlServer 2005 that has Northwind database attached.

/// </summary>

public partial class GridViewSampler1 : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        //Limiting redundancy of useless execution.

        //You do no need to check IsCallback if you

        // don't have controls with Callback Enabled.

        if (!IsPostBack & !IsCallback)

        {

            //This makes performing paging and sorting uses AJAX.

            GridView1.EnableSortingAndPagingCallbacks = true;

            //Small number so that I can see many oages out of

            // 9 rows only (Yhe total Rows Count of Northwind's Employees DataTable).

            //Also selected it in a way that last Page Rows Count will be

            // different than other pages.

            GridView1.PageSize = 2;

            if (!IsPostBack)   //Just to prove the AJAX thing.

            {

                PostBackStatus.Text = "Not PostBack";

            }

            else   //Never happens, as I don't require a PostBack.

            {

                PostBackStatus.Text = "Page Is PostBack";

            }

        }

    }

    /// <summary>

    /// Executes when the databinding is complete

    /// </summary>

    protected void GridView1_DataBound(object sender, EventArgs e)

    {

        //I'll use it to show which set of Rows I'm showing in the page.

        GridView1.ShowFooter = true;

        //Similar to: GridView1.FooterRow.Visible = true

        //Stretching the first cell to fill the whole FooterRow:

        //Removing all non needed cells,

        // from the end to start

        // (so that the Cells collection is not recreated with every Removal).

        for (int cellNum = GridView1.Columns.Count - 1; cellNum > 0; cellNum--)

        {

            GridView1.FooterRow.Cells.RemoveAt(cellNum);

        }

        GridView1.FooterRow.Cells[0].ColumnSpan = GridView1.Columns.Count;

        GridView1.FooterRow.Cells[0].HorizontalAlign = HorizontalAlign.Center;

        int startIndex = GridView1.PageIndex != GridView1.PageCount - 1 ?

        //Not in last page.

        GridView1.PageSize * GridView1.PageIndex

        //GridView1 Rows Count is Count of the Rows of the current page, so,

            // unless Paging is Disabled, this is not total Rows Count.

            //gridViewTotalCount is declared and assigned just after this method.

        : gridViewTotalCount - GridView1.PageSize + GridView1.Rows.Count;

        GridView1.FooterRow.Cells[0].Text =

            string.Format

                ("Showing Employees {0} to {1} of {2}",

                startIndex + 1,

                startIndex + GridView1.Rows.Count, gridViewTotalCount);

    }

    TableCell myCell = null;

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

    {

        //I'll add that to every Row bound in the GridView.

        myCell = new TableCell();

        //Note that for the header, footer, and separator rows, DataItemIndex is -1

        myCell.Text = e.Row.DataItemIndex.ToString();

        //Note that when you add the cell,

        // this does NOT increase the GridView Columns Count.

        e.Row.Cells.Add(myCell);

        //The past lines will affect also HeaderRow, FooterRow, and even Pager,

        // you'll see when you run that this is not a desired behavior.

        //You can limit your code on condition. This is the recommended way.

        if (e.Row.RowType == DataControlRowType.DataRow)

        {

            //Do your UI logic now for data binding,

            // much similar to DataGrid ItemDataBound.

            //Example: changing color of text

            // for normal and alternative rows ONLY by code.

            if (e.Row.RowIndex % 2 == 0)

            {

                e.Row.Style["color"] = "#0000ff";

            }

            else

            {

                e.Row.Style["color"] = "#00bb00";

            }

            //This is the EmployeeID Cell

            e.Row.Cells[0].Text =

                "I'm alternative employee with code: " + e.Row.Cells[0].Text;

            //Another sample change making use of the DataItem:

            // This is specific to our case where the GridView is bound to

            // first DataTable in the DataSet returnd by the EmployeesSqlSource.

            // This is when SqlDataSource DataSourceMode = DataSet (Default)

            DataRowView rowView = (DataRowView)e.Row.DataItem;

            e.Row.Cells[GridView1.Columns.Count - 1].Text =

                int.Parse(rowView["Extension"] as string).ToString("###-##");

        }

    }

    int gridViewTotalCount;

    protected void EmployeesSqlSource_Selected

        (object sender, SqlDataSourceStatusEventArgs e)

    {

        //GridView has no way of telling total Rows Count when paging is enabled.

        gridViewTotalCount = e.AffectedRows;

    }

}

<%@ Page Language="C#" AutoEventWireup="true" 

    CodeBehind="GridViewSampler1.aspx.cs"

 Inherits="GridViewSampler1"

    %>

<!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 id="PageHeader" runat="server">

    <title>GridView Sample</title>

</head>

<body>

    <form id="form1" runat="server">

        <div>

        Postback Status:

            <asp:Label ID="PostBackStatus" runat="server"></asp:Label>

            <asp:GridView ID="GridView1" runat="server"

                AutoGenerateColumns="False" AllowPaging="True"

                DataSourceID="EmployeesSqlSource" DataKeyNames="EmployeeID"

                OnDataBound="GridView1_DataBound"

                OnRowDataBound="GridView1_RowDataBound">

                <Columns>

                    <asp:BoundField DataField="EmployeeID"

                        HeaderText="EmployeeID" InsertVisible="False"

                        ReadOnly="True" SortExpression="EmployeeID" />

                    <asp:BoundField DataField="LastName"

                        HeaderText="LastName" SortExpression="LastName" />

                    <asp:BoundField DataField="FirstName"

                        HeaderText="FirstName" SortExpression="FirstName" />

                    <asp:BoundField DataField="Title"

                        HeaderText="Title" SortExpression="Title" />

                    <asp:BoundField DataField="BirthDate"

                        HeaderText="BirthDate" SortExpression="BirthDate" />

                    <asp:BoundField DataField="PostalCode"

                        HeaderText="PostalCode" SortExpression="PostalCode" />

                    <asp:BoundField DataField="Extension"

                        HeaderText="Extension" SortExpression="Extension" />

                </Columns>

                <EmptyDataTemplate>

                    <div style="text-align: center">

                        No Data Available.

                    </div>

                </EmptyDataTemplate>

            </asp:GridView>

            <asp:SqlDataSource ID="EmployeesSqlSource" runat="server"

                ConnectionString=

"Data Source=MELIGYSQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"

                ProviderName="System.Data.SqlClient"

                SelectCommand=

"SELECT [EmployeeID], [LastName], [FirstName], [Title], [BirthDate], [PostalCode], [Extension] FROM [Employees]"

                OnSelected="EmployeesSqlSource_Selected"></asp:SqlDataSource>

        </div>

    </form>

</body>

</html>