get index of DataTable column with name

Question

I have some code which sets the value of cells in a DataRow by column name i.e.

row["ColumnName"] = someValue;

I want to also set the value for this row in the column immediately to the right of the one found above. Clearly if I was getting the cell by index rather than by column name this would be easy. So is there a way of getting the column index from the column name thus allowing me to do:

row[index + 1] = someOtherValue;

i.e. do I need create some kind of dictionary of column index and column names when the table is initially created, or can I get the index from the column name later on without doing this?

Tim Schmelter · Accepted Answer · 2022-01-26T21:40:44.393

89

You can use DataColumn.Ordinal to get the index of the column in the DataTable. So if you need the next column as mentioned use Column.Ordinal + 1:

row[row.Table.Columns["ColumnName"].Ordinal + 1] = someOtherValue;

Warning:

This code returns the next column, so the one after ColumnName, as requested in the question.

edited Jan 26 '22 at 21:40

answered Jul 05 '12 at 08:14

Tim Schmelter

450,073
74
686
939

2

You don't need the `+ 1` just `row[row.Table.Columns["ColumnName"].Ordinal] = someOtherValue;` will do. – Piers Myers Jul 08 '14 at 15:52
5

@Piers: but OP needed the next column after another column. – Tim Schmelter Jul 08 '14 at 17:19
You should write `..to get the index of the NEXT column` then. I accidently used your line in my code while doing a mistake cuz of that +1. Thanks @PiersMyers for noticing it. – C4d Mar 14 '16 at 17:39
@TimSchmelter, How to get all columns index in an array? example: `Table.Columns[0,1,2,3,4,5,6,7]` – thevinaychoudhary Jun 20 '19 at 06:48

score 42 · Answer 2 · answered Jul 05 '12 at 08:17

42

Try this:

int index = row.Table.Columns["ColumnName"].Ordinal;

answered Jul 05 '12 at 08:17

Kell

3,252
20
19

2

+1 although as Tim beat you to it I'll mark his as the answer. – Andy Jul 05 '12 at 08:25

score 9 · Answer 3 · answered Dec 23 '15 at 09:11

9

You can simply use DataColumnCollection.IndexOf

So that you can get the index of the required column by name then use it with your row:

row[dt.Columns.IndexOf("ColumnName")] = columnValue;

answered Dec 23 '15 at 09:11

ebram khalil

8,252
7
42
60

Tom Beech · Answer 4 · 2015-01-15T09:57:11.020

3

I wrote an extension method of DataRow which gets me the object via the column name.

public static object Column(this DataRow source, string columnName)
{
    var c = source.Table.Columns[columnName];
    if (c != null)
    {
        return source.ItemArray[c.Ordinal];
    }

    throw new ObjectNotFoundException(string.Format("The column '{0}' was not found in this table", columnName));
}

And its called like this:

DataTable data = LoadDataTable();
foreach (DataRow row in data.Rows)
{        
    var obj = row.Column("YourColumnName");
    Console.WriteLine(obj);
}

edited Jan 15 '15 at 09:57

answered Apr 28 '14 at 10:43

Tom Beech

2,289
1
21
25

Should this extension throw "ObjectNotFoundException" instead of "ItemNotFoundException"?? http://msdn.microsoft.com/en-us/library/system.data.objectnotfoundexception%28v=vs.110%29.aspx – Jonathan Kittell Jan 09 '15 at 13:58
-1 DataRow has that already built in your example if you did row["YourColumnName"] it will return the content of that cell. If the column doesn't exist it throws System.ArguementException and this is the message {"Column 'YourColumnName' does not belong to table Table."} So unless this has some performance gain please delete. Also this doesn't answer the question of how to get the index. – DeadlyChambers May 25 '15 at 11:39

get index of DataTable column with name

4 Answers4

Warning:

Linked