GetDataTypeName Method

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 abstract string GetDataTypeName(
	int ordinal
)

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:
© 2016 Microsoft