如何通过C＃检测SQL中的行插入 [英] How do I detect a row insertion in SQL via C#

问题描述

所以我有一个连接到C＃Windows窗体的SQL服务器，C＃代码从数据库表中提取数据非常好



我要添加的是一个允许我从EMPTY表开始然后继续检查它直到插入一行的方法，但我似乎无法弄清楚



任何人都有任何想法？

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?

推荐答案

尝试并通过SQL Serer通知服务 - http://technet.microsoft.com/en-us/library/ms172483%28v=sql.90%29.aspx [ ^ ]。

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

您可能希望使用SQL Server CLR集成。请参阅 this [ ^ ]链接。



/ ravi

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

/ravi

这篇关于如何通过C＃检测SQL中的行插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！