求一ansi c 操作adodb 对象的实例

要求连接sqlserver数据库,使用adodb.connection/recordset
需要从recordset中读数据
求一简单实例,wincc中只有ansi c的标准,用到了recordset后就不知道如何操作了

---

http://faq.csdn.net/read/179774.html
http://www.host01.com/article/database/mssql/0641302532285223.htm

参考

---

C/C++ code:

void New_Function(char *node)
{
static char sql[2000];
__object *adoconn;
__object *adord;
sprintf(sql,"select a.mdnodeid,b.ennum from meterdocu a join enflowrt b on a.mdnodeid=b.efnodeid and not exists eftime>(select max(eftime) from enflowrt where efnodeid=a.mdnodeid)");
adoconn=__object_create("ADODB.Connection");
adord=__object_create("ADODB.RecordSet");
if(adoconn!=NULL && adord!=NULL){
adoconn->ConnectionString="Provider=sqloledb;Data Source=192.168.1.47;Initial Catalog=energymeas;User Id=sa;Password=20010426;";
adoconn->Open();
adord=adoconn->Execute(sql);
while(! adord->eof){ //对象的属性集该如何使用?
SetTagFloat(adord->Fields[0]->Value,adord->Fields[1]->Value); //Return-Type: BOOL 对象的属性集该如何使用?是否可以 (char*)adord->Fields[0]->value .符号使用后编译不通过
adord->MoveNext();
}
adord->Close();
ado