test.cpp

Using ADO from C

#include <stdio.h>
#include <iostream.h>
#include <comdef.h>
#include <conio.h>
#include "Database.h"

char CnnStr[200]="Provider=SQLOLEDB.1;Persist Security Info=False;"\
				 "User ID=lab;Initial Catalog=pubs;Data "\
				 "Source=PRASUN@CSE" ;
char ErrStr[200];

int main()
{
	::CoInitialize(NULL);
	Database db;
	Table tbl;
	if(!db.Open("lab","cse-98",CnnStr))
	{
		db.GetErrorErrStr(ErrStr);
		cout<<ErrStr<<"\n";
	}
	if(!db.Execute("select * from authors order by au_fname,au_id",tbl))
	{
		db.GetErrorErrStr(ErrStr);
		cout<<ErrStr<<"\n";
	}
	/*if(!db.OpenTbl(ADODB::adCmdText,"select * from authors order by au_fname,au_id",tbl))
	{
		db.GetErrorErrStr(ErrStr);
		cout<<ErrStr<<"\n";
	}*/
	char id[100];
	if(!tbl.ISEOF())
		tbl.MoveFirst();
	
	while(!tbl.ISEOF())
	{
		if(tbl.Get("au_id",id))
			cout<<"\nid:"<<id;
		else
		{
			tbl.GetErrorErrStr(ErrStr);
			cout<<"\n"<<ErrStr<<"\n";
			break;
		}
		if(tbl.Get("au_fname",id))
			cout<<" fname:"<<id;
		else
		{
			tbl.GetErrorErrStr(ErrStr);
			cout<<"\n"<<ErrStr<<"\n";
			break;
		}

		tbl.MoveNext();
	}
	::CoUninitialize();
	return 0;
}