How to sent a notification to user when a new item added in to the database.

Question

0.00/5 (No votes)

See more:

I have an application for chatting when the user add a word in the database a notification should come to me that a new item is added in the database and it should happen at the sametime when someone have added anything to a particular database. It should be by using c# and .net .

Actually what i need is i need a technique to execute to find the new item which added in the database and it should occur at the same time when someone added an item in to my database.

My Table will be like this

From | To | Text
xx | yy | hellow
zz | uu | Hai

if xx added a text hellow to yy

yy should get the text which xx have added to the database at the same time xx adding.

Posted 25-Oct-13 2:59am

udayams

Updated 25-Oct-13 5:28am

v4

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 25-Oct-13 11:40am

When the record is added to the Database, just add notification codes after that. What is the problem?

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

codestar007 · Answer 1 · 2013-10-25T03:02:00

Solution 1

You can use this after your insertion code:

C#

ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Inserted Successfully')", true);

Posted 25-Oct-13 3:02am

codestar007

Comments

Tom Marvolo Riddle 25-Oct-13 9:08am

@codestar007:I guess he is searching for something like trigger

S. M. Ahasan Habib · Answer 2 · 2013-10-25T06:41:00

You will create trigger on your table. When any new record is inserted to that table then the trigger is fired automatically and inside that trigger you can get the value which is inserted and do anything with this value.
Please read the following trigger related article
Triggers -- Sql Server[^]

**Zoltán Zörgő** · Answer 3 · 2013-10-25T08:57:00

As you tagged your question with Javascrip, I assume you want to make a web application. Well, part of it will depend on the framework you use (WebForms, Web Pages, MVC...), but the key point is how you are able to notify a state-less client (a html/javascript application part running in a browser is such a client).
If you can ensure, that all client run HTML5 (Websockets) enabled browser, you can take this approach: HTML5 Real-Time Chat with Websockets, jQuery, and Spike-Engine[^]. If not, you have to consider some automatic polling from client side (this won't be instantaneous, but can be quite quick - with regards to your network bottlenecks). This polling can be simply done with an ajax call.
Here you have a library that can handle this transparently from your application's point of view: SignalR[^]

How to sent a notification to user when a new item added in to the database.

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

How to sent a notification to user when a new item added in to the database.

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us