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;

public partial class DataGrid_RunningMode : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        //Apply the Server Side Procedures
        myDataGrid.PageNumberChanged += new APNSoft.WebControls.DataGridEventHandler(myDataGrid_PageNumberChanged);
        myDataGrid.SortCommand += new APNSoft.WebControls.DataGridEventHandler(myDataGrid_SortCommand);

        //Define SQL query
        string SqlQuery = @"SELECT CustomerID, CompanyName, ContactName, Address, PostalCode " + 
            "FROM Customers ORDER BY CustomerID";

        //Get DataTable (MS Access Database)
        DataTable myDataSource = DataBase.GetDataTableOleDb(SqlQuery, "~/DataGrid/DataBases/Nwind.mdb");

        //Set the data source
        myDataGrid.KeyFieldName = "CustomerID";
        myDataGrid.DataSource = myDataSource;
        myDataGrid.DataBind();

    }

    void myDataGrid_PageNumberChanged(object sender, APNSoft.WebControls.DataGridEventArgs e)
    {
        lblHandler.Text = "<br/>";
        lblHandler.Text += "Event: <b>PageNumberChanged</b><br/>";
        lblHandler.Text += "Page number: <b>" + e.PageNumber.ToString() + "</b><br/><br/>";

    }


    void myDataGrid_SortCommand(object sender, APNSoft.WebControls.DataGridEventArgs e)
    {
        lblHandler.Text = "<br/>";
        lblHandler.Text += "Event: <b>SortCommand</b><br/>";
        lblHandler.Text += "Column name: <b>" + e.GridColumn.ColumnName + "</b><br/><br/>";
    }

}