Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Who can help me to search?

Hi.
I want to write some codes that make a search for my database in vb if you know some thing please help me.
thanks.
[126 byte] By [Visual Basic] at [2007-11-11 10:09:36]
# 1 Re: Who can help me to search?
What kind of database is it? How are you connecting to it (DAO, ADO, etc)?
Phil Weber at 2007-11-11 17:23:04 >
# 2 Re: Who can help me to search?
you may execute sql search statment in the event open in the record set .. rs.open "SQL_COMMAND"
Amahdy at 2007-11-11 17:24:15 >
# 3 Re: Who can help me to search?
Hi; My connection to database is sql's and i can't do any thing that i want :(
Visual Basic at 2007-11-11 17:25:13 >
# 4 Re: Who can help me to search?
your problem is with the SQL command itself or with the way to execute the command ?
u have allready a connection with a record called "rs" say ,
use this : rs.open "PUT_HERE_A_SQL_COMMAND"
but if you r searching about the sql command so u need to make a small search in this forum or in the web about how to search using sql commands ..
it's generally some thing like that :
SELECT * FROM tabel WHERE field LIKE %searched_word_here%
and then the rs will conatins a table of all results .
Amahdy at 2007-11-11 17:26:08 >
# 5 Re: Who can help me to search?
Try this: http://www.google.com/search?q=vb+ado+tutorial
Phil Weber at 2007-11-11 17:27:14 >
# 6 Re: Who can help me to search?
Hi.
Thanks for youre help.
It can help me, thanks ;)
Visual Basic at 2007-11-11 17:28:13 >
# 7 Re: Who can help me to search?
also try this link

http://www.connectionstrings.com helped me alot. ive got a search function in my program if you still need help
vchatlive at 2007-11-11 17:29:17 >