vb decimalÀàÐÍ - VB / »ù´¡Àà
ÏÖÔÚÎÒsql2000ÀïÃæÓÐÒ»¸ödecimalÀàÐ͵Ä×Ö¶Î
ÎÒ´ÓÎı¾¿òÊäÈëÊý×Ö£º
ÀýÈ磺12.11 ¾ÍÕý³£¡£Èç¹ûÊäÈë 12.00£¬Ð´ÈëÊý¾Ý¿â¾ÍÖ»ÓÐ12 £¬Èç¹ûÊäÈë0.12£¬Êý¾Ý¿âÀï¾ÍÖ»ÓÐ .12 ¡£
ÇëÎÊ£¬Ôõô°ÑСÊýµãǰºóµÄ 0 ÏÔʾ³öÀ´£¿
ÏÔʾµ½¿Ø¼þÖÐʱ¸ñʽ»¯Ò»Ï¾ͿÉÒÔ£º
text1.text=format(rs!×Ö¶ÎÃû,"###0.00")
°Ñ decimalÀàÐ͵Ä×Ö¶Î ¸ÄÏÂÐв»?¸Ä³Éfloat
ллÁË
ÇëÎÊÏ£¬sql2000ÀïÃædecimalÀàÐ͵Ä×Ö¶Î
ÔõôÏÔʾ 12.00 £¿
¸Ä³ÉfloatÒ²²»ÐУ¬sql2000ÀïÃæÏÔʾ²»³öÀ´Ð¡ÊýµãºóÃæµÄ 0
ÄãÔÚ×Ö¶ÎÖÐÉèÖÃСÊýλÊÇÁ½Î»°É
ÎÒµÄSQL2000ÊÇ¿ÉÒÔÏÔʾµÄ ÎÊÌâÓÐ2¸ö Ò»¸öÊÇÄã´«ÈëµÄʱºòÊÇÕûÐÎ »¹ÓÐÒ»¸öÊÇÄãSQL µÄÎÊÌâ
ÊDz»ÊÇ¡°ÏÔʾ¸ñʽÉèÖá±µÄÔµ¹Ê£¿
Ò»¸öÈ·¶¨µÄÊýÖµ¿ÉÒÔÓжàÖÖÏÔʾ¸ñʽ½øÐбíʾ¡£
Ïà¹ØÎÊ´ð£º
DIM ds as new DataSet
ÎÒÕâÑùÉùÃ÷ ÔõÀÏÊDZ¨ Óû§¶¨ÒåÀàÐÍ䶨Ò壿 Õâ¸öÐèÒªÒýÓÃʲôÂ𣿣¿
ǰÌáÊÇDataSet¶ÔÏóÒª´æÔÚ,¾ÍÊǶÔÏóä¯ÀÀÆ÷ÖÐÓÐËü.ûÓоÍÒªÒýÓÃ.
datasetÊÇADO.NET¶ÔÏó
Èç¹ûÄãÓõÄÊÇvb.net£¬ÄÇôÔÚ´ ......
ÏÖÔÚÓиöxmlÎļþÊÇ<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xm ......
ÎÊÌ⣺
ÏÖÔÚAccessÊý¾Ý¿âÖÐÓÐÁ½ÕűíTableAºÍTableB
TableAÖÐÓмǼÈçÏÂ:
×Ö¶Î1(Name) ×Ö¶Î2(Num)
A 3
A 4
B 6
... ......
ÓÃVB±à³Ì¶ÁÈ¡¶ÌÐÅ,µÃµ½Ò»´ó¶Ñunicode±àÂë,Çë½ÌÈçºÎת»»³ÉÎı¾
ÀýÈç:¶ÁÈ¡¶ÌÐźó(»ªÎª900C»òTC35i),´®¿ÚµÃµ½ÈçÏÂÊý¾Ý:
+CMGL: 17,"REC UNREAD","8615007557713",,"10/03/30,09:37:15+32&qu ......