Help on How to Return DataRow's Column Name

Question

User140238589 posted

 Can someone help me on how to return DataRow's column name? Like:

Dim row as DataRow  = dt.Table(0).Row(0)

MsgBox "Column: " & ColumnName & " Value: " & row("ColumnName")

Where ColumnName is the table's column in the database.

 

Thanks in advance!

 

jun2
 

Answer 1

User-587930081 posted

Hi,

Use the below code, you will get the column name. 

DataRow.Table.Columns(0).ColumnName;

 

Answer 2

User445179017 posted

To access the column names, use the Columns collection on datatable.


DataTable dt = new DataTable();
string colName = dt.Columns[0].ColumnName.ToString();
string colValue = dt.Rows[0][0].ToString();

Thanks

-Mark post(s) as "Answer" that helped you

Answer 3

User140238589 posted

Thanks guys! It really helped. 

Answer 4

User-1442337237 posted

me too :P

thx

Answer 5

User1374376170 posted

Thanks

It is very use full

Answer 6

User273921512 posted

Hi,

You can avoid loops, just need to check as below

dtTableSorted.Columns.Contains("Col Name")

dtTableSorted: datatable name

Col Name: Column Name you want to check whether it exists in datatable