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

MSHFelxGrid Óë ACCESS MEMOÀàÐÍ×ֶεÄÒÉÎÊ

×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ

µ±Êý¾Ý¿â×Ö¶ÎΪ¡°Memo(Access±¸×¢)¡±µÄʱºò£¬Ê¹ÓÃMSHFlexGrid1.TextMatrixÈ¡µÃµÄÖµ²¢²»ÍêÈ«£¬Ö»ÓÐ999¸ö×Ö·û¡­¡­À§ÈÅÁËÒ»Ì죬Çë¸ßÈËÃÇÀ´²âÊÔ²¢ËµËµ½â¾ö·½°¸¡£ÓÉÓÚÏ൱ԭÒò£¬ÅųýµôÐÞ¸ÄÊý¾Ý¿â×Ö¶ÎÀàÐ͵ķ½°¸¡£

Ô´ÂëÈçÏ£º
°üÀ¨¿Ø¼þ   textbox   x   1,MSHFlexGrid   x   1,Label   x   1
Êý¾Ý¿âΪAccess,±íProductÄÚµÄSmallClassName×Ö¶ÎΪMemoÀàÐÍ£¬¼Ç¼Êý¾Ý³¬¹ý2000×Ö·û

Dim   con   As   New   ADODB.Connection
Dim   Gs   As   New   ADODB.Recordset

Private   Sub   Form_Load()
con.ConnectionString   =   "Provider=Microsoft.Jet.OLEDB.4.0;Data   Source= "   &   App.Path   &   "/DB.mdb;Persist   Security   Info=False "
con.Open
Gs.CursorLocation   =   adUseClient
Gs.Open   "select   *   from   product   where   smallClassName   like   '% ' ",   con,   1,   1
Set   MSHFlexGrid1.DataSource   =   Gs
Gs.Close
Text1.Text   =   MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row,   1)
Label1.Caption   =   Len(MSHFlexGrid1.TextMatrix(M


Ïà¹ØÎÊ´ð£º

asp¸úAccessÊý¾ÝÁ¬½ÓÎÊÌâ¡£

IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)

'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......

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

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

accessÖÆ×÷ÏÂÀ­²Ëµ¥

access¿ÉÒÔÖÆ×÷ÄÇÖÖÏÂÀ­²Ëµ¥Â𣿾ÍÏñFile£¬È»ºóÏÂÃæÓÐOpen£¬Save,Save asµÈÑ¡Ïî¡£µ«ÊÇ£¬Ó¦¸Ã½«Êó±ê·ÅÉÏÈ¥¾ÍÖ±½Ó¿ÉÒÔ´ò¿ª°É£¬²»ÊÇcombo box¡£Õâ¸öÓÃʲôÀ´×ö£¿
×Ô¶¨Ò幤¾ßÀ¸

´°ÌåÉè¼ÆÄ£Ê½
²Ëµ¥--ÊÓͼ--¹¤¾ ......

Access sqlÓï¾äÎÊÌâ

ÔÚAccessÈí¼þÀ¿ÉÒÔÖ±½ÓÉèÖÃÈÕÆÚΪNow(),ºÃÏñÊÇÕâÑù°É¡£
ͨ¹ýsqlÓï¾ä£¬ALTER TABLE [article] ADD [date] datetime
µ«ÊÇÖ±½ÓÔÚºóÃæ¼ÓNow()£¬½á¹û³ö´í£¬Ôõôͨ¹ýsqlÓï¾äÖ±½ÓÉèÖóɵ±Ç°ÈÕÆÚ£¬¶ø²»ÓÃÍùÀïÃæ¼Ó£¿ ......

ACCESS¼Ç¼ɾ³ýºó»¹Äܲéѯµ½

ÓÃADO²Ù×÷AccessÊý¾Ý¿â£¬ÎªÊ²Ã´°Ñ¼Ç¼ɾ³ýÖ®ºó£¬»¹ÄÜÔÙ²éѯ³öÀ´£¿

Á´½ÓÓï¾ä Provider=Microsoft.Jet.OLEDB.4.0;Data Source= 'MyDataBase'
ɾ³ýÓï¾ä delete from MyTable where ID = 100

1. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ