DbDataReader.GetDataTypeName(Int32) Metode

Definisi

Ruang nama:

System.Data.Common

Rakitan:

System.Data.Common.dll

Sumber:

DbDataReader.cs

Saat ditimpa di kelas turunan, mendapatkan nama jenis data kolom yang ditentukan.

public:
 abstract System::String ^ GetDataTypeName(int ordinal);

public abstract string GetDataTypeName (int ordinal);

abstract member GetDataTypeName : int -> string

Public MustOverride Function GetDataTypeName (ordinal As Integer) As String

Parameter

ordinal

Int32

Ordinal kolom berbasis nol.

Mengembalikan

String

Nama jenis data.

Penerapan

GetDataTypeName(Int32)

Pengecualian

IndexOutOfRangeException

Indeks kolom di luar rentang.

Keterangan

private static void GetDataTypes(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())
            {
                for (Int32 i = 0; i < reader.FieldCount; i++)
                {
                    Console.WriteLine("ColumnName:{0,-15}DataType:{1,-15}",reader.GetName(i),reader.GetDataTypeName(i));
                }
            }
        }
    }
}

Lihat juga

• Ringkasan ADO.NET