I develop intranet application using ASP.Net 2.0 with VB language.
I have some modules that necesarry send messages to users.
Currently, my Bulletin Board shows pop up windows if there are messages to users.
It reads SQL Server table every 5 minutes using Web Service.

For others modules (GA-Payment, User ID Maintain),
I have planned to use Net Send function that provides by SQL Server with activating Job Schedule.
But i hesitant, if it could decrase my SQL Server or my Server performance.

So, do you have experiences how to send message to users with ASP.Net ?

Thanks and Regards,

Kusno

I have been developing a similar solution, however, I'd like to know more about what your problem is specifically, so I can send you the code you need.





-Mobius

function CheckNewMessage()

{

objXML = new ActiveXObject("Microsoft.XMLDOM");

objXML.async = false;

var UserID= "<%= Session("UserID") %>";

strSql = "BMIWebService.asmx/GetTotalNewMessages?UserID=" + UserID;

objXML.load(strSql);

var total;

total = objXML.text;

if(total>0)

{

var w = 0, h = 0;

if (document.all || document.layers)

{

w = screen.availWidth;

h = screen.availHeight;

}

var popW = 550, popH = 350;

var leftc = (w - popW) / 2, topc = (h - popH) / 2;

window_bbs = window.open('Transactions/BBS/BrowseNewMessageBuletinBoard.aspx','window_bbs','scrollbars=yes,left=' + leftc + ', top=' + topc + ',width=550,height=350');

window_bbs.focus();

}

setTimeout("CheckNewMessage()",480000);

return true;

}

and this is webservice code :

<WebMethod()> Public Function GetTotalNewMessages(ByVal UserID As String) As Int16

Dim CnBBS As New SqlClient.SqlConnection

GetTotalNewMessages = 0

If GetCN(CnBBS) Then

Thanking for your anticipation