Find button coding

[saima khushbakht]

hi
i need coding for find button using adodc control.the search should be by name.if we enter the name of employee then search button should search name from data base either it exists in batabase as first name,middle name, or as last name.the list should display.then if we click particular name from the list then data of that particular employee should display.

[hariharanmca]

hi
i need coding for find button using adodc control.the search should be by name.if we enter the name of employee then search button should search name from data base either it exists in batabase as first name,middle name, or as last name.the list should display.then if we click particular name from the list then data of that particular employee should display.

You can do it in single line of Query.

Dim strSql As String
 
 strSql = " Select * from tblTableName where strSearchField like '" & trim(txtSearchText) & "' or intSearchField = " & val(txtSearchValue) & ""
 
Dim rstAdodc As New ADODC.Recordset
 
rstADODC.Open strsql, Dbonnection, Cursor type, Lock type
 
 

then
FillControlsWithRecordSet()

[saima khushbakht]

hi
thanks for doing help me.
but this code is generating errors on lines 5 and 7.please tell me about how to fill controls with recordset.
i wll be gratefull to you.
regards

You can do it in single line of Query.

Dim strSql As String
 
 strSql = " Select * from tblTableName where strSearchField like '" & trim(txtSearchText) & "' or intSearchField = " & val(txtSearchValue) & ""
 
Dim rstAdodc As New ADODC.Recordset
 
rstADODC.Open strsql, Dbonnection, Cursor type, Lock type
 
 

then
FillControlsWithRecordSet()

[Killer42]

thanks for doing help me.
but this code is generating errors on lines 5 and 7.please tell me about how to fill controls with recordset.

Could you be more specific? What errors?

[hariharanmca]

hi
thanks for doing help me.
but this code is generating errors on lines 5 and 7.please tell me about how to fill controls with recordset.
i wll be gratefull to you.
regards

You have to Import ADODC OCX refferenct to your project. if it is there, Then post the code you had tryed with error descreption.