Refreshing a table

[fintan]

Hi I was wondering how to refresh a table after an update action has occurred

[wardbekker]

fintan,

I'm guessing you mean refreshing a ASP.NET datagrid or datalist after an upgrade. Just reload the dataset and bind it to the datagrid or datalist.

[fintan]

No I'm just poor old asp & I just want to reload/refresh a table after its updated.
Thanks

[chris_f]

The only way of doing it is to refresh the page.

Chris.

[fintan]

Is there no way of reloading a single table? I know that "webassist" do something similar with drop down menus.

[wardbekker]

fintan,

You can use frames. Besides the page with the table, you need a tiny invisible frame (1 x 1 pix for example). You can let that frame load the needed data and with javascript you can transfer it to the 'table'-frame and rebuild it with DHTML.

[fintan]

I'm just going to explain my situation. I've built this system for a visually impaired person and its his job to update the phone dir. Now the problem with using frames is the screen reader doesn't like them very much.

Wardbekker could you show me what you mean then I might be able to hide the frame from the screen reader.

[wardbekker]

fintan,

Why not just refresh the page then? You could use a key combination for a submit.

[GaryK]

Can you put the table in an IFrame and just refresh the IFrame page? My experience has shown that screen readers can handle this with no major problems. I am a volunteer computer teacher in an old age home so we use lots of screen readers and magnifiers. :)

[Edited for spelling]

[fintan]

I can't put a refresh on the page because the search engine and results page r the same. If the user navagates half way down the page & it refreshes. The screen reader jumps to the top of the page.

I'll have to see how the screen reader interpurts the iframe before I use it. I was hopeing I could just reload the table with asp.

"key combination for a submit" What do you mean? What like "Alt+1" its already done.

[txbakers]

Why not use a response.redirect to the same page after the DB is altered. That will force a refresh with the new data.

[fintan]

Could you elaberate txbakers please?
Thanks

[txbakers]

In your ASP code you'll have something like this:

sql = "update table set..."

cmd.execute(sql)

after all that, put this.

response.redirect(thesamepage.asp)

which will force a reload of the page.

Early netscape browsers don't like this though.

[fintan]

Thanks it work.

[Enigma]

Wouldn't
server.execute(thesamepage.asp)

be better than
response.redirect(thesamepage.asp)?