m_pSet->Open(AFX_DB_USE_DEFAULT_TYPE,"SELECT * from 00计本(9)");
//刷新窗口
OnInitialUpdate();
m_pSet->Close();
//刷新窗口
OnInitialUpdate();
m_pSet->Close();
解决方案 »
- 请教如何调用delphi写的DLL?
- XP Gina下无法保存用户配置信息
- gif2bmp怎么实现?
- 怎样用菜单的对话框来实现自己的类对象的初始化--调用此类的构造函数--并且为构造函数传递用户输入的参数(在对话框中)
- 堪称最为清新简洁的界面:CSDN浏览器,请评价
- 从今天开始学vc,我发誓一定要学好vc.
- 用别人的类来改变按钮的问题
- 如何进行强制关机!
- 计算机三级考什么内容?用delphi可以吗?
- 关于Socket多次连接不同IP和端口的问题?
- vc弄一个界面出来都很难,我都没有信心弄了,很想放弃,,放弃!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- 谁能给个direct8.1 sdk的下载地址?!---come on
CDatabase db;
db.OpenEx("DRIVER={SQL Server};Server=Cell;DATABASE=zhg;UID=sa;PWD=;");//change Cell to your computer name
//change zhg to your database name
CRecordset rs(&db);
rs.Open(AFX_DB_USE_DEFAULT_TYPE,"select type,AVG(price)'average price' From title where type<>'business' group by type");
while(rs.IsEOF()==false)
{
CString str;
CString strtype;
rs.GetFieldValue((short)0,strtype);
CDBVariant varprice;
rs.GetFieldValue(1,varprice);
str.Format("type:%s,avg(price):%f",strtype,varprice.m_dblVal);
AfxMessageBox(str);
rs.MoveNext();
}
rs.Close();
db.Close();
//Open ms access database
CDatabase db;
db.OpenEx("Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\temp\\db1.mdb;");
CRecordset rs(&db);
rs.Open(AFX_DB_USE_DEFAULT_TYPE,"select * From table1");
int nfieldcount=rs.GetODBCFieldCount();
CString msg;
msg.Format("There are %d fields in table1",nfieldcount);
AfxMessageBox(msg);
//field 0 is int field,name "intfield",retrieve by field index
CDBVariant dbvar;
rs.GetFieldValue((short)0,dbvar);
//field 1 is string field,name "strfield",retrieve by field name
CString dbstrvar;
rs.GetFieldValue("strfield",dbstrvar);
msg.Format("field 0 value:%d,field name strfield value=%s",dbvar.m_iVal,dbstrvar);
AfxMessageBox(msg);
rs.Close();
db.Close();don't use classwizard generated class