How to Update Stock available in asp.net from an Oracle Database?

[Krutz]

I m working on A Ware house management Software.
I have used oracle in back end. I have goodsmaster table, sales return table, sales table, invoice table,etc
So i have to update qty on stock when i enter any entry in my sales return page of asp.net from goods master table..
can anyone help me with that??

[jhardman]

accidentally posted in the ASP classic forum instead of the ASP.NET forum. I'll move it over for you.

Jared

[Frinavale]

From what I understand is that you have 2 pages.
One for selling things.
One for viewing inventory.

You want to keep the "viewing inventory" page as up to date as possible.
This should be done automatically (so long as you aren't using any caching mechanisms) for you.

The thing is that the content displayed in the browser will only be refreshed when the user causes the "viewining inventory" page to post back to the server....

So I recommend using an ASP.NET Timer Control....it posts back to the server after some time interval has passed.

-Frinny