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

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Êý¾Ý¿âѹËõ³ÌÐò

ÏÂÃæ¸ø³öÁËʹÓÃC# ¿ª·¢µÄÒ»¸öѹËõACCESSÊý¾Ý¿âµÄ³ÌÐò
ÏñFolderBrowserDialog£¨ÓÃÓÚä¯ÀÀÑ¡ÔñÎļþ¼ÐµÄ¶Ô»°¿ò£©¡¢MessageBox£¨ÏûÏ¢´¦Àí¶Ô»°¿ò£©¡¢DirectoryInfo£¨Ä¿Â¼ÐÅÏ¢£¬¿ÉÓÃÓÚ´´½¨¡¢¼ì²âÊÇ·ñ´æÔڵȶÔĿ¼µÄ²Ù×÷£©¡¢FileInfo£¨ÎļþÐÅÏ¢£¬¿ÉÓÃÓÚÎļþµÄ¼ì²â¡¢ÎļþÐÅÏ¢µÄ»ñÈ¡¡¢¸´ÖƵȲÙ×÷£©¡¢DataGridView£¨Êý¾Ý±í¸ñ¿Ø¼þ£¬ÓÃÓ ......

lamp Error403 Forbidden access½â¾ö²ßÂÔ

½ñÌ컨ÁË2¸öСʱ¼ä£¬ÔÚÍøÉÏ·¢ÏÖÒ»´ó¶ÑµÄ½â´ð£¬µ«¶¼²»´ÕЧ£¬×Ô¼ºÃþË÷£¬ÖÕÓڸ㶨Õâ¸öºÜ¶ñÐĵÄÎÊÌâ¡£
µÚÒ»²½:½øÈë/varĿ¼ Ö´ÐÐÃüÁî chmod 755 ./www/ -R £¬Ò²¾ÍÊÇ°ÑWEBĿ¼ÏµÄÎļþµÄ·ÃÎÊȨÏÞÊʵ±´ò¿ª
µÚ¶þ²½:sudo cd /etc/apache2/sites-enabled/,·¢ÏÖÀïÃæÓм¸¸öĿ¼£¬±ÈÈçÎÒµÄÓÐ 000£­default£¬ÊäÈësudo gedit /etc/apach ......

¹ØÓÚupdateÓï¾äÔÚsqlserverºÍAccessÖеĶԱÈ

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.񅧏;
×Ô¼º¼ÇÏ£¬ÌáÐÑ×Ô¼º ......

winformµ¼Èëexcelµ½accessÊý¾Ý¿âÖÐ

        ÏîÄ¿ÖÐÓõ½Á˴˹¦ÄÜ¡£°Ñ´ó¸Å×ö·¨¸ú´ó¼Ò¹²ÏíÏ£¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£Ò²¸ø×Ô¼º×ܽáһϣ¬¼¤Àø×Ô¼ºÔÙ½ÓÔÙÀ÷¡£ÏÂÃæÖв¿·Ö´úÂë±»ºº×ÖÌæ»»ÁË£¬Ö÷Òª¿¼Âǵ½¹«Ë¾µÄ²úƷȨ£¬Ï£ÍûÁ½⡣
        /// <summary>
      ......

ÀûÓà DataGridView »æÖÆͼƬÁÐ±í£¨´ÓAccess¶ÁȡͼƬ£©

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
    {
   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ