¼òÒ×È´²»Ê§»ªÀö [½øÏú´æ¹ÜÀí£Ý(BCB+ACCESS)
ϵͳ»·¾³£ºwindows xp
Èí¼þ»·¾³£ºC£«£« builder 6.0
±¾´ÎÄ¿µÄ£ºÍê³ÉÒ»¸ö¼òÒ×È´²»Ê§»ªÀöµÄ½øÏú´æ¹ÜÀíϵͳ¡£
ÕâÊǰëÄêǰ×÷µÄÒ»¸ö¿Î³ÌÉè¼Æ£¬ÓõÄBCB+ACCESSÊý¾Ý¿âÍê³ÉµÄ£¬½çÃæÃÀ»¯ÊÇÓõÄBusinessSkinForm5.25ºº»¯°æ£¬ËüÊÇBCBµÄµÚÈý·½¿Ø¼þ£¬Ê¹ÓñȽϷ½±ã£¬ÍøÉÏÓкܶàÌׯ¤·ô¿É¹©ÏÂÔØ¡£¾ßÌå³ÌÐòËùʵÏֵĴúÂë±È½Ï¼òµ¥£¬ÕâÀï¾Í²»½²ÊöÁË¡£ÒÔÏÂËùÈí¼þµÄ´ó¸ÅÔËÐÐЧ¹û¡£
(×¢£º»ÆÉ«¿ò
ÀïÊÇÌáʾÄÚÈÝ£¬ÂÌÉ«¼ýÍ·
¿ÉÒÔµã»÷½øÈëÏÂÒ»»Ãæ¡£)
´Ë³ÌÐòÒѾ¾¹ýÍêÈ«±àÒ룬¿ÉÒÔÖ±½ÓÔËÐС£ÏÖ¸½ÉÏÏÂÔØµØÖ·£ºÏÂÔØµØÖ·Ò»
Ïà¹ØÎĵµ£º
н¨±í£º
create table [±íÃû]
(
[×Ô¶¯±àºÅ×Ö¶Î] int IDENTITY (1,1) PRIMARY KEY ,
[×Ö¶Î1] nVarChar(50) default 'ĬÈÏÖµ' null ,
[×Ö¶Î2] ntext null ,
[×Ö¶Î3] datetime,
[×Ö¶Î4] money null ,
[×Ö¶Î5] int default 0,
[×Ö¶Î6] Decimal (12,4) default 0,
[×Ö¶Î7] image null ,
)
ɾ³ý±í£º
Drop table [±í ......
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
{
......
ÔÚдÕâÆª²©ÎĵÄʱºò£¬ÎÒÕæµÄÈ̲»×¡½ÐÒ»Éù£¬ËûÂèµÄ±ä̬£¬½ñÌì×öÒ»¸öÍøÕ¾Ê±ºò£¬ÓÉÓÚÒªÓõ½ACCESS£¬ÄǾÍÓÃÁË£¬°Ñ֮ǰµÄÁ´½ÓÓï¾äCOPY+C¹ýÀ´
¿´¿´ÓÐʲôÎÊÌâ¡£
string connstr = "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source="+System.Web.HttpContext.Current.Server.MapPath("window2003.mdb");
Ò»¿´£¬Ó¦¸ÃûʲôÎÊÌ ......
*
* ¹¦ÄÜ˵Ã÷:±¸·ÝºÍ»Ö¸´SQL ServerÊý¾Ý¿â
* ×÷Õß: Áõ¹¦Ñ«;
* °æ±¾:V0.1(C#2.0);ʱ¼ä:2007-1-1
* µ±Ê¹ÓÃSQL Serverʱ,ÇëÒýÓà COM×é¼þÖеÄ,SQLDMO.dll×é¼þ
* µ±Ê¹ÓÃAccessÖÐ,Çëä¯ÀÀÌí¼ÓÒýÓÃÒÔÏÂÁ½¸ödll
* ÒýÓÃC:/Progra ......
Access ¹æ¸ñ
Microsoft Access Êý¾Ý¿â¹æ¸ñ
Access Êý¾Ý¿â
ÊôÐÔ×î´óÖµ
Microsoft Access Êý¾Ý¿â (.mdb) Îļþ´óС
2G ×Ö½Ú¼õȥϵͳ¶ÔÏóËùÐèµÄ¿Õ¼ä¡£
Êý¾Ý¿âÖеĶÔÏó¸öÊý
32,768
Ä£¿é£¨°üÀ¨“ÄÚº¬Ä£¿é”ÊôÐÔΪ“ÊÇ”µÄ´°ÌåºÍ±¨±í£©
1,000
¶ÔÏóÃû³ÆÖеÄ×Ö·ûÊý
64
ÃÜÂëµÄ×Ö·û¸öÊý
14
Óû§Ãû ......