VB SQL3.5Êý¾Ý¿âÐÞ¸Ä
ÎÒÊÇÐÂÊÖÓÃVB2008£¬Êý¾Ý¿âÊÇ×Ô´øµÄSQL3.5. ÓÃdatagridviewÏÔʾijÊý¾Ý±íµÄÊý¾Ý
Êý¾Ý¿âÊÇ Mydata.sdf mydatadataset
°ó¶¨Óà bindingsource
1.ÓÃBotton¿Ø¼þ¸ødatagridviewÌí¼ÓÊý¾Ý²¢±£´æµ½Êý¾Ý±íÀ
È»ºóÔÙË¢ÐÂdatagridviewµÄÊý¾ÝµÄ´úÂëÔõôд.£¨ÓÃÁ½¸ötextbox¸ødatagridviewÌí¼ÓÊý¾Ý£¬±íÁÐΪ"ÊýÁ¿"£¬"¼Û¸ñ"£©
2.ÈçºÎ¶ÔÊý¾Ý±í½øÐÐͳ¼Æ
(1)¸÷ÐÐ×îºóÁÐ×öΪͳ¼Æ¸ñ£¬°ÑÿÐи÷ÁеÄÖµÏà¼Ó¡£
£¨2£©¸÷ÁеÄÊý¾Ý½øÐмÓ×Ü¡£¼Ó×ܽá¹ûÏÔʾÔÚ×îµ×ÐÐ×îºÃÁË¡£
3.¶ÔÊý¾Ý±íËùÓÐÊý¾ÝÇå¿Õ²¢Ë¢Ðµ½datagridview
¶àл¸ßÊÖÖ¸½Ì
vb2008ûÓÐÓùý,²»¹ý´úÂëÓ¦ÊÇÀàËƵÄ,Õë¶ÔµÚ1ºÍ3ÎÊÌâ
²Î¿¼Ò»ÏÂvb6µÄÀý×Ó
http://download.csdn.net/source/1425896
ͬÒâ2¥˵µÄ.
ÎÊÌâ¶à£¬µ«¶¼ºÜ¼òµ¥¡£½¨ÒéÂ¥Ö÷Ïȶ࿴¿´Àý×Ó¡£¡£
Äã×Ô¼º¾ÍÊÇ2Â¥¡£¡£¡£
頂Ò»僂
http://forum.csdn.net/SList/VBDotNET
¶¥Ò»ÏÂ
ËÄÜ°ïÎÒдһ¶ÎÅжϴúÂë°¡£¬¶àлÁË£¡£¡£¡£¡
VB2008£¬Êý¾Ý¿âÊÇ×Ô´øµÄSQL3.5
Êý¾Ý¿âÊÇ Mydata.sdf mydatadataset
°ó¶¨Óà bindingsource
±íÃû£ºCCTJ ×Ö¶ÎÊÇ ¡°Ãû³Æ¡±
Åжϲéѯ Ãû³Ætextbox.textµÄÖµÊÇ·ñÔÚÊý¿âÖÐÒÑ´æÔÚ£¬
Ö±½Ó¸ø·Ö£¡£¡¶àл£¡£¡£¡
http://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqlcommand.aspx
¸ÕѧVB²»Ì«¶®£¬Äܲ»ÄÜ°ïÎÒ°Ñ
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿
ÀýÈ磺
ALTER PROCEDURE [dbo].[sp_1]
@SYS_LNNO varchar(20),
@SYS_CALLER varchar(20),
@SYS_ORGANIZE varchar(10), ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÎÒÓÃDelphiдÁËÒ»¸öDLL, DLLÀïÓÐMDIµÄ×Ó´°Ìå,DLL³õʼ»¯Ê± ´«µÝµ÷ÓÃÕßµÄTApplication¸øDLL, ÔÚDelphi7Öе÷ÓÃÒѾͨ¹ý,µ«ÊDz»ÖªµÀÔÚVBÖÐÓÐÎÞTApplication¶ÔÓ¦ÀàÐÍ, ÊÇ·ñÄÜÔÚVBÖе÷ÓÃ?
ÄãºÃ£¬ÓÃinstance²»ÊǾͿÉÒÔÁË ......
±ÈÈç½ø³Ì¼ÓÔØеijÌÐò¡£
ÔÚÆäÔËÐÐ֮ǰ×èÖ¹¡£
È»ºóÔÊÐíºó·ÅÐС£
±ÈÈç³ÌÐòÖ÷Îļþ·¾¶ÊÇc:\test\test.exe£¬½¨Á¢ÄÚÈÝÈÎÒâµÄÎļþc:\test\test.exe.manifest¡£
¾ÍÊDz»ÖªµÀ³ÌÐòÎļþ·¾¶¡£
ÉèÖ ......