急```如何在数据库中查询多列 SELECT * FROM 成绩表 WHERE 班级 = 9 AND 数学 > 90 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from 成绩记录where 班级=9班and 数学>90 select * from 成绩记录where 班级=9and 数学>90 record.CreateInstance("ADODB.Recordset"); record->Open("SELECT * FROM pi",_variant_t((IDispatch *)connect,true),adOpenStatic,adLockOptimistic,adCmdText); _variant_t v1,v2,v3,v4,v5; CString a1; CString a2; CString a3; CString a4; CString a5; record->MoveFirst(); int a=0; while(!record->adoEOF) { v1=record->GetCollect("xinghao"); v2=record->GetCollect("zhupin"); v3=record->GetCollect("neicun"); v4=record->GetCollect("piweishu"); v5=record->GetCollect("shijian"); a1.Format("%s",(LPCTSTR)(_bstr_t)v1); a2.Format("%s",(LPCTSTR)(_bstr_t)v2); a3.Format("%s",(LPCTSTR)(_bstr_t)v3); a4.Format("%s",(LPCTSTR)(_bstr_t)v4); a5.Format("%s",(LPCTSTR)(_bstr_t)v5); m_list.InsertItem(a,a1); m_list.SetItemText(a,1,a2); m_list.SetItemText(a,2,a3); m_list.SetItemText(a,3,a4); m_list.SetItemText(a,4,a5); record->MoveNext(); a++; } vc2008 控件内容怎么右对齐 高分求教面试题目.... 大家帮忙啊 CWinApp类的m_pCurrentWinApp、m_pMainWnd属性问题 怎样实现这样的功能?或者已经有现成的工具(文件管理相关) 关于解惑,拦截数据的问题 24位BMP位图的保存 FindResourceEx()这个函数为什么返回HRSRC hRsrc的值是NULL? 请推荐网络编程的书 listbox控件的sort属性如果用语句删去? <<windows核心编程>>中有点看不明白的来问一下 mfc对话框问题 关于OpenGL光源的问题!
where 班级=9班
and 数学>90
where 班级=9
and 数学>90
record->Open("SELECT * FROM pi",_variant_t((IDispatch *)connect,true),adOpenStatic,adLockOptimistic,adCmdText);
_variant_t v1,v2,v3,v4,v5;
CString a1;
CString a2;
CString a3;
CString a4;
CString a5;
record->MoveFirst();
int a=0;
while(!record->adoEOF)
{
v1=record->GetCollect("xinghao");
v2=record->GetCollect("zhupin");
v3=record->GetCollect("neicun");
v4=record->GetCollect("piweishu");
v5=record->GetCollect("shijian");
a1.Format("%s",(LPCTSTR)(_bstr_t)v1);
a2.Format("%s",(LPCTSTR)(_bstr_t)v2);
a3.Format("%s",(LPCTSTR)(_bstr_t)v3);
a4.Format("%s",(LPCTSTR)(_bstr_t)v4);
a5.Format("%s",(LPCTSTR)(_bstr_t)v5);
m_list.InsertItem(a,a1);
m_list.SetItemText(a,1,a2);
m_list.SetItemText(a,2,a3);
m_list.SetItemText(a,3,a4);
m_list.SetItemText(a,4,a5);
record->MoveNext();
a++;
}