Export (0) Print
Expand All

DbDataReader.GetInt32 Method

Gets the value of the specified column as a 32-bit signed integer.

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

'Declaration
Public MustOverride Function GetInt32 ( _
	ordinal As Integer _
) As Integer

Parameters

ordinal
Type: System.Int32

The zero-based column ordinal.

Return Value

Type: System.Int32
The value of the specified column.

Implements

IDataRecord.GetInt32(Int32)

ExceptionCondition
InvalidCastException

The specified cast is not valid.

        private static void GetCredits(String connectiongString) {
           using (SqlConnection conn = new SqlConnection(connectiongString)) {
              String queryString = "Select [CourseID],[Title],[Credits] from [MySchool].[dbo].[Course]"; 
              using (DbCommand command = new SqlCommand(queryString, conn)) {
                 conn.Open(); 
                 using (DbDataReader reader = command.ExecuteReader()) {
                    while (reader.Read()) {
                       // Credits column is the integer column, and you can use the GetInt32 method                      
                       // to return a a 32-bit signed integer.                     
                       Console.WriteLine("Course:{0,-15} Credits:{1}",reader[1],reader.GetInt32(2)); 
                    }
                 }
              }
           }
        }

.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
Show:
© 2015 Microsoft