DataGrid Column

Hi,

I am using the following code but I want to change the column caption,
let's say for the AGE_DISTIBUTION..

// connect to database;
eziDatabase.DatabaseName = strDatabase;
eziDatabase.Cypher = CypherType.Blowfish;
eziDatabase.Password = "17218881";
eziDatabase.Parameters = 0;
eziDatabase.Exclusive = true;

eziDatabase.Connect();

// DataSet & dataGrid;
dsEziAgeband.Database = eziDatabase;
dsEziAgeband.TableName = "EZI_AGES";
dgEziAgeband.DataSource = dsEziAgeband;
dsEziAgeband.Open();
dsEziAgeband.ActiveIndex = "AGE_SERIAL";
// dgEziAgeband.CaptionText = "Age Distribution";

//Set filter to "select" all rows , "where" x >= 1 and x <= 2 and y = 1
dsEziAgeband.SetFilter("ezi_id = " + GlobalVariables.RecordId);

//If you want to hide some columns use next lines
dsEziAgeband.ShowHiddenColumns = false;
dsEziAgeband.Columns["AGE_ID"].Hidden = true;
dsEziAgeband.Columns["EZI_ID"].Hidden = true;
dsEziAgeband.Columns["AGE_SERIAL"].Hidden = true;
dsEziAgeband.Columns["HireDate"].DefaultCellStyle.Format = "y";
dsEziAgeband.Columns["AGE_DESCRIPTION"].Hidden = false;
dsEziAgeband.Columns["AGE_EMPLOYEE"].Hidden = false;
dsEziAgeband.Columns["PREM_RATE_PER_1000"].Hidden = false;
dsEziAgeband.Columns["SUM_INSURED"].Hidden = false;
dsEziAgeband.Columns["TOTAL_PREM"].Hidden = false;
dsEziAgeband.Columns["CREATED_BY_USER"].Hidden = true;
dsEziAgeband.Columns["CREATED_BY_IP"].Hidden = true;
dsEziAgeband.Columns["CREATED_BY_COMPUTER"].Hidden = true;
dsEziAgeband.Columns["CREATED_BY_OS"].Hidden = true;
dsEziAgeband.Columns["UPDATED_BY_USER"].Hidden = true;
dsEziAgeband.Columns["UPDATED_BY_IP"].Hidden = true;
dsEziAgeband.Columns["UPDATED_BY_COMPUTER"].Hidden = true;
dsEziAgeband.Columns["UPDATED_BY_OS"].Hidden = true;


Many Thanks,
Jassim Rahma

*** Sent via Developersdex http://www.developersdex.com ***