winform ACCESS δָ¶¨µÄ´íÎó 100·Ö
winformÓ¦ÓóÌÐò
Á¬½Ó×Ö·û´®
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dbpath
dbpathΪ¾ø¶Ô·¾¶ Õâ¸ö·¾¶ÊÇûÓÐÈκÎÎÊÌâµÄ
ÔÚÖ´Ðе½connection.open()ʱ ±¨System.Data.OleDb.OleDbException: δָ¶¨µÄ´íÎó
¾¹ýËÑË÷ºó ·¢ÏֺܶàÀàËÆµÄ´íÎó¶¼ÊÇASP.NETµÄ ·¢ÏÖÒÔϽâ¾ö·½·¨
1.ÐÞ¸ÄTEMPĿ¼ȨÏÞ£¨ÒòΪÊÇwinform³ÌÐò ËùÒÔÓ¦¸ÃºÍÕâ¸öÎÞ¹Ø Î´³¢ÊÔ£©
2.ѹËõÐÞ¸´Êý¾Ý¿â(ÎÞЧ)
3.ÖØÐÂ×¢²áACCESSÇý¶¯£¨ÎÞЧ£©
Êý¾Ý¿âÊǵ¥»úʹÓà ²»´æÔÚ²¢·¢ÎÊÌâ ÇÒͬÑù´úÂë ÔÚÆäËû»úÆ÷ÉÏ¿ÉÒÔÔËÐÐ ¿ÉÄܾÍÓÐ1-2̨»úÆ÷ÓÐÕâÑùµÄÎÊÌâ
ÇëÎÊ´ó¼ÒÓöµ½¹ýÕâÑùµÄÎÊÌâÂð ÓÐûÓÐʲô°ì·¨¿ÉÒÔ½â¾ö£¿
Server.MapPath()²é¿´Â·¾¶£¿
ÓÐÁ´½Ó³É¹¦¹ýÂð£¿
»ØÂ¥ÉÏ ÊÇwinform ²»ÊÇasp.net
ͨ¹ýApplication.StartupPath+""ÉèÖõØÖ·
¹À¼ÆÊÇ·¾¶£¬Êý¾Ý¿âµÄÃû×Ö£¬»¹ÓÐÊÇ·ñÉèÖÃÁËÃÜÂ룬Êý¾Ý¿âÊÇ·ñÒѱ»ÆäËû³ÌÐò´ò¿ªµÈµÈÓйØÏµ¡£¡£¡£
¾ßÌåµÄÔÒò»¹Õæ²»ÊÇÒÔÏ ¾ÍÄÜ¿´³öÀ´µÄ
ÎÒ²âÊÔÁËÒ»ÏÂ
·¾¶ÊǾø¶ÔûÓÐÎÊÌâµÄ ÒòΪÔÚ±¨´íµÄ»úÆ÷ÉÏ °Ñ·¾¶Êä³öÁË Í¨¹ýÊä³ö·¾¶ ÊÇ¿ÉÒÔ´ò¿ªACCESSµÄ
Êý¾Ý¿âûÓÐÃÜÂë ҲûÓб»ÆäËû³ÌÐò´ò¿ª
»ù±¾ÉÏ¿ÉÒÔÅųýACCESSµÄÎÊÌâ ÒòÎªÖØÐÂ×¢²áÁËÇý¶¯ºó Ìáʾע²á³É¹¦ È»ºó°ÑûÓб¨´í»úÆ÷ÉϵÄACCESS¿½±´¹ýÀ´ ¸²¸ÇÔACCESSÎļþ µ«ÒÀ¾É±¨´í
ÏÖ»³ÒÉÊÇ£º
1.ȨÏÞ²»×ã ÒòΪÎÒÃǵĻúÆ÷ ¶¼¼ÓÈëÁËÓò µ«µÇ½µÄϵͳÕË»§Ò²¼ÓÈëµ½ÁËȨÏÞÖÐ ¿É
Ïà¹ØÎÊ´ð£º
<?php
include("adodb/adodb.inc.php");
$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.J ......
_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
int ret = 0;
_RecordsetPtr pset;
CString sql;
& ......
SELECT *
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="C:\Documents and Settings\**\My Documents\cc.mdb";User ID=Admin;Password=')...a
ÎÒÖ»ÖªµÀ ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ
µ±Êý¾Ý¿â×Ö¶ÎÎ ......