please figure out this, thanks

benges

i'm currently developing a simple program where it run at the system tray and i wanted this program to [b] browse [/b] for a [b] folder [/b], not a file, how can i archieve that in VB .Net?

also, is there anyone knows how to put a SQL command string from the [b] rich text control [/b] to the oleDbCommand.CommandText? i'm asking because i've try many many time and still not work, what am i wrong?

thank a lot...

potatoman

: i'm currently developing a simple program where it run at the system tray and i wanted this program to [b] browse [/b] for a [b] folder [/b], not a file, how can i archieve that in VB .Net?
:
: also, is there anyone knows how to put a SQL command string from the [b] rich text control [/b] to the oleDbCommand.CommandText? i'm asking because i've try many many time and still not work, what am i wrong?
:
: thank a lot...
:
This works.
Get required text from RTB and make equal to a string.
ie:
Dim a as string
a = RTB.Text
(where RTB Text is SELECT Table.Column FROM Table WHERE Conditions;)
Remember that RTB will have to have all the right brackets and semi colon at the end. You may have to do some formatting of the RTB text string.
oleDbCmd.CommandText(a, Connection)