Re: HOWTO: display database without refresh web page to query data

Tech-Archive recommends: Fix windows errors by optimizing your registry

re:
> How about the database trigger?

How will the trigger know who to send the updated data to ?

re:
> The web page will be like a client and listen to the database changes.

I don't know how that could be done.




Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"SS" <ss@xxxxxxxxx> wrote in message
news:0A0A9AC1-105E-4262-88E7-EB0CC9226C89@xxxxxxxxxxxxxxxx
> Thanks for the reply.
> How about the database trigger?
> Can it trigger a web page to display when the database changes?
> The web page will be like a client and listen to the database changes.
> HOw can I do that?

> "Juan T. Llibre" wrote:
>> Osmosis ?
>>
>> ;-)
>>
>> Seriously, do you want to have a page display a change
>> in a database *when the database is updated* ?
>>
>> There's all kinds of techniques to do that, like a database-dependent
>> cache item, but it will be impossible to acquire new information from
>> the server if the client doesn't make a second trip to the server.
>>
>> So, you *have* to either refresh the page or redirect to a new page.
>>
>>
>>
>>
>> Juan T. Llibre
>> ASP.NET MVP
>> http://asp.net.do/foros/
>> Foros de ASP.NET en Español
>> Ven, y hablemos de ASP.NET...
>> ======================
>>
>> "SS" <ss@xxxxxxxxx> wrote in message
>> news:22788B3E-1763-465C-A099-43E5A0CA848F@xxxxxxxxxxxxxxxx
>> > Hi,
>> >
>> > I don't want to refresh a web page to query and display database.
>> > I want the page shows information immediately when database changes.
>> > What kind of technology or method would be able to perform this action?
>> >
>> > Sean
>>
>>
>>


.

Relevant Pages

  • Re: The quest for opensource database...
    ... > But isn't that supposedly the function of the database trigger - that is ... > can replace those stored procedures/trigger function in PHP or any ... > the flow/design of the application where the database programmer can ... There is nothing in a stored procedure or database trigger that I cannot ...
    (comp.lang.php)
  • Re: HOWTO: display database without refresh web page to query data
    ... How about the database trigger? ... Can it trigger a web page to display when the database changes? ... The web page will be like a client and listen to the database changes. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Unloading Table from Stored procedure called by Trigger
    ... i have to unload a database table while processing a stored procedure ... called by a database trigger. ... Is there an easier way then writing C-UDR code with database ...
    (comp.databases.informix)
  • Unloading Table from Stored procedure called by Trigger
    ... i have to unload a database table while processing a stored procedure ... called by a database trigger. ... Is there an easier way then writing C-UDR code with database ...
    (comp.databases.informix)
  • RE: Userform to add and update a table
    ... One of the most common scenarios in application development is to display ... the walkthrough illustrates many of the basic ... Access to a server with the Pubs SQL Server sample database. ... Creating the Windows Form. ...
    (microsoft.public.sqlserver.programming)