DbDataReader.GetInt32 Method (Int32)


The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

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

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

abstract GetInt32 : 
        ordinal:int -> int


Type: System.Int32

The zero-based column ordinal.

Return Value

Type: System.Int32

The value of the specified column.

Exception Condition

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)) {
         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)); 

Universal Windows Platform
Available since 10
.NET Framework
Available since 2.0
Return to top