return values without sorting

[fj8283888]

Hi,

The following code is to find the record in the database, I have a question to ask that, this function will do the sorting before find the record, the problem is I want to keep the order as it shows in database. is it possible to find the record without sorting??

 

 

Public Function SearchUserName(ByVal test3 As String, ByVal coltosearch As String) As Integer


       If Not myds Is Nothing Then
           If (myds.Tables.Count > 0) Then
               myds.Tables("Staff").DefaultView.Sort = "FirstName"
               Return myds.Tables("Staff").DefaultView.Find(test3)

           Else
               Return -1
           End If
       Else
           Return -1
       End If
   End Function

Thanks,

fj8283888

[Nerseus]

Why do you need the line:

myds.Tables("Staff").DefaultView.Sort = "FirstName"

 

?

 

-ner

[johansec]

Find searchs on the Sort field.

 

Whichever field you sort by is the field the .Find uses to search on.