DbDataReader.GetDataTypeName(Int32) DbDataReader.GetDataTypeName(Int32) DbDataReader.GetDataTypeName(Int32) DbDataReader.GetDataTypeName(Int32) Method

Definition

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 Int32 Int32 Int32

The zero-based column ordinal.

Returns

The name of the data type.

Implements

Exceptions

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

See also