DbDataReader.GetInt32(Int32) Metode

Definisi

Ruang nama:

System.Data.Common

Rakitan:

System.Data.Common.dll

Sumber:

DbDataReader.cs

Saat ditimpa di kelas turunan, mendapatkan nilai kolom yang ditentukan sebagai bilangan bulat bertanda tangan 32-bit.

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

Parameter

ordinal

Int32

Ordinal kolom berbasis nol.

Mengembalikan

Int32

Nilai kolom yang ditentukan.

Penerapan

GetInt32(Int32)

Pengecualian

IndexOutOfRangeException

Indeks kolom di luar rentang.

InvalidCastException

Pemeran yang ditentukan tidak valid.

Keterangan

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

Lihat juga

• Ringkasan ADO.NET