expression check if string

[Daniel]

Hello,

i set a filter to check if my value (from Database) is a String. I don't know how to do it properly. So i use my own Function:

Public Shared Function CheckForAlphaCharacters(ByVal StringToCheck As String) As Boolean

    Try
        Dim i As Integer = 0
        For i = 0 To StringToCheck.Length - 1
            If Char.IsLetter(StringToCheck.Chars(i)) Then
                Return True
            End If
        Next
        Return False
    Catch ex As Exception
        Return False
    End Try

End Function

An this is how i define the filter. (I also added a screenshot)

= MIR.Web.ZinsCheck.Hilfsfunktion.CheckForAlphaCharacters(CStr(Fields.Beschäftigungsverhältnis2)) = True = = True

What I want is, if the Value is Empty the row not visible.

So this wont work. What i'm doing wrong?

But I am also open to other solutions!

Thank you,
Daniel

[Peter]

Hi Daniel,

Our recommendation is to change the user function as shown below:

Public Shared Function CheckForAlphaCharacters(ByVal StringToCheck As Object) As Boolean

    Try
        Dim i As Integer = 0
    Dim stringVar = DirectCast(StringToCheck , String)
        For i = 0 To stringVar.Length - 1
            If Char.IsLetter(StringToCheck.Chars(i)) Then
                Return True
            End If
        Next
        Return False
    Catch ex As Exception
        Return False
    End Try

End Function

Then you don't have to cast the data field:
= CheckForAlphaCharacters(Fields.Beschäftigungsverhältnis2)    =   =True

Regards,
Peter
Telerik

 

 

[Daniel]

Thank you!
Daniel