datarow by column name

Question

I am using this code:

Dim dr() As DataRow = datatable.Select("id='" & st)
For i = 0 To dr.GetUpperBound(0)
    result = dr(i)(2).ToString()
Next i

How do I get result by column name instead of dr(i)(2)? Because if I add a column to that data table in front, then I get the wrong data, I should use dr(i)(3). So I want to overcome this without changing source code in the future. Something like dr(i)("column_name").ToString()

Solution

Exactly like you wrote it:

dr(i)("column_name").ToString()

MSDN reference:

• DataRow.Item Property (String)

For strongly typed value of other types (for example, Integer, you could use Field(Of T) extension):

• DataRowExtensions.Field(Of T) Method (DataRow, String)

In your case,

dr(i).Field(Of String)("column_name")

Comments

[Tim Schmelter]

Indices are zero based in .NET.