Recordset & Datagrid

hi,
i am using datagrid and recordset for displaying records from table.

_______
cmd_click()
strsql = "select * from employee where ename like '" & txtename.Text & "%'"

rs.open strsql,cn
datagrid.datasource = rs

'rs.close
'rs.requery
end sub

after entering the value in txtename and pressing button , i am getting records in datagrid but when i am trying to execute second time with another value , i unable to get the records. when i am closing the rs i cannot able to see the records in datagird (it's flashing the records)
pl. help for solving the problem.

bye.

Hi Pravalike, I tried your code with a MSHFlexgrid and it worked fine. I could get it to go at all with a recordset as a simple data grid.

HTH

Lenin