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)
.NET Framework (current version)
Gets the value of the specified column as a 32-bit signed integer.
Assembly: System.Data (in System.Data.dll)
Parameters
- ordinal
-
Type:
System::Int32
The zero-based column ordinal.
Implements
IDataRecord::GetInt32(Int32)| 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
Available since 10
.NET Framework
Available since 2.0
Show: