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

»ñÈ¡AccessÓû§¶¨ÒåµÄ±íÃûºÍ¸÷±íµÄ×Ö¶ÎÃû

 public   static  DataTable GetSchemaTable(string connectionString)  //»ñÈ¡AccessËùÓеıíÃû£»
        {
            using (OleDbConnection connection = new
                       OleDbConnection(connectionString))
            {
                connection.Open();
                DataTable schemaTable = connection.GetOleDbSchemaTable(
                    OleDbSchemaGuid.Tables,
                    new object[] { null, null, null, "TABLE" });
                return schemaTable;
            }
        }
 private string[] GetTabelName(string conn)  //»ñÈ¡AccessÎļþÖÐËùÓбíÃû£¬·ÅÔÚÊý×éÀïÃæ
        {
            DataTable dt = GetSchemaTable(conn);
            int n = dt.Rows.Count;
            string[] strTable = new string[n];
            int m = dt.Columns.IndexOf("TABLE_NAME");
            for (int i = 0; i < n; i++)
        


Ïà¹ØÎĵµ£º

ÄÕÈ赀 access jet Óï·¨

×òÍíÔÚ×öAccessÊý¾Ý¿â¿ª·¢Ê±Óöµ½Ò»¸ö¼òµ¥µÄÄ£ºý²éѯÎÊÌ⣬ÔÚaccess2007ÀïÃæ¿ÉÒÔ²é³öÀ´£¬µ«ÓÃC#2.0²éѯ¾ÍÊDz鲻³öÀ´¡£
ºóÀ´ÊÔ³öÀ´ÁË£¬Ô­À´ ÊÇjetÓï·¨µÄÎÊÌ⣺
ÔÚAccessÖУ¬Ä£ºý²éѯÓà * ºÅ£¬Èç select * from T_PO where po_NO like '*8*'
µ«ÔÚC#³ÌÐòÀïÃæÐ´µÄʱºòÒªÓà % ºÅ£¬¼´ select * from T_PO where po_NO like '%8% ......

VB´´½¨ACCESSÊý¾Ý¿âÈ«½â

VB´´½¨ACCESSÊý¾Ý¿âÈ«½â ¶¯Ì¬´´½¨Êý¾Ý¿â¡¢´´½¨±í£¬´´½¨¼Ç¼ ADO¡¢ADOX2009Äê04ÔÂ20ÈÕ ÐÇÆÚÒ» 10:17ÕªÒª£º ±¾ÎIJûÊöÁËÔÚVB³ÌÐòÖÐÀûÓÃADO¶ÔÏó¶¯Ì¬´´½¨Êý¾Ý¿âºÍÊý¾Ý±íµÄ·½·¨£¬ÕâЩ·½·¨ÔÚ¿ª·¢VBÊý¾Ý¿âÓ¦ÓóÌÐòÖкÜÓÐʵÓüÛÖµ£¬Ëü¿ÉÒÔÌá¸ßÊý¾Ý¿â³ÌÐòÁé»îÐÔ¡£
¡¡¡¡¹Ø¼ü´Ê£ºÊý¾Ý¿â¡¢Êý¾Ý±í¡¢ADO¡¢ADOX
¡¡¡¡1: ÎÊÌâµÄÌá³ö
¡¡¡¡Ô ......

Failed to access IIS metabase¡±½â¾ö

http://www.cnblogs.com/byeday/archive/2009/10/04/1578034.html
ÎÊÌ⣺“Failed to access IIS metabase”½â¾ö
2009-08-14 17:03
Ô­Òò£ºIISûÓÐ×¢²á
½â¾ö°ì·¨£º
ÔÚCMDÖнøÈëĿ¼C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727£¬ÔËÐÐaspnet_regiis
1¡¢aspnet_regiis -ga administrator£¨administratorΪµ ......

SQL Access´´½¨±í

Ò»¡¢´´½¨Ò»ÕÅ¿Õ±í£º
Sql="Create TABLE [±íÃû]"
¶þ¡¢´´½¨Ò»ÕÅÓÐ×Ö¶ÎµÄ±í£º
Sql="Create TABLE [±íÃû]([×Ö¶ÎÃû1] MEMO NOT NULL, [×Ö¶ÎÃû2] MEMO, [×Ö¶ÎÃû3] COUNTER NOT NULL, [×Ö¶ÎÃû4] DATETIME, [×Ö¶ÎÃû5] TEXT(200), [×Ö¶ÎÃû6] TEXT(200))
×Ö¶ÎÀàÐÍ£º
2 : "SmallInt", // ÕûÐÍ
3 : "Int", ......

Access ´íÁË£¬»¹ÊÇÎÒɵÁË

×î½üϵͳÔËÐÐÖз¢ÏÖAccess 2003 °æ±¾ÖжԴý Null ºÍ ‘’ £¨¿Õ×Ö·û£©Ææ¹ÖÎÊÌâ£¬ÖØÏÖ²½Ö裺
1¡¢´´½¨±ítabTest £»
2¡¢Ê¹ÓÃÉè¼ÆÊÓͼÌí¼ÓÁ½¸ö×Ö¶Î ID £¬col1
Ãû³Æ
ÀàÐÍ
³¤¶È
˵Ã÷
ID
Number
 
 
Ö÷¼ü£¬×ÔÔö
Col1
char
1
ÎÞ
 
3¡¢Ê¹ÓÃsql Ìí¼ÓÈçÏÂÊý¾Ý
-- col1 ×Ö¶ÎÉèÖÃΪ null
INS ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ