¡¾·ÖÏí¡¿VB.NET2008´´½¨¶¯Ì¬ACCESSÊý¾Ý¿â²¢´´½¨±íʾÀý
ÉùÃ÷£º±¾Ê¾ÀýÒÀ¾Ýhttp://support.microsoft.com/kb/252908/EN-US/£¨Ô´úÂëÔÚVS2008Öв»¿ÉÓ㩼ӹ¤¶ø³É
Ê×ÏÈÐèÌí¼ÓÒýÓÃ
Microsoft ActiveX Data Objects 2.x Library
Microsoft ADO Ext. 2.x for DDL and Security
VB.NET code:
Imports ADOX
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'´´½¨ÐµĿÕaccessÊý¾Ý¿â±í
Dim cat As Catalog = New Catalog()
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Engine Type=5;Data Source= NewMDB.mdb")
'Console.WriteLine("Database Created Successfully")
' ÒÔÏ´úÂë´´½¨Ò»¸öÃûΪTest_Tableµ¥Ö÷¼üбí
Dim Cn As ADODB.Connection = New ADODB.Connection '¶¨ÒåÁ¬½Ó
Dim objTable As ADOX.Table = New ADOX.Table '¶¨Òåбí
'Cn = New ADODB.Connection
'objTable = New ADOX.Table
'Open the connection
Cn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=NewMDB.mdb") 'Á´½Óµ½Êý¾Ý¿â
objTable.Name = "²âÊÔÏîÄ¿±í" '±íÃüÃû
'¸ø±í¡°²âÊÔÏîÄ¿±í¡± ´´½¨Ò»¸öеÄ×ֶΣ¬×Ö¶ÎÃû¡°Ö÷¼ü¡±
objTable.Columns.Append("Ö÷¼ü", , ADOX.DataTypeEnum.adInteger)
'´´½¨²¢×·¼ÓÒ»¸öеĹؼü¡£×¢Ò⣺ÎÒÃÇÖ»ÊÇͨ¹ý¡°PimaryKey_Field¡±×÷ΪÖ÷¼üÔ´ÁС£Ð¼ü±»×·¼Óµ½¡°²âÊÔÏîÄ¿±í¡±µÄ¼ü¼¯
Ïà¹ØÎÊ´ð£º
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......
ÔÚvbÖÐÈçºÎ¶ÁÈ¡WordÄÚÈÝ(°üº¬±í¸ñ£¬Í¼Æ¬£¬µÈ£©
¾¹È»²»ÊÇzero¡£
²»ÖªµÀÔõôʵÏֵIJ»ÒªËµ»°
Õâ¸öÖ»ÄܶÁÎı¾,
VB code:
Private Sub Command1_Click()
Dim WordApp As Object
Set WordApp = CreateObject(& ......
ÏÖÔÚÎÒÏë¸ù¾ÝtreeviewÉÏÿ¸ö½ÚµãµÄȨÏÞ£¬Ã»ÓÐȨÏ޵Ľڵ㲻Äܱ»Ñ¡ÖУ¬¶øÇҳɻÒÉ«£¬ÔõôʵÏÖ£¬ÔÚÏߵȡ£¡£¡£
Õâ¸ö£¿¡£¡£¡£
Ã²ËÆÃ»·¨¡£
ÊÔÊÔÄܲ»ÄܸÄijЩnodeµÄÑÕÉ«£¬¼Ç¼ÏÂÉϴεÄnodeclickÀïµÄnode¡£
Ï´εã»÷µÄÈç¹ ......
Êý¾Ý¿âÀïÓÐÒ»¸ö×ֶεÄÄÚÈÝÊǶþ½øÖÆ£¬Ôõô²ÅÄܰÑÕâ¸ö¶þ½øÖƶÁ³öÀ´
ʹÓÃ×Ö½ÚÁ÷¶ÔÏó¿ÉÒÔʵÏÖ
ÀýÈçÏÖÔÚÊý¾Ý¿âÀïÓиö×ֶεÄÄÚÈÝÊÇ0x504B03040A0000000800407F263C3B02465390000000820000000A0000006273CECACCE22E7478 ......
Ôõô°ÑÒÑÖªµÄÊý¾Ý±£´æ³ÉxmlÎļþ£¬ÏÖÔÚÒÑÖªµÄÊý¾ÝÊÇ
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o=& ......