Mapping a GridBoundColumn to the underlying DataColumn

[Doug Lind]

Hi,

I need to evaluate the source DataColumn datatype for some GridBoundColumns in a GridBoundColumnsCollection. Is there a way to get to the source DataColumn using a GridBoundColumn or its index within the GridBoundColumnsCollection?

Thanks,

Doug Lind

[Administrator]

GridBoundColumn.MappingName holds the name of the DataColumn.

//get the datacolumn for the 3rd col in grid
			string dataTableColumnName = this.gridDataBoundGrid1.GridBoundColumns[2].MappingName;
DataColumn dc = this.dataTable1.Columns[dataTableColumnName];
            

[Doug Lind]

Thanks for the response Clay.

I was hoping to avoid having to evaluate the DataSource type (DataSet, DataTable, etc), to extract the underlying "table". In a reponse to one of my previous questions, you steered me towards using the CurrencyManager to extract the underlying DataRow based upon the grid row index. Is there some method like this for retrieving a DataColumn based upon the grid column index?

Doug

> GridBoundColumn.MappingName holds the name of the DataColumn.
>
>

> //get the datacolumn for the 3rd col in grid
> 			string dataTableColumnName = this.gridDataBoundGrid1.GridBoundColumns[2].MappingName;
> DataColumn dc = this.dataTable1.Columns[dataTableColumnName];

            

[Administrator]

There is a PropertyDescriptor property you can use, it it can only returns values not a whole column.

//the value from the 5 item in the 3rd column.
int item = 5;
CurrencyManager cm = (CurrencyManager)this.BindingContext[this.gridDataBoundGrid1.DataSource, this.gridDataBoundGrid1.DataMember];
object o = cm.List[item];
PropertyDescriptor pd = this.gridDataBoundGrid1.Binder.InternalColumns[2].PropertyDescriptor;
object val = pd.GetValue(o);
Console.WriteLine(val);