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

winform ACCESS δָ¶¨µÄ´íÎó 100·Ö

winformÓ¦ÓóÌÐò
Á¬½Ó×Ö·û´®
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dbpath
dbpathΪ¾ø¶Ô·¾¶ Õâ¸ö·¾¶ÊÇûÓÐÈκÎÎÊÌâµÄ
ÔÚÖ´Ðе½connection.open()ʱ ±¨System.Data.OleDb.OleDbException:  δָ¶¨µÄ´íÎó

¾­¹ýËÑË÷ºó ·¢ÏֺܶàÀàËÆµÄ´íÎó¶¼ÊÇASP.NETµÄ ·¢ÏÖÒÔϽâ¾ö·½·¨
1.ÐÞ¸ÄTEMPĿ¼ȨÏÞ£¨ÒòΪÊÇwinform³ÌÐò ËùÒÔÓ¦¸ÃºÍÕâ¸öÎÞ¹Ø Î´³¢ÊÔ£©
2.ѹËõÐÞ¸´Êý¾Ý¿â(ÎÞЧ)
3.ÖØÐÂ×¢²áACCESSÇý¶¯£¨ÎÞЧ£©

Êý¾Ý¿âÊǵ¥»úʹÓà ²»´æÔÚ²¢·¢ÎÊÌâ ÇÒͬÑù´úÂë ÔÚÆäËû»úÆ÷ÉÏ¿ÉÒÔÔËÐÐ ¿ÉÄܾÍÓÐ1-2̨»úÆ÷ÓÐÕâÑùµÄÎÊÌâ
ÇëÎÊ´ó¼ÒÓöµ½¹ýÕâÑùµÄÎÊÌâÂð ÓÐûÓÐʲô°ì·¨¿ÉÒÔ½â¾ö£¿
Server.MapPath()²é¿´Â·¾¶£¿

ÓÐÁ´½Ó³É¹¦¹ýÂð£¿

»ØÂ¥ÉÏ ÊÇwinform ²»ÊÇasp.net

ͨ¹ýApplication.StartupPath+""ÉèÖõØÖ·

¹À¼ÆÊÇ·¾¶£¬Êý¾Ý¿âµÄÃû×Ö£¬»¹ÓÐÊÇ·ñÉèÖÃÁËÃÜÂ룬Êý¾Ý¿âÊÇ·ñÒѱ»ÆäËû³ÌÐò´ò¿ªµÈµÈÓйØÏµ¡£¡£¡£


ÒýÓÃ
¹À¼ÆÊÇ·¾¶£¬Êý¾Ý¿âµÄÃû×Ö£¬»¹ÓÐÊÇ·ñÉèÖÃÁËÃÜÂ룬Êý¾Ý¿âÊÇ·ñÒѱ»ÆäËû³ÌÐò´ò¿ªµÈµÈÓйØÏµ¡£¡£¡£


¾ßÌåµÄÔ­Òò»¹Õæ²»ÊÇÒÔÏ ¾ÍÄÜ¿´³öÀ´µÄ


ÎÒ²âÊÔÁËÒ»ÏÂ
·¾¶ÊǾø¶ÔûÓÐÎÊÌâµÄ ÒòΪÔÚ±¨´íµÄ»úÆ÷ÉÏ °Ñ·¾¶Êä³öÁË Í¨¹ýÊä³ö·¾¶ ÊÇ¿ÉÒÔ´ò¿ªACCESSµÄ
Êý¾Ý¿âûÓÐÃÜÂë ҲûÓб»ÆäËû³ÌÐò´ò¿ª

»ù±¾ÉÏ¿ÉÒÔÅųýACCESSµÄÎÊÌâ ÒòÎªÖØÐÂ×¢²áÁËÇý¶¯ºó Ìáʾע²á³É¹¦ È»ºó°ÑûÓб¨´í»úÆ÷ÉϵÄACCESS¿½±´¹ýÀ´ ¸²¸ÇÔ­ACCESSÎļþ µ«ÒÀ¾É±¨´í

ÏÖ»³ÒÉÊÇ£º
1.ȨÏÞ²»×ã ÒòΪÎÒÃǵĻúÆ÷ ¶¼¼ÓÈëÁËÓò µ«µÇ½µÄϵͳÕË»§Ò²¼ÓÈëµ½ÁËȨÏÞÖÐ ¿É


Ïà¹ØÎÊ´ð£º

ÈçºÎͨ¹ýADOʹÓþۺϺ¯ÊýÀ´²éѯ(Êý¾Ý¿âΪACCESS)

_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
    int ret = 0;
  _RecordsetPtr pset;
CString  sql;
& ......

Access²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

accessÖеÄfull join

    ÏÖÐèÒª½«access 2007ÖеÄ42¸ö±í½øÐÐfull join¡£ÓÉÓÚaccessÖв»ÄÜÖ´ÐÐfull join£¬Èç¹û²ÉÓÃleft join union right joinµÄ·½Ê½£¬ÐèÒª¶ÔÕâ42¸ö±íÒ»Ò»½øÐУ¬½«²úÉú´óÁ¿µÄ²»±ØÒªµÄÖмäÊý¾Ý£¬Ôö´óÁËÊý¾Ý¿âµÄ¿ ......

ASP+ACCESSÊä³öÎÊÌâ - Web ¿ª·¢ / ASP

ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......

ÇëÎÊAccessÖÐÈçºÎʹÓÃÎÞ·ûºÅÕûÊý

´ó¼ÒºÃ£¬ÎÒÔÚÊý¾Ý±íÖж¨ÒåÒ»¸öÐèÒª½øÐÐÅÅÐòµÄÕûÊý×ֶΣ¬µ«ÊǸù¾ÝÓ¦ÓÃÐèÇ󣬸Ã×ֶεÄȡֵ·¶Î§ºÜ´ó£¬¼¸ºõÓÃÂúÁËÕû¸ö32볤¶È¡£
ÔÚAccess±íÖкÃÏñÖ»ÓС°³¤ÕûÐÍ¡±Êʺϳ¤¶ÈµÄÐèÒª¡£¿ÉÊÇÓÉÓÚ³¤ÕûÐÍÊÇ´ø·ûºÅÊýµÄ£¬Òò´ËÔÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ