How to push data from server?

pandiarajan rajan

Hi,
I am developing a web application which uses the timer to check the update in the database.But now i want to update the page when the data get updated in the database without the timer is that possible?

Please help me to get out of this problem.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Cyber Bhai17y ago
Can you please provide the code snippet for displaying the value of "strMessge" ? I have put the trigger as below. " create trigger trgInsTabTestPushData on TabTestPushData for insert AS begin declare @vName nvarchar(Max), @msg nvarchar(max) select @vname=vname from inserted exec spTestPushData @vname , @msg OUTPUT end "
0
Roei Bar17y ago
well it is possible by 2 ways:

1. an activex that holds a connection to the server
2. TCP Session on Client Side, this 1 brakes apart the option for real HTTP services

another way is something called COMET, its a Framwork for Push Data

here is a sample project

http://www.codeproject.com/KB/aspnet/CometMultiClient.aspx

and

http://www.stream-hub.com/
0

Kirtan Patel17y ago

Here is Example of it Got From google take a Look At it

using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Data.SqlTypes;
using System.Data.SqlClient;
using Microsoft.SqlServer.Server;

namespace ManagedCodeAndSQLServer
{
    public class BaseFunctionClass
    {
        #region "Default Constructor"
        public BaseFunctionClass()
        { 
                   
        }
        #endregion

        #region "Welcome Function"
        /// 
        /// This function will be called from the SQL Stored Procedure.
        /// 
        /// Name
        /// Welcome Message
        [SqlProcedure]
        public static void GetMessage(SqlString strName, out SqlString  
        strMessge)
        {
          strMessge = "Welcome," + strName + ", " + "your code is getting
          executed under CLR !";
        }

        #endregion
    }
}

Build the class and you will get a dll file.

Now you need to enable the SQL Server to work with External Objects and thus you will need to fire the below command..

ALTER DATABASE TestingCLR SET TRUSTWORTHY ON
GO

Now Register ManagedCodeAndSQLServer.dll under that using the following code:

CREATE ASSEMBLY ManagedCodeAndSQLServer
AUTHORIZATION dbo
FROM 'E:\Important\SQL\ManagedCodeAndSQLServer\ManagedCodeAndSQLServer\bin\Debug\ManagedCodeAndSQLServer.dll'
WITH PERMISSION_SET = UNSAFE
GO

Create a procedure which can be called from the Trigger...

CREATE PROCEDURE sp_managed_example
@name nvarchar(200), @msg nvarchar(MAX)OUTPUT
AS EXTERNAL NAME ManagedCodeAndSQLServer.[ManagedCodeAndSQLServer.BaseFunctionClass].GetMessage
GO

Done. Now you just need to invoke the procedure from your trigger and it most certainly should work :)