Windows apps
Collapse the table of content
Expand the table of content
Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

DbDataReader::GetDataTypeName Method (Int32)

 

Gets name of the data type of the specified column.

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

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.

Exception Condition
InvalidCastException

The specified cast is not valid.

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

Universal Windows Platform
Available since 10
.NET Framework
Available since 2.0
Return to top
Show:
© 2017 Microsoft