Hi,

I add a record to an Access database from a detailsview. I also have a separate gridview that is filtered by a dropdown list choice. When I add the record it does not appear in the dropdown list choice or in the gridview. If I reconnect to the web site however, it shows up properly. What am I doing wrong.

Thanks,

Tom

Hi Tom,

After inserting records to the database you have to populate the gridview & dropdown list again. Then it will select newly inserted records also.

if you post the code we can help you to figure out the exact problem.

nalla.

Hi nalla,

Thanks for your reply. I would like to automate the reposting of the data to the grid so that when a record is added in the grid it appears automatically. Is there an easy way to do this?

Thanks, Tom

   If you've written posting data to the grid part in the page load or calling posting data to the grid function in page load that's ok.

   but i remember i faced a same kind of problem with access database. I did a insert to a access table and after that selected all the records in that table, but it doesn't show newly inserted record. it only showed that record only if i execute the select command after few seconds inserting the record to the table.

   What i did is i included these query executions in a transaction control.then it was ok. so use a transaction control when inserting records.


nalaka hewage