Urgent : Data grid not refreshing properly

[muddasirmunir]

i make a form whic has one data grid and one text box and one button
when i write a name on tex box and click add the name stored in database successfully.
now in the grid i want to show all the names but after i add no name is seen on datagrid but if i add second time the first name appear on the datagrid and when i entery third entry the second name apperar

i use the following code

adodc1.recordset.requery

why it show one field alway less than in database

i also try to make a connection with the coding by this

 dim rs as recordset 
rs.open "select name from customer",conn,adopenstatic,adlockoptimestic
set datagrid1.datasource=rs
 

on the load event but it does not show any data on datagrid why

urgent help is need ,
while i am using ms access , before that i use sqlserver and successfully connect datagrid to database but ms access is not working properly

[debasisdas]

Try to refresh the recordset.

[muddasirmunir]

also refreshing will do the same
if i click the button to add the record add but it only refresh the name
which i add previous and the current record does not showns until
i add another

is there any similar thing like datagrid i find flexgrid by did not properly
code it what is the coding to attached a recorset to flexgrid
when i do it like datagrid it give me error

Try to refresh the recordset.

[daniel aristidou]

[quote=muddasirm unir]their is no option like this

adodc1.recordset.refresh

Try

adodc1.refresh

[muddasirmunir]

i got it by closing recordset and then reopening

[shuvo2k6]

i got it by closing recordset and then reopening

u can Try by this:
Adodc1.RecordSo urce = "select * from Info Where ID<" & CInt(Text1.Text ) & ";"
Adodc1.Refresh

Get better.

Regards,
shuvo2k6

[muddasirmunir]

actually refreshing and requring is not working properly
so i close the recordset and then again open it by diong this my problem solved.

u can Try by this:
Adodc1.RecordSo urce = "select * from Info Where ID<" & CInt(Text1.Text ) & ";"
Adodc1.Refresh

Get better.

Regards,
shuvo2k6