Home Library Learn Downloads Support Community
Sign in | United States - English | |
This topic has not yet been rated - Rate this topic

SqlDataReader.GetValue Method

.NET Framework 4

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

Namespace:  System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)
C#
C++
F#
VB
Copy 
public override Object GetValue(
	int i
)

Parameters

i
Type: System.Int32
The zero-based column ordinal.

Return Value

Type: System.Object
This method returns DBNull for null database columns.

Implements

IDataRecord.GetValue(Int32)
IDataRecord.GetValue(Int32)

GetValue returns data using the .NET Framework types.

.NET Framework

Supported in: 4, 3.5, 3.0, 2.0, 1.1, 1.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
Related doc reference
According to http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getsqlvalue.aspx, GetValue returns a .NET Framework type
History
Doc conflict

http://msdn.microsoft.com/en-us/library/bb675168.aspx 
GetValue  -  Retrieves the specified column value as its underlying CLR type.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getvalue.aspx  
GetValue   -  Gets the value of the specified column in its native format

Which one is it?  The Native format (EG SqlDateTime since it is a SQL Server), or the CLR Type? 

History