How do I detect a row insertion in SQL via C#

Question

0.00/5 (No votes)

See more:

So I have an SQL server connected to a C# Windows Form, the C# code extracts data from the database table perfectly fine

What I want to add is a method that allowws me to start with an EMPTY table and then keep checking it until a row has been inserted in it, but I caan't seem to figure out how

Anyone has any ideas?

Posted 25-Jan-14 9:37am

Member 10549267

Add a Solution

Comments

Karthik_Mahalingam 25-Jan-14 15:44pm

Can u pls add more information..
what you have tried ??

Shambhoo kumar 25-Jan-14 23:55pm

declare a int type variable in code side and write execute command like this

int result=cmd.ExecutenonQuery;

if(result>0)
{
//inserted
}
else
{
//not inserted.
}

2 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)

Abhinav S · Answer 1 · 2014-01-25T16:39:00

Solution 2

Try and go through SQL Serer notification services - http://technet.microsoft.com/en-us/library/ms172483%28v=sql.90%29.aspx[^].

Posted 25-Jan-14 16:39pm

Abhinav S

v2

Comments

Ron Beyer 25-Jan-14 22:44pm

+5, notifications are good for smaller systems but they don't scale well. I've been trying to find the point at which they become less effective. Nobody says at what scale they deteriorate they just say its not for "larger" scale systems.

Abhinav S 25-Jan-14 23:06pm

Thank you.

Ravi Bhavnani · Answer 2 · 2014-01-25T13:49:00

Solution 1

You probably want to use SQL Server CLR integration. See this[^] link.

/ravi

Posted 25-Jan-14 13:49pm

Ravi Bhavnani