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

accessϵķÖÒ³·½°¸

¾ßÌå²»¶à˵ÁË£¬Ö»Ìù³öÏà¹ØÔ´Âë~
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using System.Web;
/**//// <summary>
/// Ãû³Æ£ºaccessϵķÖÒ³·½°¸£¨·Âsql´æ´¢¹ý³Ì£©
/// ×÷Õߣºcncxz(³æ³æ)
/// blog£ºhttp://cncxz.cnblogs.com
/// </summary>
public class AdoPager
{
    protected string m_ConnString;
    protected OleDbConnection m_Conn;
    public AdoPager()
    {
        CreateConn(string.Empty);
    }
    public AdoPager(string dbPath)
    {
        CreateConn(dbPath);
    }
    private void CreateConn(string dbPath)
    {
        if (string.IsNullOrEmpty(dbPath))
        {
            string str = System.Configuration.ConfigurationManager.AppSettings["dbPath"] as string;
            if (string.IsNullOrEmpty(str))
                str = "~/App_Data/db.mdb";
            m_ConnString = string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data source={0}", HttpContext.Current.Server.MapPath(str));
        }
        else
            m_ConnString = string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data source={0}", dbPath);
        m_Conn = new OleDbConnection(m_ConnString);
    }
    /**//// <summary>
    /// ´ò¿ªÁ¬½Ó
    /// <


Ïà¹ØÎĵµ£º

PHP²Ù×÷AccessÊý¾Ý¿â

9.3  ͨ¹ýPHP²Ù×÷AccessÊý¾Ý¿â
9.3.1  Á¬½ÓAccessÊý¾Ý¿â
ÔÚPHPÖÐÁ¬½ÓAccessÓÐÈçÏÂ3ÖÖ·½Ê½¡£
£¨1£©´´½¨ÏµÍ³Êý¾ÝÔ´£¬ÓÃPHPÌṩµÄODBCº¯Êý
¼´¿É¡£
£¨2£©Í¬Ñù¿ÉÒÔʹÓÃPHPµÄODBCº¯Êý£¬µ«²»´´½¨
Êý¾ÝÔ´¡£¿ª·ÅÊý¾Ý¿âÁ¬½Ó£¨Open DateBase
Conection£¬ODBC£©ÊÇWindows Open
Server£¨¿ª·Å·þÎñ£©API£¨WOSA£©²úÆ·Ö®Ò ......

CodeSmithÁ¬½ÓAccess,Sql,Oracle,mysql

ACCESSÊý¾Ý¿â
1:CodeSmithÑ¡ÖÐÁ´½ÓÀàÐÍÊÇ£ºADOXSchema
2:ÎÞÃÜÂëµÄAccessÁ´½ÓΪ£º
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\hh\db.mdb;
3:ÓÐÃÜÂëµÄAccessÁ´½Ó£º
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\hh\db.mdb;
Jet OLEDB:Database Password=1111
SqlÊý¾Ý¿â
server=192.1.1.14;User ID=test; ......

ÈçºÎѹËõ´øÓÐmdw°²È«Îļþ»úÖÆºÍÃÜÂëµÄµÄaccessÊý¾Ý¿â

a £½ “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\Êý¾Ý¿â.mdb;Password=¹ÜÀíÔ±ÃÜÂë;User ID=¹ÜÀíÔ±ÕʺÅ;Jet OLEDB:Database Password=Êý¾Ý¿âÃÜÂë;Jet OLEDB:System database=d:\system.MDW;”  ' ´Ë´¦Óû§ÕÊ»§±ØÐë¾ßÓйÜÀíԱȨÏÞ²ÅÐÐ,´Ë´¦ÊÇÖ¸Á¬½ÓÐèҪѹËõµÄÊý¾Ý¿âµÄÁ¬½Ó´úÂë.
 
b £½ &ldq ......

Ö±½Óͨ¹ýADO²Ù×÷AccessÊý¾Ý¿â£¨Ð޸İ棩

±¾Îĸù¾ÝVCKBASEÍøÕ¾µÄÉϵġ¶Ö±½Óͨ¹ýADO²Ù×÷AccessÊý¾Ý¿â
¡·
Ð޸ĶøÀ´£¬°æÈ¨¹éÔ­×÷Õß/Ðì¾°ÖÜ
Ö±½Óͨ¹ýADO²Ù×÷AccessÊý¾Ý¿â

×÷Õß/Ðì¾°ÖÜ

ÏÂÔØÔ´´ú
Âë
    ÎÒÔÚ¡¶VC֪ʶ¿âÔÚÏßÔÓÖ¾¡·µÚÊ®ËÄÆÚºÍµÚÊ®ÎåÆÚÉÏÔø·¢±íÁËÁ½ÆªÎÄÕ——“Ö±½Óͨ¹ýODBC¶Á¡¢Ð´Exce ......

MFC ´úÂëÅäÖÃACCESSµÄODBCÁ¬½Ó

 SQLConfigDataSource
´´½¨ODBCÊý¾ÝÔ´¿ÉÒÔµ÷ÓÃWindowsϵͳ×ÓÄ¿
¼ÏµĶ¯Ì¬Á´½Ó¿âOdbcint.dllÖеĺ¯ÊýSQLConfigDataSource()
¸Ãº¯Êý¿ÉÒÔ¶¯Ì¬µØÔö¼Ó¡¢Ð޸ĺÍɾ³ý
Êý¾ÝÔ´¡£
SQLConfigDataSource()º¯Êý
SQLConfigDataSource()µÄÔ­ÐÍÈçÏÂ:
BOOL SQLConfigDataSource(HWND hwndParent, UINT
fRequest ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ