DbDataReader.GetDataTypeName(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

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

When overridden in a derived class, gets name of the data type of the specified column.

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

Parameters

ordinal: Int32

The zero-based column ordinal.

Returns

String

The name of the data type.

Implements

GetDataTypeName(Int32)

Exceptions

IndexOutOfRangeException

The column index is out of range.

Remarks

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

Applies to

แชร์ผ่าน