PLs pls help me!!!!!!!!!

[WoF]

That's not the propblem. If you look at the following code segment

       With rs2
           .Open strSQL, conn1, adOpenStatic, adLockOptimistic
           Set MSHFlexGrid1.DataSource = rs2
           If .EOF ...

you'd note that immediately after the rs2.Open statement I have connected the flexgrid to the datasource of rs2. The result of the Open statement should immediately show in the grid.
At the time of open the sql line is
Select * from personaldetails where Student_name like "c*";
and the results are zero
Change the sql to
Select * from personaldetails where Student_name like "chris";
and it finds the record where Student_name is chris.
So why does the Like "c*" not find chris, too? That's here the question.

I'd anyway advise more changes to the code belonging the .EOF, but this makes no sense as long as the Like statement does not deliver records as expected.