DbDataReader.GetInt32(Int32) DbDataReader.GetInt32(Int32) DbDataReader.GetInt32(Int32) DbDataReader.GetInt32(Int32) Method

定义

在派生类中重写时,以 32 位带符号整数的形式获取指定列的值。When overridden in a derived class, gets the value of the specified column as a 32-bit signed integer.

public:
 abstract int GetInt32(int ordinal);
public abstract int GetInt32 (int ordinal);
abstract member GetInt32 : int -> int
Public MustOverride Function GetInt32 (ordinal As Integer) As Integer

参数

ordinal
Int32 Int32 Int32 Int32

从零开始的列序号。The zero-based column ordinal.

返回

指定列的值。The value of the specified column.

实现

异常

指定的强制转换无效。The specified cast is not valid.

注解

private static void GetCredits(String connectionString) 
{
    using (SqlConnection conn = new SqlConnection(connectionString)) 
    {
        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 32-bit signed integer.                       
                    Console.WriteLine("Course:{0,-15} Credits:{1}",reader[1],reader.GetInt32(2));   
                }
            }
        }
    }
}  

适用于

另请参阅