如何在C#中使用MySQL运行触发器 [英] How to run trigger in c# with mysql

问题描述

hii ..

单击按钮后如何在C#中执行(mysql)触发?
需要一个简单的例子..

预先感谢，
swapnil

hii..

How to execute (mysql)trigger in c# at button click?
need simple example..

thanks in advance,
swapnil

推荐答案

您不会显式调用触发器...在表中插入，更新或删除行时会调用该触发器.

因此，调用SP进行数据库更改，并让它们触发触发器.

Hi,

You don''t call a trigger explicitly... it is called when you insert, update, or delete a row in Table.

So call a SP to do DB changes and let them fire a trigger.

请参阅此
http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html#c8545 [ ^ ]

Refer this
http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html#c8545[^]

此链接可能对您有帮助

http://net.tutsplus.com/tutorials/databases/introduction-to-mysql-triggers / [ ^ ]

http://www.boosten.org/2009/using-triggers-in-mysql/ [ ^ ]

http://www.roseindia.net/mysql/mysql5/triggers.shtml [ ^ ]

this links may help you

http://net.tutsplus.com/tutorials/databases/introduction-to-mysql-triggers/[^]

http://www.boosten.org/2009/using-triggers-in-mysql/[^]

http://www.roseindia.net/mysql/mysql5/triggers.shtml[^]

这篇关于如何在C#中使用MySQL运行触发器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！