VB.NET校驗字符串是否是日期
|
1
2
3
4
5
6
7
8
9
|
'Validate for a dateShared Function checkdate(ByVal thisvalue As String) As String If Not IsDate(thisvalue) Then checkdate = "NULL" Else checkdate = "'" & thisvalue & "'" End If Return checkdateEnd Function ' END checkdate |
VB.NET檢查字符串是否是數字
|
1
2
3
4
5
6
7
8
9
10
11
12
|
'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~'Used to submit values to the database, check for empty value, replace w/ "NULL"'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Shared Function checkNumber(ByVal thisvalue As String) As String If IsDBNull(thisvalue) Or Len(thisvalue) = 0 Or Not IsNumeric(thisvalue) Then checkNumber = "NULL" Else checkNumber = thisvalue End If Return checkNumberEnd Function ' END checkNumber |
以上所述就是本文的全部內容了，希望大家能夠喜歡。
