Export (0) Print
Expand All

DbDataReader.GetDataTypeName Method

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.

Implements

IDataRecord.GetDataTypeName(Int32)

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

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

XNA Framework

Supported in: 3.0, 2.0, 1.0
Show:
© 2015 Microsoft