I am trying to retrieve the column headers from a DataRow object. Searched a few posts but doesn’t solve the problem.
Say
We have a dataRow object called “date” with value {“2021”,“09”,“07”}
Is that possible to retrieve a list of headers like {Year,Month, Day}?
So I can check whether this list contains, say Hour, Minutes or seconds?
prasath_S
(prasath S)
2
Hi @curtis971014
We can take headers from datatable into list like below
dt.columns.cast(of datacolumn).select(function (col) col.columnname.tostring).tolist
Thanks
1 Like
Yoichi
(Yoichi)
3
Hi,
Let’s say dr as DataRow.
Then
dr.Table.Columns
returns DataColumnCollection
IF you want to get array of column name, the following will work.
dr.Table.Columns.Cast(Of DataColumn).Select(Function(c) c.ColumnName).ToArray
Regards,
2 Likes
Great. It works!! Thank you.
1 Like
system
(system)
Closed
5
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.