When I bind a collection to a DataGrid (with teh single statement DataBind),
I love that the property names become the column names/values for the grid.
But I HATE that the columns are (seemingly?) displayed in random order -
i.e. I define a class with three properties: VehicleNumber, MgrLName, and
MgrFName. The grid displays as follows, which is neither the order in which
the properties were defined, or alphabetical order.
Can any one help me display these columns in the order I want
(VehicleNumber, MgrLName, and MgrFName)
MgrLName VehicleNumber MgrFName
Albritton 0294E John
Albritton 0294E John
Albritton 0294E John
private ArrayList spreadsheetSVRowsClass = new ArrayList();
ExcelVehicleColumnsSVClass colSV = new ExcelVehicleColumnsSVClass();
if (!myReader.IsDBNull((int)ExcelVehicleColumnsSV.Veh icleNum))
colSV.VehicleNumber =
myReader.GetString((int)ExcelVehicleColumnsSV.Vehi cleNum).Trim();
if (!myReader.IsDBNull((int)ExcelVehicleColumnsSV.Man agerLastName))
colSV.MgrLName =
myReader.GetString((int)ExcelVehicleColumnsSV.Mana gerLastName).Trim();
if (!myReader.IsDBNull((int)ExcelVehicleColumnsSV.Man agerFirstName))
colSV.MgrFName =
myReader.GetString((int)ExcelVehicleColumnsSV.Mana gerFirstName).Trim();
spreadsheetSVRowsClass.Add(colSV);
DataGrid1.DataSource = spreadsheetSVRowsClass;
DataGrid1.DataBind();
class ExcelVehicleColumnsSVClass
{
private string vehicleNumber;
private string mgrLName;
private string mgrFName;
public string VehicleNumber
{
get
{
return vehicleNumber;
}
set
{
vehicleNumber = value;
}
}
public string MgrLName
{
get
{
return mgrLName;
}
set
{
mgrLName = value;
}
}
public string MgrFName
{
get
{
return mgrFName;
}
set
{
mgrFName = value;
}
}
}
