¹ØÓÚaccessÊý¾Ý¿â³éÈ¡¼Ç¼µÄÎÊÌâ
Èçͼ£º
ÎÒÏ뽫 Items ±íÖС¾ÏîÄ¿Ãû³Æ¡¿ÄÇÒ»ÁеÄËùÓмǼÌáÈ¡³öÀ´£¬È»ºóÉú³ÉÒ»¸öеÄTemp±í£¬±íÖеÄËùÓÐÁоÍÊǸոÕÌáÈ¡³öÀ´µÄ¼Ç¼¡£
Ч¹ûÈçÏÂͼ£º
ÎÒÊǸöÐÂÊÖ£¬¸÷λ¸ßÊÖÄܲ»ÄܸæËßÎÒϸÃÈçºÎʵÏÖ£¬×îºÃÄܾßÌåµã¡£¡£Ð»Ð»£¡
ÓÃC#.netʵÏÖ¡£
¼òµ¥µÄado.net
ÏȲéѯItems±í
È»ºó´´½¨±íTemp
Äܲ»ÄܾßÌåµã°¡£¬ÎÒÊǸöÐÂÊÖ£¬Âé·³ÄãÁË¡£
Äã˵µÄÌ«¶ÔÁË£¬ÎÒµÄÄ¿µÄÊÇÉú³ÉÒ»¸öÓÃÓÚÏÔʾºÍ´òÓ¡µÄÊý¾Ý¼¯£¬¿ÉÊÇÎÒ²»ÖªµÀ¸ÄÔõôд
SQL,ͨ¹ýÏîÄ¿±àÂë×ö¸ö¹ØÁª¾ÍOKÁË,
¶Á³öËùÓÐÊý¾Ý£¬È»ºó¶¯Ì¬¹¹×ÅsqlÓï¾äÊÇûÎÊÌâµÄ
ÀýÈç
while (datareader.read())
{
sql += ",'" + datareader.getString(0) + "'";
}
×îºóÉú³ÉµÄÓï¾äÓ¦¸ÃÊÇÕâÑù
Create Table Temp
£¨
"100Ã×" ntext,
...
£©
µ«ÊÇÓиöÎÊÌ⣬ÕâЩÁÐÃûÊÇÓÐÏÞÖÆµÄ£¬ÀýÈçÊÇ×Öĸ´òÍ·£¬²»ÄÜÓÐÌØÊâ×Ö·ûµÈ¡£
Ïà¹ØÎÊ´ð£º
µÚÒ»´Î½Ó´¥CrystalReport
¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó.
ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл!
¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º
http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......
vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨ ......
ÈçÌâ dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌ⣡
ʹÓà dOOdads Á¬½Ó ACCESSÊý¾ÝµÄʱºò Êý¾Ý·ÖÒ³µÄÎÊÌ⣡
¸ù¾ÝÕâ¸ö¸Ä°É
C# code:
public static Product[] SearchProducts(string keyword, int categoryID, int pa ......
±í½á¹¹:
table1
Ö¤¼þºÅ ʱ¼ä
X31 2010-01-11
3BC 2010-02-03
3AD 2010-02-03
F23 2010-02-09
......
ÏÖÔÚҪͳ¼ÆÒ»¸öʱ¼ä¶ÎÈç 2010-01-09 µ½ 2010-02-09¼äµÄÊý¾Ý,
ÆÚ´ý½ ......
ÇëÎÊÓÐÈËÖªµÀÈçºÎÔÚkernel mode ÏÂд64 bit driver, ¿ÉÒÔ½«IO bitmap ´ò¿ª£¬
32bit¿ÉÒÔÓÃKe386SetIoAccessMapºÍKe386IoSetAccessProcess£¬
Çë問64 bit driverÓÐÀàËÆµÄfunctionaÂð?
ûŪ¹ý¡£
GoogleµÄ£ºhtt ......