Asp.net Functions

Source: Internet
Author: User
Tags natural logarithm
ABS (number)Obtain the absolute value of a value.
ASC (string)Obtains the first ASCII code of a string expression.
ATN (number)Returns the arc tangent of an angle.
Callbyname (object, procname, usecalltype, [ARGs ()])Executes the method, setting, or returning the attributes of an object.
Cbool (expression)The conversion expression is of the boolean type.
Cbyte (expression)The conversion expression is a byte type.
Cchar (expression)The conversion expression is in the convert format.
Cdate (expression)The conversion expression is of the date type.
Cdbl (expression)The conversion expression is of the double type.
Cdec (expression)The conversion expression is of the decimal type.
CINT (expression)The conversion expression is of the integer type.
Clng (expression)The conversion expression is of the long type.
Cobj (expression)The conversion expression is of the object type.
Cshort (expression)The conversion expression is of the short type.
Csng (expression)The conversion expression is of the single type.
CSTR (expression)The conversion expression is of the string type.
Choose (index, choice-1 [, choice-2,... [, choice-N])Select and return the set parameters based on the index value.
CHR (charcode)Get the character content in ASCII code.
Close (filenumberlist)End the archive enabled with open.
Cos (number)Returns the cosine of an angle.
Ctype (expression, typename)Type of the conversion expression.
Dateadd (dateinterval, number, datetime)Add or subtract the date or time.
Datediff (dateinterval, date1, date2)Calculate the difference between two dates or times.
Datepart (dateinterval, date)Return year, month, day, or time based on the received date or time parameter.
Dateserial (year, month, day)Combine the received parameters into a data of date type only with date.
Datevalue (datetime)Obtain the date value that matches the country-specific style and contains the time.
Day (datetime)Return the date according to the received date parameter.
EOF (filenumber)True is returned when the end of an opened file is reached.
Exp (number)Returns the power of e Based on the received parameter.
Filedatetime (pathname)The date and time when the file was created.
Filelen (pathname)The length of the returned file, in bytes.
Filter (sourcearray, Match [, include [, compare])Search for the specified string in the string array. If the array element contains the specified string, it is combined into a new string array and returned. If you want to return an array element that does not contain the specified string, set the include parameter to false. The compare parameter is used to set whether the search is case sensitive. In this case, you only need to give textcompare constants or 1.
Fix (number)Remove the fractional part of the parameter and return it back.
Format (expression [, style [, firstdayofweek [, firstweekofyear])Convert the date, time, and numeric data into a format acceptable to each country.
Formatcurrency (expression [, numdigitsafterdecimal [, includeleadingdigit])Output the value as the amount type. The numdigitsafterdecimal parameter indicates the number of decimal words, And the deleadingdigit parameter indicates whether to fill in the number of integer words when the integer is 0.
Formatdatetime (date [, namedformat])Returns formatted date or time data.
Formatnumber (expression [, numdigitsafterdecimal [, includeleadingdigit])Returns formatted numeric data. The numdigitsafterdecimal parameter indicates the number of decimal words, And the deleadingdigit parameter indicates whether to fill in the number of integer words when the integer is 0.
Formatpercent (expression [, numdigitsafterdecimal [, includeleadingdigit])Return numeric data converted to percentage format. The numdigitsafterdecimal parameter indicates the number of decimal words, And the deleadingdigit parameter indicates whether to fill in the number of integer words when the integer is 0.
Getattr (filename)Returns the attribute value of an object or directory.
Hex (number)Convert a value to a hexadecimal value.
Hour (time)The hour field of the return time. The type is integer.
IIF (expression, truepart, falsepart)If the return value of the expression is true, the program of the truepart field is executed, and the falsepart field is executed.
Instr ([start,] string1, string2)Search for the characters set by the string2 parameter that appear in the character string. Start is used to search for the characters. string1 is the string to be searched, and string2 is the character to be searched.
INT (number)Returns the maximum integer less than or equal to the value of the received parameter.
Isarray (varname)Determines whether a variable is an array type. If it is an array, true is returned. Otherwise, false is returned.
Isdate (expression)Determines whether the expression content is of the datetime type. If the expression content is of the datetime type, true is returned. Otherwise, false is returned.
Isdbnull (expression)Determines whether the expression content is null. If the expression content is null, true is returned. Otherwise, false is returned.
Isnumeric (expression)Determines whether the expression content is Numeric. If the expression content is true, false is returned.
Join (sourcearray [, delimiter])Merges string arrays into unique strings. The delimiter parameter is used to add new strings to each element.
Lcase (string)Converts a string to a lowercase font.
Left (string, length)The character set length is obtained from the left side of the string.
Len (string)Returns the length of a string.
Log (number)Obtain the natural logarithm of a value.
Ltrim (string)Remove the left blank part of the string.
Mid (string, start [, length])Retrieve the string with the length after the character set by the Strat parameter in the string. If the length parameter is not set, retrieve all the characters after start.
Minute (time)Obtain the time content, in the integer type.
Mkdir (PATH)Create a new directory.
Month (date)Obtain the month of the date. The type is integer.
Monthname (month)Obtain the complete description of the month based on the received month value.
Now ()Obtain the current date and time.
Oct (number)Convert a value to an octal value.
Replace (expression, find, replace)Convert the string specified by the find parameter in the string to the string specified by the replace parameter.
Right (string, length)Gets the characters with the length parameter set from the right side of the string.
Rmdir (PATH)Remove an empty directory.
RND ()Returns a decimal number between 0 and 1. If you want to obtain different values each time, you must add randomize before use.
Rtrim (string)Removes the white space on the right of the string.
Second (time)The second part of the time content. The type is integer.
Sign (number)If the value is positive or negative, positive returns 1, negative returns-1, and 0 returns 0.
Sin (number)Returns the sine of an angle.
Space (number)Gets the blank string set by the number parameter.
Split (expression [, delimiter])Use the condition string set by the delimiter parameter to split the string into a string array.
SQRT (number)Returns the square root of a number.
STR (number)Convert the number into a string and return it back.
Strreverse (expression)Returns the result after the string content is reversed.
Tan (number)Returns the tangent of an angle.
Timeofday ()Obtain the time that does not contain a date.
Timer ()Returns the number of seconds from 0: 00 to the current time. Its type is double.
Timeserial (hour, minute, second)Merge the received parameters into a data with only the time date type.
Timavalue (time)Obtain the time value that conforms to the country-specific style.
Today ()Obtain the date that today does not contain the time.
Trim (string)Removes the white space at the beginning and end of the string.
Typename (varname)Obtains the type of a variable or object.
Ubound (arrayname [, dimension])Obtain the final index value of the array. The dimension parameter is the final index value of the dimension specified to be obtained.
Ucase (string)Converts a string to uppercase.
Val (string)Converts a string representing a number to a numeric value. If the string contains non-numeric content, it is removed and merged into a number.
Weekday (date)The date in the parameter is the day of the week, Sunday is 1, Monday is 2, and Tuesday is 3.
Weekdayname (number)Obtain the name of the week based on the received parameters. The parameters that can be received are 1 to 7, Sunday is 1, Monday is 2, and Tuesday is 3. Author's blog:Http://blog.csdn.net/AppleBBS/
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.