ÔÚÏß:ÈçºÎ½«DataTableÖеÄÊý¾ÝдÈëµ½AccessÊý¾Ý¿âÖÐ!
Dim datatable As New DataTable ½¨Á¢µÄÒ»¸öÄÚ´æ±í¡£
ÈçºÎ°Ñdatatable ±íÖеÄÊý¾Ý£¬±£´æµ½ACCESSÊý¾Ý¿â¡£×îºÃÓÐÀý×ÓºÍÔ´Âë
ÓÃoledbµÄÊý¾Ý¿âÁ¬½Ó¶ÔÏóºÍÊý¾ÝÊÊÅäÆ÷µÈ¶ÔÏó£¬Àý
string cnStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " + "c:\\data.mdb";
OleDbConnection cn = new OleDbConnection(cnStr);
OleDbDataAdapter da = new OleDbDataAdapter("select * from ÄãµÄ±íÃû",cn);
//data.mdbÖеıí½á¹¹ºÍÄãµÄdatatableÏàͬ;
OleDbCommandBuilder cmb = new OleDbCommandBuilder(da);
da.Update(ÄãµÄ±í);
http://topic.csdn.net/u/20090915/10/e93241bb-4aa0-4184-bdcd-6a589936a27f.html
http://topic.csdn.net/u/20090910/16/177fdb55-1cac-4765-b192-9f4f29762287.html
·ÖÊý²»¶à ´ó¼Ò¿ÉÒÔÈ¥ÕâÁ½¸öÌùÀï·¢Ìû À´×ÅÓзÝÁË Ð»Ð»ÁËÄãÃÇ£¡£¡
up£¡
Ïà¹ØÎÊ´ð£º
¸øaccessÊý¾Ý¿â¼ÓÃܵIJ½ÖèÈçÏ£º
£¨1£©´ò¿ªaccessÈí¼þ£¬½çÃæÈçͼ1Ëùʾ
......
//**********************************
//³ÌÐò¹¦ÄÜ£º´´½¨AccessÊý¾Ý¿âºÍÊý¾Ý±í
//**********************************
unit Unit1;
interface
uses
Windows, Messages, SysUtils, ......
´´½¨µÄ¹ý³ÌÖгöÏÖdatabase login¶Ô»°¿ò£¬ÇëÎÊÔõôÑù²»ÈøöԻ°¿ò³öÏÖ£¿ÁíÍâÈçºÎ¶¨ÒåÈÕÆÚÐÍÊý¾ÝΪ¶ÌÈÕÆÚÐÍ£¿ºÃÏñÖ»Äܶ¨ÒåΪDatetime¡£
Ô´ÂëÈçÏ£º
£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½ ......
´ó¸ÅÇé¿ö£º
C#дµÄwinformÓ¦ÓóÌÐò£¬ÒªÇó³ÌÐòÕûÌìÔËÐС£Êý¾Ý±íºÍÊý¾ÝÁ¿²¢²»´ó£¬±í×î¶à15¸ö£¬ÐÂÔöÊý¾ÝÿÈÕ×î¶à1000Ìõ£¬¶øÇÒ±íÖÐÖ»±£Áôµ±ÌìÊý¾Ý¡£
ÐèҪעÒâµÄÊdzÌÐò¶Ô±íµÄ²éѯºÍÐ޸ķdz£Æµ·±£¬¶øÇÒÊǶà¸öÏß³ÌÍ¬Ê ......
dim conn
dim connstr
dim db
dim dbpaswd (Õâ¸öÃÜÂë¼ÓÔÚÄÄ)
db=dbpath&"/"&dbname
connstr="DBQ="+server.mappath(""&db&"")+" ......