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_ColumnsTemplateImages : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        //Define SQL query
        string SqlQuery = @"SELECT '0' as LineNumbers, ISBN, Title, Authors, Price FROM Books";

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

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

        //Format Columns
        myDataGrid.Columns["LineNumbers"].LineNumbers = true;
        myDataGrid.Columns["LineNumbers"].FormatType = typeof(System.String);
        myDataGrid.Columns["LineNumbers"].FormatString = "{0}.";
        myDataGrid.Columns["LineNumbers"].CssClass = "LineNumbers";
        myDataGrid.Columns["LineNumbers"].Width = 30;
        myDataGrid.Columns["LineNumbers"].Sortable = false;
        myDataGrid.Columns["LineNumbers"].Resizable = false;
        myDataGrid.Columns["LineNumbers"].HeaderText = "";

        myDataGrid.Columns["ISBN"].Visible = false;
        myDataGrid.Columns["Authors"].Visible = false;

        myDataGrid.Columns["Title"].Width = 420;
        myDataGrid.Columns["Title"].HeaderText = "Sort by Title";
        myDataGrid.Columns["Title"].Resizable = false;
        myDataGrid.Columns["Title"].Template = "~/DataGrid/Templates/Book.html";

        myDataGrid.Columns["Price"].Width = 100;
        myDataGrid.Columns["Price"].HeaderText = "Sort by Price";
        myDataGrid.Columns["Price"].Resizable = false;
        myDataGrid.Columns["Price"].Template = "~/DataGrid/Templates/BookPrice.html";

    }
}