Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
GetDataTypeName Method

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