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
Ïà¹ØÎĵµ£º
1.Á¬½ÓÊý¾Ý¿âConnDB()Àà
package tool;
/****************************
**
**ÊôÐÔÎļþÓëÊý¾Ý¿â¾ùÔÚtool°üÏÂÃæ
**
*****************************/
/* Êý¾Ý·ÃÎÊ×é¼þ */
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
impor ......
´´½¨»ùÓÚ¶Ô»°¿òµÄÓ¦ÓóÌÐò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 ......
½ÓÉÏÃæµÄһƪ¡£
·½·¨2£º
´´½¨Ò»¸öµ¥ÎĵµÓ¦ÓóÌÐò -> ÏÂÒ»²½ -> Ñ¡Ôñ Database view without file support £¬
µ¥»÷ Data Source ÔÚµ¯³öµÄ "Êý¾ÝÁ¬½ÓÊôÐÔ" ¶Ô»°¿òÖУ¬Ñ¡Ôñ " Microsoft Jet 4.0 OLE DB Provider " ¡£
µ¥»÷ ÏÂÒ»²½ ÔÚ"Ñ¡Ôñ»òÊäÈëÊý¾Ý¿âÃû³Æ ÖУ¬Ñ¡Ôñ Êý¾Ý¿âÎļþËùÔڵķ¾¶¡£Í¬µÚһƪËùÊö·½·¨£¬Ê¹ÓÃĬ ......
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......
<!--#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)
......