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 PB.IDX, Name, Title, Email, RegDATE, FormTypeName From PdsBoard as PB inner Join FormType as FT On PB.FormTypeID=FT.FormTypeID ";
OleDbCommand Cmd = new OleDbCommand(StrSQL, Cn);
OleDbDataReader rdr = Cmd.ExecuteReader();
while(rdr.Read()){
Console.WriteLine(rdr["idx"] + "\t" + rdr["Name"] + "\t" + rdr["Title"] + "\t" + rdr["Email"] + "\t" + rdr["FormTypeName"]);
}
}
}
}
