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);
string StrSQL =" Select IDX, Pwd, Name From PdsBoard ";
OleDbDataAdapter daPDS = new OleDbDataAdapter(StrSQL, strConn);
DataSet ds = new DataSet();
daPDS.Fill(ds, "PdsBoard");
DataTable tbl = ds.Tables[0];
Console.WriteLine(tbl.TableName + "DataTable의 정보");
foreach(DataColumn col in tbl.Columns)
Console.WriteLine("\t" + col.ColumnName + " - " + col.DataType.ToString());
}
}
}