Updating Report Problem

[shahriar2403]

I am really having a tough time to update my report contents. Please help me with a project attaching with your solution. please help me quick......

[cometburn]

update report contents? can u explain more about this?

[shahriar2403]

I am using adodc to connect with my database in my application. I have command button to show my report consisting of the columns of that table in database. I also have command button to add data in the database during runtime. I can see the report updated for any firsttime i press the button. but after adding any new data in the database i cant see the new datas in my report . The report was just as the previous one. But again restarting the application i got the updated report. I want my report to update every time i press the show report button. How can i do that? If you have any solution please help me by attaching a project with your solution. Please help me.

[debasisdas]

Have you tried refreshing the recordset ?

Are you commiting after every new insert / update ?

[shahriar2403]

What should be the code for refreshing? I use
"dim rs as recordset"
and after doing "rs!add new"
i do "rs.update"
It is under add data command.
Show report command only have "report.show"
What should i do actually?
I am using datagrid.

[cometburn]

Try this and Tell me if it worked.

'Add this to Command Button
DataEnvironment1.Recordsets("Command3").Requery
DataReport2.Show

'And this to obviously, Data Report
Private Sub DataReport_Terminate()
DataEnvironment1.Recordsets("Command3").Close
End Sub

[shahriar2403]

Many many thanks cometburn. Your code do the work for me. I had to use only the first part of the code. Terminating the report does not help. Manu many thanks again bro.....

[cometburn]

Glad to help!