ÎÒÔÚVC++ÀﶨÒåÁ˼¸¸öÈ«¾Ö±äÁ¿£¬¾¹ýһϵÁеļÆËãÖ®ºó£¬½«ÕâЩȫ¾Ö±äÁ¿µÄÖµ´æµ½ACCESS¶ÔÓ¦µÄ×Ö¶ÎÏÂÃæ¡£²»Öª¸ÃÈçºÎʵÏÖ¡£Õ⼸¸ö±äÁ¿ÓÐSTRING£¬Ò²ÓÐDOUBLEÀàÐ͵ġ£¸ÃACCESS²»ÓëÈκζԻ°¿òÓбäÁ¿Êý¾Ý´«µÝµÄÁªÏµ£¬½ö½öÊÇ´¢´æ×îºóºÍһϵÁнá¹û¡£
ÎҵijÌÐòÓõÄÊÇODBC£¬²»ÊÇADO¡£¿ÉÒÔÔÚODBCÉÏÌî ¼ÓADOµÄÓï¾äÂð£¿
ÒýÓÃ
Î ......
C# code:
private void BindDB()
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;Data Source=Server.Mappth('/nanhu.mdb')");
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT id,name from tt");
DataSet ds = n ......
ÎÒµ±³õÑ¡Ôñvb.net ,ÊǵÀÌý;˵ËüÄܱà³ÌÐò£¬ÓÖÄܱàÍøÒ³½Å±¾£¬»¹ÄÜÓÃÓÚaccess¼°CADµÄVBA£¬
µ«ÏÖÔÚÈ´²»¶®ÈçºÎÈÃ×Ô¼º±àµÄÕâЩ´úÂëͨÓÃÓÚ³ÌÐò¼°½Å±¾¡£¾ßÌåÎÊÌâÊÇ£º
1£¬ÎÒÏÖÔÚÓÃACCESSŪ³öÀ´µÄÄÇЩ´°Ìå¡¢¼°Æä´úÂ룬ÄÜ·ñÖ±½Ó¸´ÖƵ½ÎÒµÄÍøÒ³ÉÏÈ¥£¿
ÒòΪÎÒµÄÍøÒ³ÉÏÐèÒªµÄÊÇͬÑùµÄ¼Èë´°Ìå¼°²éѯ¡£
2£¬ÏÖÎÒ¶ÔÍøÕ¾ÍøÒ³±àдһµã¶¼ ......
oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐÅÏ¢¡£
EG£º×Ö¶Î1 2 3 4 5
121 Ä㠺ŠÂ𠣿
777 Ä㠺Š......
accessÊý¾Ý¿âÀÏëÒªÔÚ´°ÌåÀï¸´ÖÆÒ»Ìõ¼Ç¼£¬±ÈÈ磺
µ±Ç°¼Ç¼ºÅΪ001£¬Ôڴ˽çÃæÀ°´Ò»¸ö°´Å¥£¬¾Í×Ô¶¯¸´ÖƳö¼Ç¼ºÅΪ002µÄÁíÍâÒ»Ìõ¼Ç¼¡£
Óð´Å¥Ïòµ¼ÀïµÄ¡°¸´ÖÆ¡±Ñ¡Ï×ÜÌáʾÓдúÂëΪ-2147352567£¨80020009£©µÄ´íÎó~~
ÇëÎÊÈçºÎʵÏÖÉÏÊö¹¦ÄÜÄØ£¿
docmd.runsql "insert into table1 select '002',col2,col3,col4 f ......
Ò»¸ö±í5¸ö×Ö¶Î id £¬Ename,ENname,Date,Eremark id Ϊ×ÔÔöÁУ¡
ÎÒдµÄÊÇ
insert into Express values('11','22','33','44') ²»ÐÐ
insert into Express(Ename,ENname,Date,Eremark) values('11','22','33','44')²»ÐÐ
ÔõÑù²ÅÐУ¿£¿£¿£¿
insert into Express values('11','22','33','44') ²»ÐÐ
Õâ¸öÊÇÒòΪȱÉÙÁË×ֶΣ¬ ......