VC6¶ÔAccessÎļþÖ´ÐвåÈë²Ù×÷ʱ³ö´í£¡£¡£¡
ÏÂÃæº¯ÊýµÄ×÷ÓÃÊÇÈ¡³öµ±Ç°½çÃæÉÏCListCtrlÀïÃæµÄÊý¾Ý²åÈëµ½AccessÎļþÖÐ
void CMDBDlg::OnButtonSavefile()
{
// TODO: Add your control notification handler code here
CFileDialog m_dlg(FALSE,".MDB", NULL, 0, "Office Access(*.mdb)|*.mdb||", this);
if (m_dlg.DoModal() == IDOK)
{
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRs((__uuidof(Recordset)));
CString strMdbName = m_dlg.GetFileName();
CString strConStr;
strConStr.Format("DRIVER={Microsoft Access Driver (*.mdb)}; uid=; pwd=; DBQ=%s", strMdbName);
pConn->Open((_bstr_t)strConStr, "", "", adModeUnknown);
for (int i = 0; i < m_Grid.GetItemCount(); i++)
{
CString txtCaption1 = m_Grid.GetItemText(i, 1);
CString EnCaption1 = m_Grid.GetItemText(i, 2);
CString strSql;
strSql.Format("insert into [Captions]([ObjTag], [txtCaption], [EnCaption]) values(%d, %s, %s)", i, txtCaption1, EnCaption1);
_bstr_t sql = (_bstr_t)strSql;
pConn->Execute(sql, NULL, adCmdText);
//UpdateData();
}
CoUninitialize();
}
}
ÿ´ÎÖ´Ðе½pConn->Execute(sql, NULL, adCmdText);Óï¾äʱ¶¼»á±ÀÀ££¬²»ÖªµÀʲôÔÒò{{
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
×î½üѧϰasp£¬µ±Á·Ï°µ½Á¬½ÓÊý¾Ý¿âµÄʱºò£¬ÆµÆµ³ö´í£¬¿É¾ÍÊDz»ÖªµÀ´íÔÚÔõôµØ·½£¬Çë¸ßÊÖ°ïæ¿´¿´£¡£¡Ð»Ð»£¡
°üº¬Îļþxx.asp¡¢xxsave.asp¡¢conn.aspÒÔ¼°student1.mdbºÍ±íxxgl¡¡
xx.aspΪ£º
<html>
<hea ......
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit
ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
ÈçÌâ dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌ⣡
ʹÓà dOOdads Á¬½Ó ACCESSÊý¾ÝµÄʱºò Êý¾Ý·ÖÒ³µÄÎÊÌ⣡
¸ù¾ÝÕâ¸ö¸Ä°É
C# code:
public static Product[] SearchProducts(string keyword, int categoryID, int pa ......
ÇëÎÊÓÐÈËÖªµÀÈçºÎÔÚkernel mode ÏÂд64 bit driver, ¿ÉÒÔ½«IO bitmap ´ò¿ª£¬
32bit¿ÉÒÔÓÃKe386SetIoAccessMapºÍKe386IoSetAccessProcess£¬
Çë問64 bit driverÓÐÀàËÆµÄfunctionaÂð?
ûŪ¹ý¡£
GoogleµÄ£ºhtt ......