Hello, can anyone tell me what i am missing here??
I have a textbox named "txtLidcode " I have a datagrid named "data"
I have a command button named "command3" The datdagrid has a datasource of
an ado control named "adodc1". When the "command3" button is clicked i have
strSql = "Select * from Leden WHERE Lidcode LIKE ´ *" & txtLidcode.Text &
"*´"
adodc1.Recordso urce = strSql
the adodc1 control have the same query
oke when i click the button nothing happens.
when i use this query
strSql = "Select * from Leden WHERE Lidcode LIKE a "
then it just replaces the Lidcide field with the input value in the textbox
"txtLidcode "
What is want is when the user types the letter "a" for instance that the
query fill find all the names staring with a. what is wrong about this??
Jeroen
I have a textbox named "txtLidcode " I have a datagrid named "data"
I have a command button named "command3" The datdagrid has a datasource of
an ado control named "adodc1". When the "command3" button is clicked i have
strSql = "Select * from Leden WHERE Lidcode LIKE ´ *" & txtLidcode.Text &
"*´"
adodc1.Recordso urce = strSql
the adodc1 control have the same query
oke when i click the button nothing happens.
when i use this query
strSql = "Select * from Leden WHERE Lidcode LIKE a "
then it just replaces the Lidcide field with the input value in the textbox
"txtLidcode "
What is want is when the user types the letter "a" for instance that the
query fill find all the names staring with a. what is wrong about this??
Jeroen