½ðµûÃÔÄã°æAccessÊý¾Ý¿âµÄadoÁ¬½Ó×Ö·û´®
[oledb]
; Everything after this line is an OLE DB initstring
Provider=Microsoft.Jet.OLEDB.4.0;Password=ypbwkfyjhyhgzj;User ID=morningstar;Data Source=C:\Program Files\Kingdee\KIS\BZB\±±¼«ÐÇ.AIS;Persist Security Info=True;Jet OLEDB:System database=C:\Program Files\Kingdee\KIS\BZB\system.mda
Ïà¹ØÎĵµ£º
ǰЩÌìŪһ¸ö·ÃÎÊACCESSÊý¾Ý¿âµÄС¶«Î÷£¬·ÑÁËЩÁ¦Æø²ÅŪºÃ¡£
ËäÈ»»¹ÓÐЩ²»¾¡ÈËÒ⣬µ«ÊÇÖÕ¾¿»¹ÊÇ¿ÉÒÔÓÃÁË£¬
ÔÚÕâÀï·ÖÏíÒ»ÏÂ×Ô¼ºµÄʵÏÖ·½·¨ºÍ¾Ñé¡£
ÀïÃæµÄ¶«Î÷ÍøÉ϶¼ÓУ¬µ«ÊÇ£¬ÕâÀïµÄÊÇ×îÈ«µÄ¡£
VC/MFC·ÃÎÊACCESSÊý¾Ý¿â
·½·¨1£º
1 ´´½¨Ò»¸ö»ùÓÚ¶Ô»°¿òµÄÓ¦ÓóÌÐò¡£
·ÅÈëÁ½¸öActiveX ¿Ø¼þ Mic ......
using System;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.IO;
using System.Windows.Forms;
namespace ImageDB
{
public partial class FormImageAccess : Form
{
#region ×Ô¶¨Òå¶ÔÏó ......
½â¾ö°ì·¨£º
´Ó Windows µÄ“¿ªÊ¼”²Ëµ¥£¬Ö¸Ïò“³ÌÐò”¡¢ “Visual Studio .NET 2003”¡¢“Visual Studio .NET ¹¤¾ß”£¬È»ºóÑ¡Ôñ“Visual Studio .NET ÃüÁî Ìáʾ”¡£ÔÚ´°¿Ú´ò¿ªºó£¬¼üÈë aspnet_regiis /i¼´¿É¡£
²»¿ÉÐеķ½°¸£º
1¡¢ÖØÆôµçÄÔ¡£
2¡¢É¾³ý»º´æ¡£
3¡¢ÖØÐ ......
×¢ÊÍ ±¾Ö÷ÌâÖеÄÐÅÏ¢½öÊÊÓÃÓÚ Microsoft Access Êý¾Ý¿â (.mdb)¡£
Óи÷ÖÖ²»Í¬µÄ²ßÂÔÓÃÀ´¿ØÖÆ¶Ô Microsoft Access Êý¾Ý¿â¼°Æä¶ÔÏóµÄ·ÃÎʼ¶±ð¡£ÏÂÃæ´óÖ°´ÕÕ°²È«¼¶±ðµÄ˳Ðò£¬¼òÒª½éÉÜÕâЩ²ßÂÔ¡£
±àÂë/½âÂë
ΪÊý¾Ý¿â±àÂëÊÇ×î¼òµ¥µÄ±£»¤·½·¨¡£ÎªÊý¾Ý¿â±àÂë¿ÉѹËõÊý¾Ý¿âÎļþ£¬²¢°ïÖú·ÀÖ¹¸ÃÎļþ±»ÎÄ×Ö´¦Àí³ÌÐò¶ÁÈ¡¡£µ« ......
¡øÈÕÆÚ
CDate ½«×Ö·û´®×ª»¯³ÉΪÈÕÆÚ select CDate("2005/4/5")
Date ·µ»Øµ±Ç°ÈÕÆÚ
DateAdd ½«Ö¸¶¨ÈÕÆÚ¼ÓÉÏij¸öÈÕÆÚselect dateAdd("d",30,Date())½«µ±Ç°ÈÕÆÚ¼ÓÉÏ30Ìì,ÆäÖÐd¿ÉÒÔ»»Îªyyyy»òHµÈ
DateDiff ÅжÏÁ½¸öÈÕÆÚÖ®¼äµÄ¼ä¸ô select DateDiff("d","2006-5-1","2006-6-1")·µ»Ø31,ÆäÖÐd¿ÉÒÔ»»Îªyyyy,m,HµÈ
DatePart ·µ» ......