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_ColumnsTemplateASCX : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //Define SQL query
        string SqlQuery = @"SELECT CustomerID, CompanyName, ContactName 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();




        //Set column properties
        myDataGrid.Columns["CustomerID"].Width = 533;
        myDataGrid.Columns["CustomerID"].Template = "~/DataGrid/Templates/Orders.ascx";
        myDataGrid.Columns["CustomerID"].HeaderText = "Customer (CustomerID, CompanyName, ContactName):";
        myDataGrid.Columns["CompanyName"].Visible = false;
        myDataGrid.Columns["ContactName"].Visible = false;

    }
}