I am using C#.Net, Visual web Developer, SQL server 2000.
I have a SQL query which I am binding it to a DataGrid.
SQL : "SELECT ord_number, ord_ID, ord_split, ord_Name, ETD_Date, OSP_FSD FROM ORDERS"
In My DataGrid I have a dynamic databound column.
I am able to bind one column to this databound column using following code.
BoundColumn ETDDate = new BoundColumn();
ETDDate.HeaderText = "ETD Date";
ETDDate.DataField = "OSP_FSD";
mygrid2.Columns.AddAt(ETDDate);
but now I want to bind this databound column based on the following criteria to two different database columns.
if(ord_split = 1)
{
ETDDate.DataField = "OSP_FSD";
}
else
{
ETDDate.DataField = "ETD_Date";
}
How to get value of ord_split before binding SQL to teh DataGrid? i.e I just want to take value of ord_split and not all the values of SQL.
Please Help!