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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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