Loading

Datatable colum

Datatable colum

Ramco Ramco

3y825.NET

Hi

I have below data in Datatable . I want to save the value of colum header in a variable i.e LeadNumber.

foreach (DataRow colum in dt.Rows)
                {

LeadNumber	LeadSource
1	Email Marketing
2	Website

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Naimish Makwana3y ago
Accepted answer
Hello Ramco,

You can access the value of the column header "LeadNumber" using the Columns property of the DataTable object and then retrieve the ColumnName property of the corresponding DataColumn object. Here's an example:
```
string leadNumberColumnName = dt.Rows[0].Table.Columns[0].ColumnName;
```
This will give you the string "LeadNumber", assuming that the "LeadNumber" column is the first column in the DataTable. You can replace the index 0 with the actual index of the row that contains the column headers.

Thanks

Naimish Makwana
+1
Jignesh Kumar3y ago
Hello,

You can get column header using below code,
```
string[] columnNames = dt.Columns.Cast()
                                 .Select(x => x.ColumnName)
                                 .ToArray();  
```
Above code will return all columns from your data table
+1