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]
I used DataGrid.ClearField and also tried DataGrid.Refresh. None of them worked.
[sig][/sig]