GetInt32 Method

DbDataReader.GetInt32 Method (Int32)


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

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

Public MustOverride Function GetInt32 (
	ordinal As Integer
) As Integer


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
© 2015 Microsoft