ADOÊý¾Ý¿âÁ¬½ÓAccess
´´½¨»ùÓÚ¶Ô»°¿òµÄÓ¦ÓóÌÐòADO,Ïò¶Ô»°¿òÖÐÌí¼ÓÒ»¸öÁбíÊÓͼ¿Ø¼þ£¬²¢ÎªÆäÌí¼Ó±äÁ¿m_Grid
µÚÒ»²½£ºADO¶ÔÏóµÄµ¼Èë
ÔÚStdAfx.hÍ·ÎļþÖУº
// stdafx.h : include file for standard system include files,
// or project specific include files that are used frequently, bu
// are changed infrequently
//
#if !defined(AFX_STDAFX_H__D5ADC0DF_B5B2_4973_A035_4F2F1585998F__INCLUDED_)
#define AFX_STDAFX_H__D5ADC0DF_B5B2_4973_A035_4F2F1585998F__INCLUDED_
#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
#define VC_EXTRALEAN // Exclude rarely-used stuff from Windows headers
#include <afxwin.h> // MFC core and standard components
#include <afxext.h> // MFC extensions
#include <afxdisp.h> // MFC Automation classes
#include <afxdtctl.h> // MFC support for Internet Explorer 4 Common Controls
#ifndef _AFX_NO_AFXCMN_SUPPORT
#include <afxcmn.h> // MFC support for Windows Common Controls
#endif // _AFX_NO_AFXCMN_SUPPORT
//ADO¶ÔÏóµÄµ¼Èë´úÂë
#import"C:\Program Files\Common Files\System\ado\msado15.dll"
no_namespace rename("EOF","adoEOF")rename("BOF","adoBOF")
//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.
#endif // !defined(AFX_STDAFX_H__D5ADC0DF_B5B2_4973_A035_4F2F1585998F__INCLUDED_)
µÚ¶þ²½£º³õʼ»¯COM»·¾³
BOOL CADOApp::InitInstance()
{
AfxEnableControlContainer();
AfxOleInit();//»òÕß::CoInitialize(NULL);
··················
··················
return FALSE;
}
µÚÈý²½£ºÁ¬½ÓÊý¾Ý¿â
Ïà¹ØÎĵµ£º
protected void Button1_Click(object sender, EventArgs e)
{
/*=============²âÊÔͨ¹ý===============*/
OleDbConnection con = new
OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data
Sou ......
ÍøÉÏËѼ¯£¬±¸ÓÃ
ϱíÁгöÁË ANSI SQL Êý¾ÝÀàÐͺ͵ÈЧµÄ Microsoft Jet Êý¾Ý¿âÒýÇæ SQLÊý¾ÝÀàÐÍ»¹ÓÐËüÃǵÄÓÐЧͬÒå×ÖÒÔ¼° µÈЧµÄ Microsoft SQL ServerÊý¾ÝÀàÐÍ¡£
ANSI SQL
Êý¾ÝÀàÐÍ
Microsoft Access
SQL Êý¾ÝÀàÐÍ
ͬÒå´Ê
Microsoft SQL
Server Êý¾ÝÀàÐÍ
BIT¡¢BIT VARYING
BINARY£¨²Î¼û×¢ÊÍ£©
VARBINARY¡¢ ......
set adoCN =createobject("ADODB.CONNECTION")
set strCnn =createobject("ADODB.Recordset")
set rstSchema =createobject("ADODB.Recordset")
Dim I
dim n
str1 ......
private const string ACCESS_UPDATE_ADMIN_PASSWORD = "UPDATE [Admins] SET admin_pass=@adminPass WHERE admin_name=@adminName";
dbInstance.SetParameters("@adminPass", _adminDObj.Admin_Password);
dbInstance.SetParameters("@adminName", _adminDObj.Admin_Name);
²ÎÊýµÄ˳Ðò±ØÐëºÍSQLµÄ˳ÐòÒ»Ö±£¬·ñÔòÎÞ·¨¸ ......