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

Ôõôͨ¹ýODBCʹÓÃwxWidgetsÁ¬½ÓAccessÊý¾Ý¿â

Ôõôͨ¹ýODBCʹÓÃwxWidgetsÁ¬½ÓAccessÊý¾Ý¿â
1¡¢wxWidgets¿âÖÐODBCµÄ±àÒë
ĬÈϱàÒëʱ£¬ODBC¿âÖеÄûÓе¼³ö£¬ÖÂʹµ÷ÓÃwxDbConnectInf£¬wxDbTableµÈÀຯÊýÊÇʱ³öÏÖÁ´½Ó´íÎóµÄÎÊÌ⣬¹ÊÊ×ÏÈÒª±àÒëODBC¿âΪµ¼³ö Àà¿â£¬ÕâÐèÒªÔÚ"Include"Ŀ¼ÏµÄ"Setup.h"ÖжÔ#define wxUSE_ODBC 0ÉèÖÃΪ1£¬ÖØÐ±àÒë¼´¿É.
2¡¢Êý¾Ý¿âµÄÁ´½ÓÓëÊý¾ÝµÄ¶ÁÈ¡
//Æô¶¯ºÍÅäÖÃÊý¾Ý¿â»·¾³
wxDbConnectInf *ConnectConfig = new wxDbConnectInf(NULL, wxT("DB1"), wxT(""), wxT("")); //(DB1¾ÍÊÇODBCÊý¾ÝÔ´) //Á´½ÓÊý¾Ý¿â
wxDb *theConnect = wxDbGetConnection(ConnectConfig);
//±íµÄ´ò¿ª
wxDbTable *tbl = new wxDbTable(theConnect,wxT("S1"),2,wxT(""), !wxDB_QUERY_ONLY, wxT("")); //(S1¾ÍÊÇDB1ÖеıíÃû)
//Êý¾ÝºÍ±äÁ¿°ó¶¨(ID,theNameÊDZíÖеÄ×ֶΣ¬ theID,theName¾ÍÊÇÀ¦°óÊý¾Ý)
 tbl->SetColDefs(0, wxT("ID"), DB_DATA_TYPE_INTEGER, &theID, SQL_C_LONG, sizeof(theID), false, true);
tbl->SetColDefs(1, wxT("theName"), DB_DATA_TYPE_VARCHAR, theName, SQL_C_WXCHAR, sizeof(theName), false, true);
 //ÅжÏÊÇ·ñÕýÈ·´ò¿ª±í
if (!tbl->Open()) {
    //ÅжÏÊÇ·ñÕýÈ·´ò¿ª±í
    wxMessageBox("error1");
     return;
}
//ÅжÏÊÇ·ñÕýÈ·»ñÈ¡±íÊý¾Ý
if (!tbl->GetDb())
{
 //ÅжÏÊÇ·ñÕýÈ·»ñÈ¡±íÊý¾Ý
wxMessageBox("error2");
 return;
}
 //²éѯÊý¾Ý
tbl ->Query();
wxString wxx;
while (tbl ->GetNext())
{
strcat(theName,"\n");
wxx += theName;
}
3¡¢ºóÐø´¦Àí(ÂÔ)


Ïà¹ØÎĵµ£º

½ðµûÃÔÄã°æAccessÊý¾Ý¿âµÄadoÁ¬½Ó×Ö·û´®

[oledb]
; Everything after this line is an OLE DB initstring
Provider=Microsoft.Jet.OLEDB.4.0;Password=ypbwkfyjhyhgzj;User ID=morningstar;Data Source=C:\Program Files\Kingdee\KIS\BZB\±±¼«ÐÇ.AIS;Persist Security Info=True;Jet OLEDB:System database=C:\Program Files\Kingdee\KIS\BZB\system.mda
......

C# Á¬½ÓsqlÊý¾Ý¿â¶Ô access£¬excelµ¼Èëµ¼³ö²Ù×÷


 
Ò»¡¢SQL SERVER ºÍACCESSµÄÊý¾Ýµ¼Èëµ¼³ö
³£¹æµÄÊý¾Ýµ¼Èëµ¼³ö£º
ʹÓÃDTSÏòµ¼Ç¨ÒÆÄãµÄAccessÊý¾Ýµ½SQL Server£¬Äã¿ÉÒÔʹÓÃÕâЩ²½Öè:
¡¡¡¡¡ð1ÔÚSQL SERVERÆóÒµ¹ÜÀíÆ÷ÖеÄTools£¨¹¤¾ß£©²Ëµ¥ÉÏ£¬Ñ¡ÔñData Transformation
¡¡¡¡¡ð2Services£¨Êý¾Ýת»»·þÎñ£©£¬È»ºóÑ¡Ôñ  czdImport Data£¨µ¼ÈëÊý¾Ý£©¡£
¡¡¡¡¡ ......

OPENDATASOURCE ´ò¿ªexcel¡¢access¡¢qsl

OPENDATASOURCE ´ò¿ªexcel¡¢access¡¢qsl
use test
insert into OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.2.200;User ID=sa;Password=110').test.dbo.adf--´ò¿ªÔ¶³ÌÊý¾Ý¿â
select * from OpenRowSet('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;HDR=Yes;IMEX=1;Database=c:\2003.xls', [kg$])
 --²éѯԶ³ÌÊý¾Ý ......

ADOÊý¾Ý¿â²Ù×÷(ACCESS)

Ò»¡¢ADO¼ò½é
ADO(Active Data Object£¬»î¶¯Êý¾Ý¶ÔÏó)ʵ¼ÊÉÏÊÇÒ»ÖÖ»ùÓÚCOM(×é¼þ¶ÔÏóÄ£ÐÍ)ÖеÄ×Ô¶¯»¯½Ó¿Ú(IDispatch)¼¼Êõ£¬²¢ÒÔOLE DB(¶ÔÏóÁ¬½ÓºÍÏâÈëµÄÊý¾Ý¿â)Ϊ»ù´¡£¬¾­¹ýOLE DB¾«Ðİü×°ºóµÄÊý¾Ý¿â·ÃÎʼ¼Êõ£¬ÀûÓÃËü¿ÉÒÔ¿ìËٵĴ´½¨Êý¾Ý¿âÓ¦ÓóÌÐò¡£
ADOÌṩÁËÒ»×é·Ç³£¼òµ¥£¬½«Ò»°ãͨÓõÄÊý¾Ý·ÃÎÊϸ½Ú½øÐзâ×°µÄ¶ÔÏó¡£ÓÉÓ ......

ÓÃVC´¦ÀíACCESSÖеÄλͼÊý¾Ý

----±È½Ï¸´ÔÓµÄÊý¾Ý¿âÖÐÒ»°ã»áÓÐλͼÊý¾Ý£¨±ÈÈçÏàÆ¬£©¡£ËäÈ»ÕâÀà“OLE¶ÔÏó”µÄ²åÈ롢ɾ³ýÒÔ¼°Ìæ»»²Ù×÷ÔÚACCESSÀïÈÝÒ×ʵÏÖ£¬ÔÚVCÖÐÈ´ÏԵø´ÔÓ¶øÇÒÆÄ·ÑÖÜÕÛ¡£ÒÔϰÑ×÷ÕßÓÃVC´¦ÀíACCESSÊý¾Ý¿âÖеÄλͼÊý¾ÝµÄÌå»á¼òµ¥ÐðÊöһϣ¬ÒÔÇë½ÌÓÚ´ó¼Ò¡£
----ÔÚCdaoRecordsetÅÉÉúÀàµÄ¶ÔÏóÖУ¬VC×Ô¶¯ÎªACCESSµÄ“OLE¶ÔÏó&r ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ