Επεξεργασία

Κοινή χρήση μέσω

DbDataReader.GetInt32(Int32) Method

  • Reference

Definition

Namespace:
System.Data.Common
Assembly:
System.Data.Common.dll
Assembly:
System.Data.dll
Assembly:
netstandard.dll
Source:
DbDataReader.cs
Source:
DbDataReader.cs
Source:
DbDataReader.cs

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

Parameters

ordinal
Int32

The zero-based column ordinal.

Returns

Int32

The value of the specified column.

Implements

GetInt32(Int32)

Exceptions

IndexOutOfRangeException

The column index is out of range.

InvalidCastException

The specified cast is not valid.

Remarks

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

Applies to

See also