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

AccessÊý¾Ý¿âת»»ÎªsdfÊý¾Ý¿â¼°SqlCeHelperÀà

ÔÚ×öMobileÏîĿʱÓöµ½Ò»¸öÎÊÌ⣬ÎÒÃǵÄMobileÏîÄ¿ÐèҪʹÓÃSqlCeÊý¾Ý¿â£¬¶ø¿Í»§ÌṩµÄ´øÓÐԭʼÊý¾ÝµÄÊý¾Ý¿âÊÇAccess¸ñʽµÄ£¬ËùÒÔÎÒÃÇÃæÁٵĵÚÒ»¸öÎÊÌâÊǽ«AccessÊý¾Ý¿â£¨*.mdb£©×ª»»³ÉSqlCeÊý¾Ý¿â£¨*.sdf£©¡£ÍøÉÏËÑË÷µÄºÜ¶à×ÊÁÏÊǹØÓÚÈçºÎ½«SqlServer 2005ÓëSqlCeÊý¾Ý½øÐÐͬ²½£¬Ö÷ÒªÊÇͨ¹ý·¢²¼¶©Ôļ°RDA±à³ÌÀ´ÊµÏÖ£¬¿ÉÒԲο¼µÄ×ÊÁÏÓУº
Óà SQL Server Management Studio ¹ÜÀí SQL Server Compact Edition Êý¾Ý¿â
SQL CE ºÍ SQL Server µÄͬ²½
Step by Step: Program Microsoft SQL Server CE 2.0 Merge Replication Using .NET Compact Framework
    ºóÀ´ÕÒµ½Ò»¸ö¹¤¾ßData Port Wizard¿ÉÒÔÖ±½Ó½«ÆäËûÊý¾Ý¿âת»»ÎªSqlCeÊý¾Ý¿â£¬Ê¡Á˲»ÉÙÊ¡£Ö»ÊÇת»»¹ý³ÌÖÐÓöµ½Ò»¸öССµÄÎÊÌ⣬ÔÚ¿Í»§ÌṩµÄAccessÊý¾Ý¿âµÄ¹ØÏµÀïÉèÖÃÁ˺ܶà±íÓë±íÖ®¼äµÄ¹ØÏµ£¬µ«ËùÓÐµÄ±í¶¼Ã»ÓÐÉèÖÃÖ÷¼ü£¬ËùÒÔת»»Ê±¾ÍÅ׳öÒì³£¡£ÎªÁËʡʣ¬ÎÒ½«Access±íµÄ¹ØÏµÈ«²¿É¾³ý£¬ÕâÑù¾Í˳ÀûµÄ½«AccessÊý¾Ý¿âת»»³ÉSqlCe 3.5°æ±¾µÄsdfÊý¾Ý¿âÁË¡£
    ÖÁÓÚ²Ù×÷SqlCeµÄÊý¾Ý²ãµÄÀ࣬ÔÚÍøÉÏÕÒµ½Ò»¸öSqlCeHelper.cs£¬×ªÌùÈçÏ£º
using System;
using System.Data;
using System.Data.SqlServerCe;
using System.Configuration;
using System.Collections;
namespace SbuxMobile.DAL
{
///
/// The SqlCeHelper class is intended to encapsulate high performance, scalable best practices for
/// common uses of SqlClient
///
public sealed partial class SqlCeHelper
{
#region private utility methods & constructors
// Since this class provides only static methods, make the default constructor private to prevent
// instances from being created with "new SqlCeHelper()"
private SqlCeHelper() { }
///
/// This method is used to attach array of SqlCeParameters to a SqlCeCommand.
///
/// This method will assign a value of DbNull to any parameter with a direction of
/// InputOutput and a value of null.
///
/// This behavior will prevent default values from being used, but
/// this will be the less common case than an intended pure output pa


Ïà¹ØÎĵµ£º

javaÎÞÊý¾ÝÔ´Á¬½ÓAccessÊý¾Ý¿âʵÀý

  1.Á¬½ÓÊý¾Ý¿âConnDB()Àà
package tool;
/****************************
**
**ÊôÐÔÎļþÓëÊý¾Ý¿â¾ùÔÚtool°üÏÂÃæ
**
*****************************/
/* Êý¾Ý·ÃÎÊ×é¼þ */
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
impor ......

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 ......

VC/MFCÖеÄACCESSÊý¾Ý¿â·ÃÎÊʵÏÖ(·½·¨2)

½ÓÉÏÃæµÄһƪ¡£
·½·¨2£º
´´½¨Ò»¸öµ¥ÎĵµÓ¦ÓóÌÐò -> ÏÂÒ»²½ -> Ñ¡Ôñ Database view without file support £¬
µ¥»÷ Data Source ÔÚµ¯³öµÄ "Êý¾ÝÁ¬½ÓÊôÐÔ" ¶Ô»°¿òÖУ¬Ñ¡Ôñ " Microsoft Jet 4.0 OLE DB Provider " ¡£
µ¥»÷ ÏÂÒ»²½ ÔÚ"Ñ¡Ôñ»òÊäÈëÊý¾Ý¿âÃû³Æ ÖУ¬Ñ¡Ôñ Êý¾Ý¿âÎļþËùÔڵķ¾¶¡£Í¬µÚһƪËùÊö·½·¨£¬Ê¹ÓÃĬ ......

SQL SERVERÓëACCESS,EXCELµÄÊý¾Ýת»»

ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......

asp AccessÊý¾Ý±¸·Ý,»¹Ô­,ѹËõÀà

 <!--#include file="config.asp" -->
<!--#include file="Fun.asp" -->
<%
'Êý¾Ý¿â¹ÜÀíÀà
class Datas
'±¸·Ý
public sub Bk()
Set fso=server.createobject("scripting.filesystemobject")
fso.CopyFile Server.MapPath(SiteDataPath),Server.MapPath(SiteDataBakPath)
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ