VB6 Help

[Tharindu DR]

Hello every1...
need some help for my project.

Can any1 giv me cording to search a name from a database
and if no match then how to display the Matches according to the letters..

eg= Search Tharindu

Result I want.....
Tharindu
Tharuka
Thamara
Tarzan

like that...
in to a list box or something.
Can any1 help...???

 

[Dan01]

machan umba access database 1kda use karanne.?
data environment ekak harahada connect karala thiyenne.?

 

[Tharindu DR]

machan umba access database 1kda use karanne.?
data environment ekak harahada connect karala thiyenne.?

Ow machan access
Cording walin ma thamai connect karala thiyenne.
DAnnawada kramayak?

 

[Dan01]

machan okata podi trick ekak use karanna venava.
mama Data environment haraha thamai database connect karanne.
ekedi nam search karanna

dim searchname as string
searchname = "your search text"
with dat.rstest '______________________dat = your Data environment, rstest = your data table name with "rs"
Rechk: .filter = "col'='" & searchname & "'"
if .recoredcount < 1 then
if len(searchname ) = 1 then exit sub
searchname =left( searchname ,len(searchname )-1)
goto Rechk:
end if
for i = 1 to .recoredcount
list1.additem !col
next
end with


meka try karala balapan.

 

[Tharindu DR]

Ela Thanx machan...