Data change event

Let's say I want to have a Web page that will be showing live data change in
a SQL table? Is it possible to have on SQL side some kind of listener that
will propogate changes to the Web page?
ThanksMarkgoldin wrote:
> Let's say I want to have a Web page that will be showing live data change
in
> a SQL table? Is it possible to have on SQL side some kind of listener that
> will propogate changes to the Web page?
I've always done the opposite, have the Web page query the database
whenever it needs to be refreshed. Even if you build a component with
ActiveX or Java it would still require the client to continually connect
to the data source to determine if there were changes. If you aren't
particular about how it works then just have the Web page refresh itself
on a regular basis, it's alot easier.
gorf|||If you are using SQL Server 2005, then lookup Query Notification in BOL. If
you are using an earlier version, then, as far as I know, you have to have
your application poll the database to look for changes.
"Markgoldin" <Markgoldin@.discussions.microsoft.com> wrote in message
news:D9064F07-0DB3-4687-B562-DF800DD8DA64@.microsoft.com...
> Let's say I want to have a Web page that will be showing live data change
> in
> a SQL table? Is it possible to have on SQL side some kind of listener that
> will propogate changes to the Web page?
> Thanks

Data access, DataReaders, DataSets, web pages and controls

I have a question about loading data on the page lode event. The question is more conceptual then how to.

Using C#, I would like to make a call to a SQL 2000 Server, with the use of a stored procedure return one row with eleven fields. Then use the data to fill five different controls. There is no manipulation of the data it is just presented as information. With a DataReader and the GetValues method using the resultant array I can fill the controls (or can I), or with a DataSet and the Load method do the same thing. Now this code can be placed in the code behind page or it can be implemented in a class. This is the only page that uses this combination of fields and controls; however I would think a more generic call to the data could be made then pick and chose the fields as needed. What process makes the most sense? Is what I just described even possible (as yet I haven't tried it)?

As always thanks in advance for any thoughts, comments, and suggestions.

hi Darel

i think u can create a function in a class and call that function in code behind. that function will return a dataset. u cannot use datareader as u have to fill more than one control in a function call.

CustomQueryDesigner Problem: React to "Resize" Event of QueryDesigner Window

Hello everybody!

I am currently developing a CustomQueryDesigner which is based on a Windows.Form that I have already developed.

Currently the QueryDesigner Class contains two UserControls: the ToolBar and the class that wrapps my own QueryDesigner.

So what I want to do now, is to resize my Windows.Form which is encapsulated in the second UserControl whenever the size of the window, that contains these two UserControls, is modified.

I already tried to use the "Parent" property and the "FindForm()" method but both just return "null".

--> I do not unterstand how I can access these informations!

Please help me out!

help!!!!