how do i refresh datagrid control

[vai]

i'm working in visual basic.
i want to dispaly the records in a datagrid control who's
data source is adodc.i want to display the records for a particular date.
i.e. if the date which i accept from the user exists,then for that
particular date all the records must be displayed.
my problem is when i run my form all the records are displayed.
the records ,which are in my access database table.
so i set the following properties,

Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "select * from invoice where Datein=" & Val(txtdate.Text)
Adodc1.Refresh
DataGrid1.Refresh

even then the above code doesn't work.
how do i refresh datagrid control??

[hariharanmca]

i'm working in visual basic.
i want to dispaly the records in a datagrid control who's
data source is adodc.i want to display the records for a particular date.
i.e. if the date which i accept from the user exists,then for that
particular date all the records must be displayed.
my problem is when i run my form all the records are displayed.
the records ,which are in my access database table.
so i set the following properties,

Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "select * from invoice where Datein=" & Val(txtdate.Text)
Adodc1.Refresh
DataGrid1.Refresh

even then the above code doesn't work.
how do i refresh datagrid control??

Good, But you never Initialize the datagrid to ADODC1.
if it is not, then you have to fill that datagrid.

[vai]

Good, But you never Initialize the datagrid to ADODC1.
if it is not, then you have to fill that datagrid.

i tried initializing the datagrid to ADODC1.
but its not working.
datagrid control is not refreshing.
pls help me.

[fplesco]

i tried initializing the datagrid to ADODC1.
but its not working.
datagrid control is not refreshing.
pls help me.

Hi -

Is your datagrid control bind to ADODC1?

Like

Set DataGrid1.Recordsource = Adodc1.Recordsource 'OR Recordset
 

Well, Im not sure at those methods but you can try play on that.

I'll try this at home and I'll get back to you once this is not yet solved.

[hariharanmca]

i tried initializing the datagrid to ADODC1.
but its not working.
datagrid control is not refreshing.
pls help me.

can you post the code, how you bind the datagrid to your datagrid?

[vai]

can you post the code, how you bind the datagrid to your datagrid?

thanks a lot sir !!
my code is working now.
first of all i initialized DATAGRID control to ADODC.
then i run my SQL Query.
thanks once again.