DataGridColumnN ame based on DataGrid.Curren tCell

[Strahimir Antoljak]

Is it possible (and how?) to get the data grid column name
based on the DataGrid.Curren tCell?

The DataGrid has assigned a TableStyle comprising
selected columns (DataGridTextBo xColumn) from
the source DataTable (DataGrid.DataS ource=DataTable ).
I would like to be able to get the column name of the
datagrid based on the DataGrid current cell so I can reference
the appropriate column in the source DataTable.

Thanks,

--
Strah @ Langan

[William Ryan eMVP]

You can use the ColumnIndex of the CurrentCell property to reference the
underlying datatable's colum.columnNam e property. So if ColumnIndex of the
current cell is 1, then you can use DataTable.Colum ns(1).ColumnNam e to get
this info. You can just substitute it where I hard coded 1.

HTh,

Bill
"Strahimir Antoljak" <st***@netzero. net> wrote in message
news:Oi******** *****@TK2MSFTNG P10.phx.gbl...

Is it possible (and how?) to get the data grid column name
based on the DataGrid.Curren tCell?

The DataGrid has assigned a TableStyle comprising
selected columns (DataGridTextBo xColumn) from
the source DataTable (DataGrid.DataS ource=DataTable ).
I would like to be able to get the column name of the
datagrid based on the DataGrid current cell so I can reference
the appropriate column in the source DataTable.

Thanks,

--
Strah @ Langan

[adamz5]

use the mouse down event on the datagrid

and use System.Windows. Forms.DataGrid. HitTestInfo to get pos of column

something like:

objHitTest = Dgd.HitTest(e.X , e.Y)
Select Case objHitTest.Type
Case System.Windows. Forms.DataGrid. HitTestType.Cel l
strPartHit = "Cell"
Case System.Windows. Forms.DataGrid. HitTestType.Col umnHeader
strPartHit = "ColumnHead er"
Case System.Windows. Forms.DataGrid. HitTestType.Col umnResize
strPartHit = "Resize"
Case System.Windows. Forms.DataGrid. HitTestType.Cap tion
strPartHit = "Caption"
Case System.Windows. Forms.DataGrid. HitTestType.Par entRows
strPartHit = "ParentRows "
Case System.Windows. Forms.DataGrid. HitTestType.Row Header
strPartHit = "RowHeader"
If e.Clicks = 2 Then
'run your code here
End If
Case System.Windows. Forms.DataGrid. HitTestType.Row Resize
strPartHit = "RowResize"
Case System.Windows. Forms.DataGrid. HitTestType.Non e
strPartHit = "None"
Case Else
strPartHit = "Unknown"
End Select

from here get your currentrowindex

[Cor Ligthert]

Hi Strah,

Can you try this one (it is one long sentence)
Dim name As String =
DataGrid1.Table Styles(0).GridC olumnStyles(Dat aGrid1.CurrentC ell.ColumnNumbe r
).MappingName

I hope this works easy?

Cor

[Strahimir Antoljak]

thanks Hth but this would not work in my
case as I am using a TableStyle comprising
selected columns from the DataTable, which
means ColumnIndex property of the CurrentCell
does not necessarily match the column index
in the DataTable; the DataTable has 11 columns
while TableStyle can have any number of columns
between 2 and 11 - so I create TableStyle that
contains 2nd, 4th and 8th column in the DataTable,
but in DataGrid they have indices 0, 1, 2.

Thanks again,

--
Strah @ Langan

"William Ryan eMVP" <bi**@NoSp4m.de vbuzz.com> wrote in message
news:O4******** *****@TK2MSFTNG P11.phx.gbl...

You can use the ColumnIndex of the CurrentCell property to reference the
underlying datatable's colum.columnNam e property. So if ColumnIndex of the current cell is 1, then you can use DataTable.Colum ns(1).ColumnNam e to get
this info. You can just substitute it where I hard coded 1.

HTh,

Bill
"Strahimir Antoljak" <st***@netzero. net> wrote in message
news:Oi******** *****@TK2MSFTNG P10.phx.gbl...

Is it possible (and how?) to get the data grid column name
based on the DataGrid.Curren tCell?

The DataGrid has assigned a TableStyle comprising
selected columns (DataGridTextBo xColumn) from
the source DataTable (DataGrid.DataS ource=DataTable ).
I would like to be able to get the column name of the
datagrid based on the DataGrid current cell so I can reference
the appropriate column in the source DataTable.

Thanks,

--
Strah @ Langan

[Strahimir Antoljak]

Thanks adamz5.... I am testing it right now,
looks good.

--
Strah @ Langan

"adamz5" <ad****@hotmail .com> wrote in message
news:40******** *************** ***@posting.goo gle.com...

use the mouse down event on the datagrid

and use System.Windows. Forms.DataGrid. HitTestInfo to get pos of column

something like:

objHitTest = Dgd.HitTest(e.X , e.Y)
Select Case objHitTest.Type
Case System.Windows. Forms.DataGrid. HitTestType.Cel l
strPartHit = "Cell"
Case System.Windows. Forms.DataGrid. HitTestType.Col umnHeader strPartHit = "ColumnHead er"
Case System.Windows. Forms.DataGrid. HitTestType.Col umnResize strPartHit = "Resize"
Case System.Windows. Forms.DataGrid. HitTestType.Cap tion
strPartHit = "Caption"
Case System.Windows. Forms.DataGrid. HitTestType.Par entRows
strPartHit = "ParentRows "
Case System.Windows. Forms.DataGrid. HitTestType.Row Header
strPartHit = "RowHeader"
If e.Clicks = 2 Then
'run your code here
End If
Case System.Windows. Forms.DataGrid. HitTestType.Row Resize
strPartHit = "RowResize"
Case System.Windows. Forms.DataGrid. HitTestType.Non e
strPartHit = "None"
Case Else
strPartHit = "Unknown"
End Select

from here get your currentrowindex

[Strahimir Antoljak]

Cor,

this is not first time you helped me with elegant solutions.
It works like a charm. Many thanks.

--
Strah @ Langan

"Cor Ligthert" <no**********@p lanet.nl> wrote in message
news:O6******** *****@TK2MSFTNG P09.phx.gbl...

Hi Strah,

Can you try this one (it is one long sentence)
Dim name As String =
DataGrid1.Table Styles(0).GridC olumnStyles(Dat aGrid1.CurrentC ell.ColumnNumbe r ).MappingName

I hope this works easy?

Cor