VB 問題

2007-12-04 11:14 pm
在vb裡面點樣寫 cmd 令到 program 識從 d.b中 抽取某一行filed 而且將某一行filed 加總 ( 我只要加總後既數)

ps. 已經connect 到 d.b

回答 (1)

2007-12-05 12:00 am
✔ 最佳答案
Please refer following link to get example to get data from database:

http://www.vbexplorer.com/VBExplorer/vb_feature/june2000/Database_Beginner_ADO_DAO.asp

In the program, you need to perpare the SQL statement to extract the data from database.
Syntax: Select Field1, Feild2.... Field3+Field4 from TableName where Field1="XXX"
Exmaple: Select Name, Salary+Bonus from employee where name ="Chan Tai Man"

Please try.


收錄日期: 2021-04-23 22:36:48
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20071204000051KK01276

檢視 Wayback Machine 備份