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

Access ²Ù×÷ѧϰ¼Ç¼

 1.´´½¨ Access Êý¾Ý¿â£¬²¢¹Ø±ÕÆäÁ¬½Ó
Access ²Ù×÷µÄÁ½¸öÒýÓÃ:
1) Microsoft ActiveX Data Objects 2.8 Library
2) Microsoft ADO Ext. 2.8 for DDL and Security
/// <summary>
/// ´´½¨Êý¾Ý¿â²¢·µ»ØÁ¬½Ó×Ö·û´®
/// </summary>
/// <param name="dbName">·¾¶+ÎļþÃû</param>
/// <returns></returns>
public static bool CreateAccess(string dbName)
{
try
{
string databaseConn;
//dbName = @"d:\newAccess.mdb";
databaseConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dbName + ";";
if (File.Exists(dbName)) return false;
// ´´½¨Êý¾Ý¿â
ADOX.CatalogClass accessCatalog = new CatalogClass();
accessCatalog.Create(databaseConn);
#region
//// ´´½¨Ò»¸ö±í
//ADOX.TableClass table = new ADOX.TableClass();
//table.ParentCatalog = accessCatalog;
//table.Name = "MyTable";
//// ´´½¨Ò»¸ö×Ô¶¯Ôö³¤×Ö¶Î
//ADOX.ColumnClass col = new ADOX.ColumnClass();
//col.ParentCatalog = accessCatalog;
//col.Type = ADOX.DataTypeEnum.adInteger;//ÉèÖÃ×Ö¶ÎÀàÐÍ
//col.Name = "ID";
//col.Properties["jet OLEDB:Allow Zero Length"].Value = false;
//col.Properties["AutoIncrement"].Value = true;
//table.Columns.Append(col,ADOX.DataTypeEnum.adInteger,0);
//// Ìí¼Ó±í
//accessCatalog.Tables.Append(table);
#endregion

/*
* ¹Ø±ÕÊý¾Ý¿âÁ¬½Ó£¬±ØÐëͨ¹ý ADODB À´ÊµÏÖ£¬·ñÔò´´½¨µÄÊý¾Ý¿âÎÞ·¨É¾³ý
*/
ADODB.Connection connection = accessCatalog.ActiveConnection as ADODB.Connection;
if (connection != null)
{


Ïà¹ØÎĵµ£º

ACCESSÊý¾Ýµ¼Èëµ½SQL Server2005


ÔÚSQL Server2005ÖÐÑ¡ÖÐÒªµ¼ÈëÊý¾ÝµÄ¿â > ÓÒ¼ü > н¨²éѯ£º
Ö´ÐÐSQLÓï¾äÈçÏ£º
insert into
Ä¿±êÊý¾Ý¿â±íÃû (×Ö¶Î1,×Ö¶Î2,....) select
×Ö¶Î1,×Ö¶Î2... from
openrowset
('microsoft.jet.oledb.4.0',';database=Ô´Êý¾Ý¿â·¾¶£¨È磺d:\test.mdb£©','select * from Ô´±í where ²éѯÌõ¼þ')
SQL Óï¾äÆôÓÃ×é¼ ......

accessÈÕÆÚºÍʱ¼äº¯Êý

accessÈÕÆÚºÍʱ¼äº¯Êý
 
accessÈÕÆÚºÍʱ¼äº¯Êý
------------------------------------------------
ÉèÖõ±Ç°ÈÕÆÚ»òʱ¼ä¡£ Date ,Now, Time
¼ÆËãÈÕÆÚ: DateAdd, DateDiff, DatePart
·µ»ØÈÕÆÚ: DateSerial, DateValue
·µ»ØÊ±¼ä: TimeSerial, TimeValue
ÉèÖÃÈÕÆÚ»òʱ¼ä: Date, Time
¼ÆÊ±: Timer
ÔÚ°ïÖú ......

AccessÊý¾Ý¿â²Ù×÷Àà

AccessÊý¾Ý¿â²Ù×÷ÀàAccessHelper
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb ......

using OPENDATASOURCE Select Access Data Base data

ÔÚSQL Server ÄÚ²éѯAccess Êý¾Ý, ²¢½«Êý¾Ý±£´æµ½SQL Server
'Jet OLEDB:Database Password=; /*Access ÃÜÂë*/
Data Source=C:\temp\Test.mdb; /*Access Êý¾Ý¿â·¾¶*/
Password=;/*Access¹¤×÷×éÃÜÂë*/
1. ²éѯAccess ±íÄÚËùÓÐÊý¾Ý
SELECT *
from OPENDATASOURCE
('Microsoft.Jet.OLEDB.4.0',
'Jet OLEDB:Database ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ