listview ado access Êý¾Ý¶ÁÈ¡ÎÊÌâ!
Êý¾Ý¿âÊǰ汾ÊÇaccess2000
ÓÃÏÂÃæµÄº¯ÊýÌí¼ÓlistviewÏîÄ¿£¬£¬Ö»ÄÜÌí¼ÓÊý¾Ý¿âÖÐ×îºóÒ»Ìõ¼Ç¼£¬Ôõô½â¾ö
BOOL AddItem(HWND hWndUser,_RecordsetPtr pRecordset)
{
try
{
if(!pRecordset->FirstOfFile)
pRecordset->MoveFirst();
else
{
MessageBox(NULL,TEXT("±íÄÚÊý¾ÝΪ¿Õ"),TEXT("!"),MB_OK);
return FALSE;
}
while(!pRecordset->EndOfFile)
{
_variant_t var;
var.vt=VT_I4;
var.intVal=0;
int iSubItem;
_bstr_t bstrVar=(_bstr_t)pRecordset->GetCollect(var);
char *pText=bstrVar;
LVITEM lvi;
ListView_DeleteAllItems(hWndUser);
ZeroMemory(&lvi,sizeof(lvi));
lvi.mask=LVIF_TEXT;
lvi.iItem=ListView_GetItemCount(hWndUser);;
lvi.pszText=pText;
lvi.cchTextMax=sizeof(pText);
lvi.iSubItem=0;
if(ListView_InsertItem(hWndUser, &lvi) == -1)
return FALSE;
for(iSubItem=0;iSubItem <pRecordset->Fields->Count;iSubItem++)
{
var.intVal=iSubItem;
lvi.iSubItem=iSubItem;
_bstr_t bstrVar
Ïà¹ØÎÊ´ð£º
±¾À´ÎÒÊÇÓÃACCESS+VB½¨Á¢Ò»¸öÈí¼þ£¨¾ÖÓòÍø£©£¬ÏÖÔÚÓÉÓڰ칫µØµãÓб䶯£¬Ïà»»³ÉINTERNATµÄ£¬ÓÐûÓа취½â¾ö£¬
ÏóÕâÑùµÄÇé¿ö£¬Èç¹ûÊǹãÓòÍø£¬×îºÃ¸Ä³É£ºB\SµÄ
Èç¹ûÊǾÖÓòÍøµÄ£¬×îºÃ¸Ä³É£ºC\SµÄ
http://downlo ......
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......
Ë×ö¹ýÕâ·½ÃæµÄ,°ÝÇó..ÌáÐÑÒ»ÏÂ,ÎÒËùÓеķֶ¼ËÍÄã~~~~
Ö±½ÓºÍµ÷ÓñíÏàͬ¡£
select * from table1
select * from qeury1
ÒýÓÃÌáÐÑÒ»ÏÂ,ÎÒËùÓеķֶ¼ËÍÄã~~~~
( ¿ÉÐŶȲ»¸ß°¡)
Liang4 (Á ......
AccessÖеİ´´°ÌåɸѡÊÇʲôÒâ˼£¿
Me.´æÊé²éѯ×Ó´°Ìå.Form.Filter = strWhere
Me.´æÊé²éѯ×Ó´°Ìå.Form.FilterOn = True
ʵ¼ÊÉϾÍÊǰ´×Ó´°ÌåµÄ¹ýÂËÌõ¼þ½øÐÐɸѡ
ʵ¼ÊÉϾÍÊǰ´×Ó´°ÌåµÄ¹ýÂËÌõ ......