Ïê½âVBµ÷ÓÃC#Àà¿âµÄ·½·¨²½Ö裨תÔØ£©
ʹÓÃc#ÓïÑÔÔÚ.netƽ̨Éú³ÉµÄdllÊÇ»ùÓÚMSILµÄ¶þ½øÖÆ´úÂ룬ͨ³£Çé¿öÏÂÊÇÎÞ·¨±»nativeµÄÓïÑԺͳÌÐòµ÷Óõģ¨ÀýÈçvb£¬vc£¬delphi£©¡£µ«ÊÇÒ»°ãÀ´ËµwindowsÉÏnativeµÄ³ÌÐò¶¼ÊÇ¿ÉÒÔÖ±½ÓʹÓÃcom¶ÔÏóµÄ¡£Í¨¹ý.netƽ̨ÌṩµÄһЩ¹¤¾ß£¬¿ÉÒÔΪÆäαÔìÒ»¸öcom½Ó¿Ú²¢×¢²áµ½ÏµÍ³ÖС£´Ëʱ£¬¿ÉÒÔÔÚnativeµÄ³ÌÐòÀͨ¹ýÕâ¸öαcom½Ó¿ÚÀ´ÊµÏÖ´Ë.netµÄdllµÄµ÷Óá£
vbµ÷ÓÃC#Àà¿âµÄ·½·¨²½Öè
1 ʹÓÃC#½¨Á¢.netµÄdll
1.1 ½¨Á¢ÏîÄ¿
ÔÚ.netÖÐн¨Ò»¸öÏîÄ¿£ºTestCom¡£
1.2 ʵÏÖc#Àà
ÔÚclass1.csÎļþÖÐÌí¼ÓÒ»¸ö½Ó¿ÚºÍÒ»¸öÀࣺ
using System; using System.Collections.Generic; using System.Text; using System.Runtime.InteropServices; namespace TestCom { [ComVisible(true)] public interface iClass1 { string test(); } [ComVisible(true)] [ClassInterface(ClassInterfaceType.AutoDual)] public class Class1 : iClass1 { public string test() { return "ok"; } } }
×¢Òâ½Ó¿ÚºÍÀàÉϵÄÊôÐÔ£¬¶Ôcom¿É¼ûºÍÉú³ÉcomÀàÐÍ¡£
1.3Ìí¼ÓÇ¿Ãû
Ñ¡Ôñ¿ªÊ¼²Ëµ¥ÖÐVistual StudioĿ¼ÏµÄVistual Studio ToolsϵÄVistual Studio ÃüÁîÌáʾ¡£Ê¹ÓÃsn -k c:\myKey.snkÉú³ÉÇ©ÃûÎļþ¡£
ÔÚÏîÄ¿ÉÏÓÒ¼ü£¬µã»÷ÊôÐÔ£¬Ñ¡ÔñÇ©Ãû£¬Ñ¡ÖÐΪ³ÌÐò¼¯Ç©Ãû£¬Ñ¡ÔñmyKey.snkÎļþ¡£
1.4Éú³É½â¾ö·½°¸
ÔÚÏîĿĿ¼µÄ\TestCom\bin\DebugÖпÉÒÔÕÒµ½TestCom.dll¡£
Ïà¹ØÎĵµ£º
ÕâÒ»¶Î´ó¼Ò±àд³ÌÐòºÜ¶àʱºò¶¼ÔÚʹÓÃAPI,Ëü¸øÎÒÃÇ´øÀ´ÁËÇ¿´óµÄ¹¦ÄÜ.ÈÃÎÒÃǷdz£¾ªÏ².
µ«ÊÇÎÒÃÇÔÚµ÷ÊÔ³ÌÐòµÄʱºòÓÐʱºò×ܻᱼÀ£.ÕâÑùºÜ²»·½±ã.
ÆäÖÐÓÐЩÊÇapiÈǵĻö
ʹÓÃapi×¢ÒâÊÂÏî:
Ê×ÏÈÎÒ˵˵ÎҵĹ۵ã.
1:ApiÊǺܶàϵͳҲÔÚÓÃ.ÎÒÃÇÔÚÉèÖòÎÊýʱÈç¹ûºÍϵͳµÄ²ÎÊýÓгåÍ».¾Í¿ÉÄÜÒýÆðÈí¼þ³ö´í
2.apiºÜ¶à¶¼ÊÇcÓïÑÔ±àдµÄ, ......
bigint ´Ó -2^63 (-9223372036854775808) µ½ 2^63-1 (9223372036854775807) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 8 ¸ö×Ö½Ú¡£ Int64
int ´Ó -2^31 (-2,147,483,648) µ½ 2^31 - 1 (2,147,483,647) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 4 ¸ö×Ö½Ú¡£int µÄ SQL-92 ͬÒå×ÖΪ integer¡£ Int32
smallint ´Ó -2^15 (-32,768) µ½ ......
C#Á¬½ÓMySQLÊý¾Ý¿â·½·¨
1¡¢ÓÃMySQLDriverCSÁ¬½ÓMySQLÊý¾Ý¿âÏÈÏÂÔغͰ²×°MySQLDriverCS£¬µØÖ·£º
http://sourceforge.net/projects/mysqldrivercs
ÔÚ°²×°Îļþ¼ÐÏÂÃæÕÒµ½MySQLDriver.dll£¬È»ºó½«MySQLDriver.dllÌí¼ÓÒýÓõ½ÏîÄ¿ÖÐ
×¢£ºÎÒÏÂÔصÄÊÇ°æ±¾ÊÇ MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe
using System; ......
±¾ÎÄת×Ô£ºhttp://blog.csdn.net/jinjazz/archive/2008/07/14/2650506.aspx
½«oledb¶ÁÈ¡µÄexcelÊý¾Ý¿ìËÙ²åÈëµÄsqlserverÖУ¬ºÜ¶àÈËͨ¹ýÑ»·À´Æ´½Ósql£¬ÕâÑù×ö²»µ«ÈÝÒ׳ö´í¶øÇÒЧÂʵÍÏ£¬×îºÃµÄ°ì·¨ÊÇʹÓÃbcp£¬Ò²¾ÍÊÇSystem.Data.SqlClient.SqlBulkCopy ÀàÀ´ÊµÏÖ¡£²»µ«Ëٶȿ죬¶øÇÒ´úÂë¼òµ¥£¬ÏÂÃæ²âÊÔ´ú ......
ÎÄÕÂÀ´Ô´:vb´óÊÀ½ç ×÷ÕߣºÍõ¹úÈÙ
¡¸VB ûÓÐÌṩÕâÑùµÄ¹¦ÄÜ£¬ ±ØÐëºô½Ð Windows API¡¹£¬ µ±±ÊÕßÕâÑù»Ø´ð¶ÁÕßÖ®áᣬÓÐЩ¶ÁÕß»áÒªÇó±ÊÕß½éÉÜ Windows API ·½ÃæµÄÊé¼®£¬ ÓÈÆäÊÇÖÐÎÄÊ飬 µ«Êµ¼ÊÉÏ£¬Ä¿Ç°ÊÐÃæÉÏÖ»¿´µ½Ò»±¾ÔÎÄÊé(ZD Press ³ö°æµÄ Visual Basic 5.0 Programming Guide to Win32 API)£¬ ÖÐÎÄÊéÔòδ¼û¹ý£¬ Ϊʲ÷áÃ»Ó ......