Dynamically Updating Datagrid with tables

[phani24]

I have a stored procedure which takes two parameters(start date and enddate) and creates a table with some data. Now I am trying to execute this stored procedure through DataEnvironment. I have a datagrid (whose datasource is DataEnvironment) which displays the table created through this stored procedure. My problem is I am not able to update the datagrid with changing parameters. In other words, as the parameters values changes, a table with new data is created, but I am not able to see this updated table in datagrid, though the table is updated in Sql server.
I used DataGrid.ClearField and also tried DataGrid.Refresh. None of them worked.
[sig][/sig]

 

[gantibabu]

Hi, i think the DataGrid doesnt support the UNBOUND MODE. So try refreshing the datacontrol or the recordset u r binding the DataGrid to (you may want to even requery it). Thats the best i can suggest. All the best...vijay [sig][/sig]

 

[phani24]

Thank You very much. Actually I haven't used ADODC previously. Now, I have included and refreshed it. It works perfectly well.

Thank You.

[sig][/sig]