如何在C#中使用MySQL运行触发器

本文介绍了如何在C#中使用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.

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

此链接可能对您有帮助 net.tutsplus/tutorials/databases/introduction-to-mysql-triggers / [ ^ ] www.boosten/2009/using-triggers-in-mysql/ [ ^ ] www.roseindia/mysql/mysql5/triggers.shtml [ ^ ] this links may help you net.tutsplus/tutorials/databases/introduction-to-mysql-triggers/[^] www.boosten/2009/using-triggers-in-mysql/[^] www.roseindia/mysql/mysql5/triggers.shtml[^]