DbDataReader::GetDataTypeName Method (Int32)

.NET Framework (current version)

Gets name of the data type of the specified column.

Namespace: System.Data.Common
Assembly: System.Data (in System.Data.dll)

Syntax

public:
virtual String^ GetDataTypeName(
	int ordinal
) abstract

Parameters

ordinal: Type: System::Int32
The zero-based column ordinal.

Return Value

Type: System::String^

A string representing the name of the data type.

Implements

IDataRecord::GetDataTypeName(Int32)

Exceptions

Exception	Condition
InvalidCastException	The specified cast is not valid.

Remarks

private static void GetDataTypes(String connectiongString) {     
   using (SqlConnection conn = new SqlConnection(connectiongString)) {
      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));
            }
         }
      }
   }
}

Version Information

Universal Windows Platform
Available since 10
.NET Framework
Available since 2.0