using System;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
namespace DataReader
{
class Class1
{
[STAThread]
static void Main(string[] args)
{
string strConn="Provider=SQLOLEDB;User ID=sa;Password=gatsol;Initial Catalog=vins;Data Source=211.236.186.207;";
OleDbConnection Cn = new OleDbConnection(strConn);
Cn.Open();
string StrSQL =" Select IDX, Name, Title, Email From pdsBoard ";
OleDbCommand cmd = new OleDbCommand(StrSQL, Cn);
OleDbDataReader rdr = cmd.ExecuteReader();
DataTable tbl = rdr.GetSchemaTable();
foreach(DataRow row in tbl.Rows){
Console.WriteLine(row["ColumnName"] + "\t" + row["ColumnName"].GetType());
}
}
}
}