Datagrid column headers

[plsh]

Good day,

I have a problem that is really irratating. I have a datagrid that is bound. It is automatically filled with all the fields in the dataset. The only thing is that when the datagrid is populated the column order is different to that of the dataset. I don't mind the columns been all jumbled up but I do need to know which column is where.

So my question is, is there a way in which I can read the column header text directly from the datagrid as the datagrid and dataset column order do not match and need the order of the datagrid?

Cheers

 

[sbdSolna]

Here are an example which I have to make columns from a dataset to Excel.

int colIndex = 0;
foreach(DataColumn col in dataSet.Tables["Result"].Columns)
{
   colIndex++;	
   excel.Cells[1,colIndex]=col.ColumnName;			
}

 

[plsh]

Hi sbdSolna,

Thanks, but that unfortunately doesnt help me at all. The order of the columns is different in the dataset and the datagrid, I need to and have to read the column headers out of the datagrid. I cannot access the dataset in a conventional way as you have, I HAVE TO ACCESS THE DATAGRID.

THANKS IN ADVANCE

 

[DaZZleD]

if you know what type is the DataSource of the DataGrid, you can cast it and then access all the data you need, including the column names.

--------------------------
"two wrongs don't make a right, but three lefts do" - the unknown sage

 

[sbdSolna]

Hi again
---------
Here is the solution

				DataGridTableStyle dgtStyle = dataGrid.TableStyles[0];
				foreach(DataGridColumnStyle gcs in dgtStyle.GridColumnStyles) {
					colIndex++;	
					excel.Cells[rowIndex,colIndex]=gcs.HeaderText;
				}
	
				DataView dataView = (DataView) ((CurrencyManager) dataGrid.BindingContext[dataGrid.DataSource,
					dataGrid.DataMember]).List;
			
				foreach(DataRow dr in dataView.Table.Rows) {
					// iterate the cells
					rowIndex++; 
					colIndex = 0; 
					foreach(DataGridColumnStyle gcs in dgtStyle.GridColumnStyles) {
						colIndex++;
						excel.Cells[rowIndex,colIndex] = dr[gcs.MappingName];
					}
				}