DataTableReader.GetDataTypeName(Int32) 方法

定義

命名空間:

System.Data

組件:

System.Data.Common.dll

來源:

DataTableReader.cs

取得字串，表示指定之資料行的資料型別。

public:
 override System::String ^ GetDataTypeName(int ordinal);

public override string GetDataTypeName (int ordinal);

override this.GetDataTypeName : int -> string

Public Overrides Function GetDataTypeName (ordinal As Integer) As String

參數

ordinal

Int32

以零為基底的資料行序數。

傳回

String

字串，表示資料行的資料型別。

例外狀況

ArgumentOutOfRangeException

傳遞的索引超出 0 到 FieldCount - 1 的範圍。

InvalidOperationException

嘗試在關閉的 DataTableReader 中讀取或存取資料行。

範例

下列主控台應用程式會顯示來自簡單 DataTable的欄位及其類型名稱清單：

private static void TestGetTypeName()
{
    DataTable table = GetCustomers();
    using (DataTableReader reader = new DataTableReader(table))
    {
        for (int i = 0; i < reader.FieldCount; i++)
        {
            Console.WriteLine("{0}: {1}", reader.GetName(i),
                reader.GetDataTypeName(i));
        }
    }
    Console.WriteLine("Press Enter to finish.");
    Console.ReadLine();
}

private static DataTable GetCustomers()
{
    // Create sample Customers table, in order
    // to demonstrate the behavior of the DataTableReader.
    DataTable table = new DataTable();
    // Create two columns, ID and Name.
    DataColumn idColumn = table.Columns.Add("ID", typeof(int));
    table.Columns.Add("Name", typeof(string ));
    // Set the ID column as the primary key column.
    table.PrimaryKey = new DataColumn[] { idColumn };

    table.Rows.Add(new object[] { 1, "Mary" });
    table.Rows.Add(new object[] { 2, "Andy" });
    table.Rows.Add(new object[] { 3, "Peter" });
    table.Rows.Add(new object[] { 4, "Russ" });
    return table;
}

Private Sub TestGetTypeName()
   Dim table As DataTable = GetCustomers()
   Using reader As New DataTableReader(table)
      For i As Integer = 0 To reader.FieldCount - 1
         Console.WriteLine("{0}: {1}", _
            reader.GetName(i), reader.GetDataTypeName(i))
      Next
   End Using

   Console.WriteLine("Press Enter to finish.")
   Console.ReadLine()
End Sub

Private Function GetCustomers() As DataTable
   ' Create sample Customers table, in order
   ' to demonstrate the behavior of the DataTableReader.
   Dim table As New DataTable

   ' Create two columns, ID and Name.
   Dim idColumn As DataColumn = table.Columns.Add("ID", _
     GetType(Integer))
   table.Columns.Add("Name", GetType(String))

   ' Set the ID column as the primary key column.
   table.PrimaryKey = New DataColumn() {idColumn}

   table.Rows.Add(New Object() {1, "Mary"})
   table.Rows.Add(New Object() {2, "Andy"})
   table.Rows.Add(New Object() {3, "Peter"})
   table.Rows.Add(New Object() {4, "Russ"})
   Return table
End Function

主控台視窗會顯示下列結果：

ID: Int32  
Name: String  

備註

方法 GetDataTypeName 一律會傳回基礎 DataColumn 的類型，而不是提供者特定的型別。