Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇóÖú£ºMFCÖÐÈçºÎ²Ù×÷AccessÎļþ£¿

ÈçºÎ¶¯Ì¬´´½¨AccessÎļþ£¿
ÈçºÎÔÚ½çÃæÖеã»÷Ò»¸ö°´Å¥£¬µ¯³öÒ»¸ö¶Ô»°¿òÑ¡ÔñAccessÎļþ£¬Ñ¡Öкó¿ÉÒÔ¶ÔÆäÖеÄÊý¾Ý¼Ç¼½øÐвÙ×÷£¿
ÎÒÖªµÀÔÚ³õʼ»¯½çÃæµÄʱºòÈçºÎ²Ù×÷Ò»¸öÎļþÃûÒÑÖªµÄAccessÎļþ
CString strConnect="DRIVER={Microsoft Access Driver (*.mdb)}; uid=; pwd=; DBQ=config.mdb;";
ÈçºÎ¶¯Ì¬µØÁ¬½ÓÒ»¸öAccessÎļþ£¬DBQ¿ÉÒÔÓñäÁ¿Âð£¿
CFileDialog m_dlg(TRUE,".MDB", NULL, 0, "Office Access(*.mdb)|*.mdb||", this);
if (m_dlg.DoModal() == IDOK)
{
CString strfileName = m_dlg.GetFileName();
try
{
m_pConnection.CreateInstance("ADODB.Connection");
CString strConnect;
strConnect.Format("DRIVER={Microsoft Access Driver (*.mdb)}; uid=; pwd=; DBQ=%s;", strfileName);
m_pConnection->Open((_bstr_t)strConnect, "", "", adModeUnknown);

}
catch(_com_error e)
{
  AfxMessageBox("Á¬½ÓÊý¾Ýʧ°Ü£¬Çë¼ì²éÊý¾Ý¿â·¾¶ÊÇ·ñÕýÈ·£¡");
}
}
else
{
AfxMessageBox("ÇëÑ¡ÔñÎļþ£¡");
}

ÕâÑùÓÃûʲôÎÊÌâ

´´½¨ÎļþÖ®ºó»¹Òª´´½¨±í
±È½Ï¼òµ¥µÄ°ì·¨ÊǰÑÒ»¸öÔ¤ÏÈ´´½¨µÄÄ£°åmdbÎļþ¸´ÖƵ½Ä¿±êĿ¼¾Í¿ÉÒÔÁË

Ö±½ÓÓòÙ×÷Êý¾Ý¿âµÄ·½·¨´¦Àí²»¾Í¿ÉÒÔÁËô


Ïà¹ØÎÊ´ð£º

ÈçºÎ½«accessÀïÃæµÄ¸½¼þ±£´æµ½´ÅÅÌÉÏÄØ

Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit

ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......

VC ADO ACCESS sql ²éѯ - VC/MFC / Êý¾Ý¿â

´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......

access Á¬¸ö±í°´¶à×Ö¶Î ×óÓÒÁ¬½ÓµÄÎÊÌâ

accessÖÐÈçºÎÁ½¸ö±í °´Á½¸ö×ֶνøÐÐ×óÁ¬½Ó
±ÈÈç ÓÐÁ½¸ö±í·Ö±ðΪ
t1
id, lb1 ,value1
1 201 1
2 202 1
2 202 1.5
±í2£ºt2
id ,lb2 ,value2
1 201 2.5
ÎÒÏëÁ½¸ö±íÁ¬½Ó£¬°´ id£¬lbÁ½¸ö×ֶΰ´t1Á ......

dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌâ

ÈçÌâ dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌ⣡
ʹÓà dOOdads Á¬½Ó ACCESSÊý¾ÝµÄʱºò Êý¾Ý·ÖÒ³µÄÎÊÌ⣡
¸ù¾ÝÕâ¸ö¸Ä°É
C# code:

public static Product[] SearchProducts(string keyword, int categoryID, int pa ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ