displaying data in datagird

[mukeshsrivastav]

thanks
but sir writting query is not my problem.major problem i m finding is who to display quered data in datagrid.give me the syntex.datagrid is not allowing me show data searched through the query.it show data in single field filtered mode.
code which i m using is
adodc1.recordset.filter="firstname like ' "& text1.text & "%'".
but system does not take this
adodc1.recordset.filter="firstname like ' "& text1.text & "%'and lastname like' " & text2.text &"%'";

my query returns more then one record.

[Killer42]

thanks
but sir writting query is not my problem.major problem i m finding is who to display quered data in datagrid.give me the syntex.datagrid is not allowing me show data searched through the query.it show data in single field filtered mode.
code which i m using is
adodc1.recordset.filter="firstname like ' "& text1.text & "%'".
but system does not take this
adodc1.recordset.filter="firstname like ' "& text1.text & "%'and lastname like' " & text2.text &"%'";

my query returns more then one record.

Try using * instead of %.

[seshu]

hi sir this is seshu i dont know the exact anser for your query but i can sujjest u to check at one place that is here
you gave ---------------first name like '" & text1.text% & "'
insted try this-------------------firxtname like '" & text1.text & "'%
i think this will work
if not try to concatinate both text,text and %

[Killer42]

you gave ---------------first name like '" & text1.text% & "'
insted try this-------------------firxtname like '" & text1.text & "'%

I'm not certain, but shouldn't the % (or in my opinion, more likely *) be inside the single quote delimiters?