发表于 2009-1-5 19:48
| 
VB.net甯哥敤鍑芥暟
鍙戝竷: 2008-6-26 22:01 | 浣滆: admin | 鏌ョ湅: 18娆
Ucase(string) 灏嗗瓧绗︿覆杞崲涓哄ぇ鍐欍
Val(string) 灏嗕唬琛ㄦ暟瀛楃殑瀛楃涓茶浆鎹负鏁板煎瀷鎬侊紝鑻ュ瓧绗︿覆涓惈鏈夐潪鏁板瓧鐨勫唴瀹瑰垯浼氬皢鍏跺幓闄ゅ悗锛屽悎骞朵负涓鏁板瓧銆
Weekday(date) 鍙栫殑鍙傛暟涓殑鏃ユ湡鏄竴涓槦鏈熺殑绗嚑澶╋紝鏄熸湡澶╀负1銆佹槦鏈熶竴涓2銆佹槦鏈熶簩涓3 渚濇绫绘帹銆
WeekDayName(number) 渚濇帴鏀剁殑鍙傛暟鍙栧緱鏄熸湡鐨勫悕绉帮紝鍙帴鏀剁殑鍙傛暟涓1 鍒7锛屾槦鏈熷ぉ涓1銆佹槦鏈熶竴涓2銆佹槦鏈熶簩涓3 渚濇绫绘帹銆
Split(expression[, delimiter]) 浠elimiter 鍙傛暟璁惧畾鐨勬潯浠跺瓧绗︿覆鏉ュ皢瀛楃涓插垎鍓蹭负瀛楃涓叉暟缁勩
Sqrt(number) 鍙栧緱涓鏁板煎緱骞虫柟鏍广
Str(number) 灏嗘暟瀛楄浆涓哄瓧绗︿覆鍚庝紶鍥炪
StrReverse(expression) 鍙栧緱瀛楃涓插唴瀹瑰弽杞悗鐨勭粨鏋溿
Tan(number) 鍙栧緱鏌愪釜瑙掑害鐨勬鍒囧笺
TimeOfDay() 鍙栧緱鐩墠涓嶅寘鍚棩鏈熺殑鏃堕棿銆
Timer() 鍙栧緱鐢0:00 鍒扮洰鍓嶆椂闂寸殑绉掓暟锛屽瀷鎬佷负Double銆
TimeSerial(hour, minute, second) 灏嗘帴鏀剁殑鍙傛暟鍚堝苟涓轰竴涓彧鏈夋椂闂碊ate 鍨嬫佺殑鏁版嵁銆
Timavalue(time) 鍙栧緱绗﹀悎鍥藉埆璁惧畾鏍峰紡鐨勬椂闂村笺
Today() 鍙栧緱浠婂ぉ涓嶅寘鍚椂闂寸殑鏃ユ湡銆
Trim(string) 鍘绘帀瀛楃涓插紑澶村拰缁撳熬鐨勭┖鐧姐
TypeName(varname) 鍙栧緱鍙橀噺鎴栧璞＄殑鍨嬫併
Ubound(arrayname[, dimension]) 鍙栧緱鏁扮粍鐨勬渶缁堢储寮曞硷紝dimension 鍙傛暟鏄寚瀹氬彇寰楃鍑犵淮搴︾殑鏈缁堢储寮曞笺
MonthName(month) 渚濇帴鏀剁殑鏈堜唤鏁板煎彇寰楄鏈堜唤鐨勫畬鏁村啓娉曘
Now() 鍙栧緱鐩墠鐨勬棩鏈熷拰鏃堕棿銆
Oct(number) 灏嗘暟鍊煎弬鏁拌浆鎹负8 杩涘埗鍊笺
Replace(expression, find, replace) 灏嗗瓧绗︿覆涓璮ind 鍙傛暟鎸囧畾鐨勫瓧绗︿覆杞崲涓簉eplace 鍙傛暟鎸囧畾鐨勫瓧绗︿覆銆
Right(string,length) 鐢卞瓧绗︿覆鍙宠竟寮濮嬪彇寰條ength 鍙傛暟璁惧畾闀垮害鐨勫瓧绗︺
RmDir(path) 绉婚櫎涓涓┖鐨勭洰褰曘
Rnd() 鍙栧緱浠嬩簬0 鍒1 涔嬮棿鐨勫皬鏁帮紝濡傛灉姣忔閮借鍙栧緱涓嶅悓鐨勫硷紝浣跨敤鍓嶉渶鍔犱笂Randomize 鍙欒堪銆
Rtrim(string) 鍘绘帀瀛楃涓茬殑鍙宠竟绌虹櫧閮ㄥ垎銆
Second(time) 鍙栧緱鏃堕棿鍐呭鐨勭閮ㄥ垎锛屽瀷鎬佷负Integer銆
Sign(number) 鍙栧緱鏁板煎唴瀹规槸姝ｆ暟鎴栬礋鏁帮紝姝ｆ暟浼犲洖1锛岃礋鏁颁紶鍥-1锛0 浼犲洖0銆
Sin(number) 鍙栧緱涓涓搴︾殑姝ｅ鸡鍊笺
Space(number) 鍙栧緱number 鍙傛暟璁惧畾鐨勭┖鐧藉瓧绗︿覆銆
IsDate(expression) 鍒ゆ柇琛ㄨ揪寮忓唴瀹规槸鍚︿负DateTime 鍨嬫侊紝鑻ユ槸鍒欎紶鍥濼rue锛屽弽涔嬪垯涓篎alse銆
IsDbNull(expression) 鍒ゆ柇琛ㄨ揪寮忓唴瀹规槸鍚︿负Null锛岃嫢鏄垯浼犲洖True锛屽弽涔嬪垯涓篎alse銆
IsNumeric(expression) 鍒ゆ柇琛ㄨ揪寮忓唴瀹规槸鍚︿负鏁板煎瀷鎬侊紝鑻ユ槸鍒欎紶鍥濼rue锛屽弽涔嬪垯涓篎alse銆
Join(sourcearray[, delimiter]) 灏嗗瓧绗︿覆鏁扮粍鍚堝苟鍞竴涓瓧绗︿覆锛宒elimiter 鍙傛暟鏄瀹氬湪鍚勪釜鍏冪礌闂村姞鍏ユ柊鐨勫瓧绗︿覆銆
Lcase(string) 灏嗗瓧绗︿覆杞崲涓哄皬鍐欏瓧浣撱
Left(string, length) 鐢卞瓧绗︿覆宸﹁竟寮濮嬪彇寰條ength 鍙傛暟璁惧畾闀垮害鐨勫瓧绗︺
Len(string) 鍙栧緱瀛楃涓茬殑闀垮害銆
Log(number) 鍙栧緱鏁板肩殑鑷劧瀵规暟銆
Ltrim(string) 鍘绘帀瀛楃涓茬殑宸﹁竟绌虹櫧閮ㄥ垎銆
Mid(string, start[, length]) 鍙栧嚭瀛楃涓蹭腑strat 鍙傛暟璁惧畾鐨勫瓧绗﹀悗length 闀垮害鐨勫瓧绗︿覆锛岃嫢length 鍙傛暟娌℃湁璁惧畾锛屽垯鍙栧洖start 浠ュ悗鍏ㄩ儴鐨勫瓧绗︺
Minute(time) 鍙栧緱鏃堕棿鍐呭鐨勫垎閮ㄥ垎锛屽瀷鎬佷负Integer銆
MkDir(path) 寤虹珛涓涓柊鐨勭洰褰曘
Month(date) 鍙栧緱鏃ユ湡鐨勬湀閮ㄥ垎锛屽瀷鎬佷负Integer銆
FormatDateTime(date[,namedformat]) 浼犲洖鏍煎紡鍖栫殑鏃ユ湡鎴栨椂闂存暟鎹
FormatNumber(expression[,numdigitsafterdecimal [,includeleadingdigit]]) 浼犲洖鏍煎紡鍖
鐨勬暟鍊兼暟鎹侼umdigitsafterdecimal 鍙傛暟涓哄皬鏁板瓧鏁帮紝includeleadingdigit 鍙傛暟涓哄綋鏁存暟涓0 鏃舵槸鍚﹁ˉ鑷虫暣鏁板瓧鏁般
FormatPercent(expression[,numdigitsafterdecimal [,includeleadingdigit]]) 浼犲洖杞崲涓虹櫨鍒嗘瘮鏍煎紡鐨勬暟鍊兼暟鎹俷umdigitsafterdecimal 鍙傛暟涓哄皬鏁板瓧鏁帮紝includeleadingdigit 鍙傛暟涓哄綋鏁存暟涓0 鏃舵槸鍚﹁ˉ鑷虫暣鏁板瓧鏁般
GetAttr(filename) 浼犲洖妗ｆ鎴栫洰褰曠殑灞炴у笺
Hex(number) 灏嗘暟鍊煎弬鏁拌浆鎹负16 杩涘埗鍊笺
Hour(time) 浼犲洖鏃堕棿鐨勫皬鏃跺瓧娈碉紝鍨嬫佹槸Integer銆
Iif(expression, truepart, falsepart) 褰撹〃杈惧紡鐨勪紶鍥炲间负True 鏃舵墽琛宼ruepart 瀛楁鐨勭▼搴忥紝鍙嶄箣鍒欐墽琛宖alsepart 瀛楁銆
InStr([start, ]string1, string2) 鎼滃string2 鍙傛暟璁惧畾鐨勫瓧绗﹀嚭鐜板湪瀛楃涓茬殑绗嚑涓瓧绗︼紝start 涓虹敱绗嚑涓瓧绗﹀紑濮嬪鎵撅紝string1 涓烘鎼滃鐨勫瓧绗︿覆锛宻tring2 涓烘鎼滃鐨勫瓧绗︺
Int(number) 浼犲洖灏忎簬鎴栫瓑浜庢帴鏀跺弬鏁扮殑鏈澶ф暣鏁板笺
IsArray(varname) 鍒ゆ柇涓涓彉閲忔槸鍚︿负鏁扮粍鍨嬫侊紝鑻ヤ负鏁扮粍鍒欎紶鍥濼rue锛屽弽涔嬪垯涓篎alse銆
Day(datetime) 渚濇帴鏀剁殑鏃ユ湡鍙傛暟浼犲洖鏃ャ
Eof(filenumber) 褰撴姷杈句竴涓寮鍚殑妗ｆ缁撳熬鏃朵細浼犲洖True銆
Exp(number) 渚濇帴鏀剁殑鍙傛暟浼犲洖e 鐨勬鏂瑰笺
FileDateTime(pathname) 浼犲洖妗ｆ寤虹珛鏃剁殑鏃ユ湡銆佹椂闂淬
FileLen(pathname) 浼犲洖妗ｆ鐨勯暱搴︼紝鍗曚綅鏄疊yte銆
Filter(sourcearray, match[, include[, compare]]) 鎼滃瀛楃涓叉暟缁勪腑鐨勬寚瀹氬瓧绗︿覆锛屽嚒鏄暟缁勫厓绱犱腑鍚湁鎸囧畾瀛楃涓诧紝浼氬皢瀹冧滑缁撳悎鎴愭柊鐨勫瓧绗︿覆鏁扮粍骞朵紶鍥炪傝嫢鏄浼犲洖涓嶅惈鎸囧畾瀛楃涓茬殑鏁扮粍鍏冪礌锛屽垯include 鍙傛暟璁句负False銆俢ompare 鍙傛暟鍒欐槸璁惧畾鎼滃鏃舵槸鍚﹀尯鍒嗗ぇ灏忓啓锛屾鏃跺彧瑕佺粰TextCompare 甯告暟鎴1 鍗冲彲銆
Fix(number) 鍘绘帀鍙傛暟鐨勫皬鏁伴儴鍒嗗苟浼犲洖銆
Format(expression[, style[, firstdayofweek[, firstweekofyear]]]) 灏嗘棩鏈熴佹椂闂村拰鏁板艰祫鏂欒浆涓烘瘡涓浗瀹堕兘鍙互鎺ュ彈鐨勬牸寮忋
FormatCurrency(expression[,numdigitsafterdecimal [,includeleadingdigit]]) 灏嗘暟鍊艰緭鍑轰负閲戦鍨嬫併
numdigitsafterdecimal 鍙傛暟涓哄皬鏁板瓧鏁帮紝includeleadingdigit 鍙傛暟涓哄綋鏁存暟涓0 鏃舵槸鍚﹁ˉ鑷虫暣鏁板瓧鏁般
CObj(expression) 杞崲琛ㄨ揪寮忎负Object 鍨嬫併
CShort(expression) 杞崲琛ㄨ揪寮忎负Short 鍨嬫併
CSng(expression) 杞崲琛ㄨ揪寮忎负Single 鍨嬫併
CStr(expression) 杞崲琛ㄨ揪寮忎负String 鍨嬫併
Choose (index, choice-1[, choice-2, ... [, choice-n]]) 浠ョ储寮曞兼潵閫夋嫨骞朵紶鍥炴墍璁惧畾鐨勫弬鏁般
Chr(charcode) 浠SCII 鐮佹潵鍙栧緱瀛楃鍐呭銆
Close(filenumberlist) 缁撴潫浣跨敤Open 寮鍚殑妗ｆ銆
Cos(number) 鍙栧緱涓涓搴︾殑浣欏鸡鍊笺
Ctype(expression, typename) 杞崲琛ㄨ揪寮忕殑鍨嬫併
DateAdd(dateinterval, number, datetime) 瀵规棩鏈熸垨鏃堕棿浣滃姞鍑忋
DateDiff(dateinterval, date1, date2) 璁＄畻涓や釜鏃ユ湡鎴栨椂闂撮棿鐨勫樊鍊笺
DatePart (dateinterval, date) 渚濇帴鏀剁殑鏃ユ湡鎴栨椂闂村弬鏁颁紶鍥炲勾銆佹湀銆佹棩鎴栨椂闂淬
DateSerial(year, month, day) 灏嗘帴鏀剁殑鍙傛暟鍚堝苟涓轰竴涓彧鏈夋棩鏈熺殑Date 鍨嬫佺殑鏁版嵁銆
Datevalue(datetime) 鍙栧緱绗﹀悎鍥藉埆璁惧畾鏍峰紡鐨勬棩鏈熷硷紝骞跺寘鍚椂闂淬
Abs(number) 鍙栧緱鏁板肩殑缁濆鍊笺
Asc(String) 鍙栧緱瀛楃涓茶〃杈惧紡鐨勭涓涓瓧绗SCII 鐮併
Atn(number) 鍙栧緱涓涓搴︾殑鍙嶆鍒囧笺
CallByName (object, procname, usecalltype,[args()]) 鎵ц涓涓璞＄殑鏂规硶銆佽瀹氭垨浼犲洖瀵硅薄鐨勫睘鎬с
CBool(expression) 杞崲琛ㄨ揪寮忎负Boolean 鍨嬫併
CByte(expression) 杞崲琛ㄨ揪寮忎负Byte 鍨嬫併
CChar(expression) 杞崲琛ㄨ揪寮忎负瀛楃鍨嬫併
CDate(expression) 杞崲琛ㄨ揪寮忎负Date 鍨嬫併
CDbl(expression) 杞崲琛ㄨ揪寮忎负Double 鍨嬫併
CDec(expression) 杞崲琛ㄨ揪寮忎负Decimal 鍨嬫併
CInt(expression) 杞崲琛ㄨ揪寮忎负Integer 鍨嬫併
CLng(expression) 杞崲琛ㄨ揪寮忎负Long 鍨嬫
