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 Where FormTypeID=1; " +
" Select IDX, Name, Title, Email From PdsBoard Where FormTypeID=2; " +
" Select IDX, Name, Title, Email From PdsBoard Where FormTypeID=3; ";
OleDbCommand Cmd = new OleDbCommand(StrSQL, Cn);
OleDbDataReader rdr = Cmd.ExecuteReader();
int intIDX = rdr.GetOrdinal("IDX");
int intName = rdr.GetOrdinal("Name");
int intTitle = rdr.GetOrdinal("Title");
int intEmail = rdr.GetOrdinal("Email");
do{
while(rdr.Read()){
Console.WriteLine(rdr[intIDX] + "\t" + rdr[intName] + "\t" + rdr[intTitle] + "\t" + rdr[intEmail]);
}
}while(rdr.NextResult());
}
}
}