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 =" {Call GetCount_Data(?)} ";
OleDbCommand cmd = new OleDbCommand(StrSQL, Cn);
OleDbParameter param;
param=cmd.Parameters.Add("@RowCnt", OleDbType.Integer);
param.Direction=ParameterDirection.Output;
OleDbDataReader rdr = cmd.ExecuteReader();
//역시 그냥 실행후
Console.WriteLine(" DataReader Before : " + param.Value);
while(rdr.Read()){}
//DataReader 읽은 후
Console.WriteLine(" DataReader After : " + param.Value);
while(rdr.NextResult()){}
//DataReader를 모두 읽은 후
Console.WriteLine(" DataReader 모두 읽은후 : " + param.Value);
rdr.Close();
Console.WriteLine(" DataReader.Close() : " + param.Value);
}
}
}