ACCESSµÄÄ£ºý²éѯ
ÔÚSQL ServerÖÐÄ£ºý²éѯͨ³£ÊÇÕâÑùµÄSelect * from articleTable where authorName like '%jacky%'
µ«ÊÇÔÚAccessÖÐÓÃÕâÌõÓï¾äÖ´ÐеÄʱºò¾¹È»·¢Ïֲ鲻³ö½á¹û£¬Ôõô¿ÉÄÜÄØ£¿
ºóÀ´²éÁËÏÂ×ÊÁÏ£¬·¢ÏÖÎÊÌâÈçÏ£º
Òª½øÐÐÄ£ºý²éÕÒ£¬Ôò±ØÐëʹÓÃͨÅä·û£¬ACCESS¿âµÄͨÅä·ûºÍSQL SERVERµÄͨÅä·û²»Ò»Ñù¡£
ACCESS¿âµÄͨÅä·ûΪ£º
* ÓëÈκθöÊýµÄ×Ö·ûÆ¥Åä¡£
? ÓëÈκε¥¸ö×ÖĸµÄ×Ö·ûÆ¥Åä
ÔÚSQL ServerÖеÄͨÅä·ûΪ£º
% ÓëÈκθöÊýµÄ×Ö·ûÆ¥Åä
- Óëµ¥¸ö×Ö·ûÆ¥Åä
µ«ÊÇÓÖ·¢ÏÖ£¬C#Á¬½Óµ½AccessÊý¾Ý¿âÖ®ºó£¬ÓÃÕâÑùÒ»ÌõÓï¾äSelect * from articleTable where authorName like '*jacky*' £¨×¢Ò⣬Õâ±ß°´ÕÕÉÏÊöͨÅä·ûµÄÒªÇó½«%ÐÞ¸ÄΪ*ÁË£©¾¹È»ËÑË÷²»µ½Ó¦¸Ã´æÔÚµÄNÌõ¼Ç¼£¬ÎÒ¿¿
Ïà¹ØÎĵµ£º
ÏÂÃæ¸ø³öÁËʹÓÃC# ¿ª·¢µÄÒ»¸öѹËõACCESSÊý¾Ý¿âµÄ³ÌÐò
ÏñFolderBrowserDialog£¨ÓÃÓÚä¯ÀÀÑ¡ÔñÎļþ¼ÐµÄ¶Ô»°¿ò£©¡¢MessageBox£¨ÏûÏ¢´¦Àí¶Ô»°¿ò£©¡¢DirectoryInfo£¨Ä¿Â¼ÐÅÏ¢£¬¿ÉÓÃÓÚ´´½¨¡¢¼ì²âÊÇ·ñ´æÔڵȶÔĿ¼µÄ²Ù×÷£©¡¢FileInfo£¨ÎļþÐÅÏ¢£¬¿ÉÓÃÓÚÎļþµÄ¼ì²â¡¢ÎļþÐÅÏ¢µÄ»ñÈ¡¡¢¸´ÖƵȲÙ×÷£©¡¢DataGridView£¨Êý¾Ý±í¸ñ¿Ø¼þ£¬ÓÃÓ ......
½ñÌ컨ÁË2¸öСʱ¼ä£¬ÔÚÍøÉÏ·¢ÏÖÒ»´ó¶ÑµÄ½â´ð£¬µ«¶¼²»´ÕЧ£¬×Ô¼ºÃþË÷£¬ÖÕÓڸ㶨Õâ¸öºÜ¶ñÐĵÄÎÊÌâ¡£
µÚÒ»²½:½øÈë/varĿ¼ Ö´ÐÐÃüÁî chmod 755 ./www/ -R £¬Ò²¾ÍÊÇ°ÑWEBĿ¼ÏµÄÎļþµÄ·ÃÎÊȨÏÞÊʵ±´ò¿ª
µÚ¶þ²½:sudo cd /etc/apache2/sites-enabled/,·¢ÏÖÀïÃæÓм¸¸öĿ¼£¬±ÈÈçÎÒµÄÓÐ 000£default£¬ÊäÈësudo gedit /etc/apach ......
sqlserver£ºupdate Table_A set Table_A.col1 = (select Table_B.col1 from Table_B where Table_A.col2 = Table_B.col2)
Access: UPDATE Table_ A, Table_B SET Table_ A.×Ö¶Î2 = Table_ B.×Ö¶Î2
WHERE Table_ A.񅧏=Table_ A.񅧏;
×Ô¼º¼ÇÏ£¬ÌáÐÑ×Ô¼º ......
ÏîÄ¿ÖÐÓõ½Á˴˹¦ÄÜ¡£°Ñ´ó¸Å×ö·¨¸ú´ó¼Ò¹²ÏíÏ£¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£Ò²¸ø×Ô¼º×ܽáһϣ¬¼¤Àø×Ô¼ºÔÙ½ÓÔÙÀ÷¡£ÏÂÃæÖв¿·Ö´úÂë±»ºº×ÖÌæ»»ÁË£¬Ö÷Òª¿¼Âǵ½¹«Ë¾µÄ²úƷȨ£¬Ï£ÍûÁ½⡣
/// <summary>
  ......
using System;
using System.IO;
using System.Runtime.InteropServices;
using System.Threading;
using System.Windows.Forms;
using Microsoft.Win32;
using Access = Microsoft.Office.Interop.Access;
namespace ImageAccess
{
static class Program
{
......