Problem in binding DataBound Column in DataGrid

Question

Problem in Binding Databound Columns of DataGrid.

I am using C#.net, Visual Web Developer 2005, SQL Server 2000.

I have a datagrid in my WebForm which has some Template Columns and DataBound Columns.

Now in One of my Bound Column, I would like to display database results based on my SQL query.

I know that I can display it using following code in HTML(.aspx file).

<asp:BoundColumn DataField="OSP_FSD" HeaderText="ETD Date" DataFormatString ="{0:MM/dd/yyyy}"></asp:BoundColumn>

Where OSP_FSD is one of the Database column name.

But My problem is I can not put DataField = "OSP_FSD" as it refers to only one column of database.

I have to bind ETD Date Column based on following cirteria. Split is one of the result of a main SQL query.

If Split = 1

{

// OSP_FSD is Database Column name

Bind it with OSP_FSD

}

else

{

// ORD_ETD is database column name

Bind it with ORD_ETD

}

I think I can not use DataItemBound Event has it just allows to play with binded data. and in my case I have to play with data before it binds the datagrid.

Please HELP!