想得到数据所有支持的数据类型(GetSchema的使用)

using System;
 using System.Collections.Generic;
using System.Linq;
using System.Text;
using WCFService2;
using System.Data;
using System.Data.OracleClient;
using System.ComponentModel;
using System.Data.SqlClient;
using System.Data.OleDb;
namespace testxcode
{
    class Program
    {
        static void OutPut(DataRow dt, DataColumnCollection colCollection)
        {
            for (int i = 0; i < colCollection.Count; i++)
            {
                Console.Write("\r\n["+colCollection[i].ToString()+"]:" + dt[i].ToString() + "\r\n");
              
            }
              Console.Write("____________________________________________\r\n");
        }
        static void Main(string[] args)
        {
            Console.WriteLine(XLog.XTrace.LogPath);
            OracleConnection conntest = new OracleConnection("Data Source=Local;user id=ws;password=MCenter.finfo.CC;");
            conntest.Open();
            DataTable dttest = conntest.GetSchema();
            foreach (DataRow row in dttest.Rows)
            {
                OutPut(row, dttest.Columns);
            }
            Console.Read();
            return;
            //   Console.WriteLine(Sys_config.Find(Sys_config._.Configkey, "SerHost").Configvalue);
            OracleConnection conn = new OracleConnection("Data Source=Local;user id=ws;password=MCenter.finfo.CC;");
            Console.WriteLine("oracle11g");
            XLog.XTrace.WriteLine("oracle11g");
            conn.Open();
            DataTable dt = conn.GetSchema("DATATYPES");
            foreach (DataRow item in dt.Rows)
            {
                Console.WriteLine(item[0].ToString()+":"+item["DataType"].ToString());
                XLog.XTrace.WriteLine(item[0].ToString() + ":" + item["DataType"].ToString());
            }
            conn.Close();
            XLog.XTrace.WriteLine("C#不支持的类型:binary_double,binary_float");












            SqlConnection sqlconn = new SqlConnection("server=.;database=test;uid=sa;pwd=gaoshengjie");
            Console.WriteLine("sqlserver2008");
            XLog.XTrace.WriteLine("sqlserver2008");
            sqlconn.Open();
            foreach (DataRow item in sqlconn.GetSchema("DATATYPES").Rows)
            {
                Console.WriteLine(item[0].ToString() + ":" + item["DataType"].ToString());
                XLog.XTrace.WriteLine(item[0].ToString() + ":" + item["DataType"].ToString());
            }
            sqlconn.Close();












            OleDbConnection OleDbconn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=test.mdb;Persist Security Info=False;");
            Console.WriteLine("ACCESS");
            XLog.XTrace.WriteLine("ACCESS");
            OleDbconn.Open();
            foreach (DataRow item in OleDbconn.GetSchema("DATATYPES").Rows)
            {
                Console.WriteLine(item[0].ToString() + ":" + item["DataType"].ToString());
                XLog.XTrace.WriteLine(item[0].ToString() + ":" + item["DataType"].ToString());
            }
            OleDbconn.Close();
            
            Console.Read();
        }
    }
}