objRS 간단 사용 예제

// 예제 1
if(objRS.EOF){

   Response.Write("테이블이 비었습니다");

}else{

   while(!objRS.EOF){

      Response.Write(objRS('user'));

      objRS.MoveNext();

   }

}

// 예제 2

DBOpen();
var objRS = Server.CreateObject("ADODB.RecordSet");
var strSQL = "SELECT Pid FROM Table";
objRS.Open(strSQL, objDBCon, 0, 1);

Response.Write(objRS(0));
objRS = Null;

var strSQL = "INSERT INTO Table (Num, Pid) VALUES (1,"2");
objDBCon.Execute(strSQL);


objRS.Close();
objRS = Null
DBClose();