Windows apps
Collapse the table of content
Expand the table of content
Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

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:
virtual int GetInt32(
	int ordinal
) abstract

Parameters

ordinal
Type: System::Int32

The zero-based column ordinal.

Return Value

Type: System::Int32

The value of the specified column.

Exception Condition
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)); 
            }
         }
      }
   }
}

Universal Windows Platform
Available since 10
.NET Framework
Available since 2.0
Return to top
Show:
© 2017 Microsoft