Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
GetValue Method

DataTableReader.GetValue Method

Gets the value of the specified column in its native format.

Namespace:  System.Data
Assembly:  System.Data (in System.Data.dll)

public override Object GetValue(
	int ordinal


Type: System.Int32

The zero-based column ordinal

Return Value

Type: System.Object
The value of the specified column. This method returns DBNull for null columns.




The index passed was outside the range of 0 to FieldCount - 1.


An attempt was made to retrieve data from a deleted row.


An attempt was made to read or access columns in a closed DataTableReader .

Although you can call IsDBNull to see if there are null values before calling this method, you do not have to do this.

The following example iterates through all the columns within the current row in a DataTableReader, displaying the contents of each column and the column name. Generally, if your intent is to work with all the columns within a row retrieved by a DataTableReader, consider using the GetValues method instead, because it is more efficient.

private static void GetAllValues(DataTableReader reader)
    // Given a DataTableReader, retrieve the value of  
    // each column, and display the name, value, and type. 
    // Make sure you have called reader.Read at least once before 
    // calling this procedure. 

    // Loop through all the columns. 
    object value = null;
    for (int i = 0; i < reader.FieldCount; i++)
        if (reader.IsDBNull(i))
            value = "<NULL>";
            value = reader.GetValue(i);
        Console.WriteLine("{0}: {1} ({2})", reader.GetName(i), 
            value, reader.GetFieldType(i).Name);

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

XNA Framework

Supported in: 3.0, 2.0, 1.0
© 2015 Microsoft