Searching Databases

[jeric_john]

i have one textbox,one button, and one MSHFlex Grid, and another is ADOControl1 in my form
the question is:
how can I find the employee number in my database from the number inputted from the textbox????

what is the code for that?

[mikee_phil]

on the command button

adodc1.recordsource="select * from table1 where employee_number=' " & text1.text &" ' "
adodc1.refresh

[jeric_john]

after I select that??? I will display that on the FlexGrid??? so how will I bind that???

[mikee_phil]

set flexgrid1.datasource = adodc1

or on the property window of the flexgrid set the datasource to adodc1

[jeric_john]

how about to delete a record??? by only typing it in the textbox, then It it will the record?

[mikee_phil]

use adodc1.recorset.delete