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_ColumnsHeaderText : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//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();
//Set column headers
myDataGrid.Columns["CustomerID"].HeaderText = "<span style='color:red;font-weight:bold;'>Customer</span>";
myDataGrid.Columns["CompanyName"].HeaderText = "<span style='color:green;font-weight:bold;'>Company</span>";
myDataGrid.Columns["ContactName"].HeaderText = "<span style='color:blue;font-weight:bold;'>Person</span>";
myDataGrid.Columns["Address"].HeaderText = "<span style='color:Maroon;font-weight:bold;'>Address</span>";
myDataGrid.Columns["PostalCode"].HeaderText = "<span style='color:#C615CA;font-weight:bold;'>Postal Code</span>";
}
}
|