DbDataReader.GetDataTypeName(Int32) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
When overridden in a derived class, gets name of the data type of the specified column.
public:
abstract System::String ^ GetDataTypeName(int ordinal);
public abstract string GetDataTypeName (int ordinal);
abstract member GetDataTypeName : int -> string
Public MustOverride Function GetDataTypeName (ordinal As Integer) As String
Parameters
- ordinal
- Int32
The zero-based column ordinal.
Returns
The name of the data type.
Implements
Exceptions
The column index is out of range.
Remarks
private static void GetDataTypes(String connectionString)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
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));
}
}
}
}
}
Applies to
See also
Werk met ons samen op GitHub
De bron voor deze inhoud vindt u op GitHub, waar u ook problemen en pull-aanvragen kunt maken en bekijken. Raadpleeg onze gids voor inzenders voor meer informatie.