C#中调用MySQL存储过程的方法

本文实例讲述了c#中调用mysql存储过程的方法。分享给大家供大家参考。具体如下：

这段代码演示在 c# 程序中调用 mysql 的存储过程，没有返回值，没有参数传递。

mysqlconnection myconnection;
myconnection = new mysqlconnection();
myconnection.connectionstring = "database="+database+";server="+
  server+";user id="+user+";password="+password;
try {
  myconnection.open();
}
catch (mysqlexception myexception) {
  console.writeline("connection error: mysql code: "+
    myexception.number +" "+ 
    myexception.message);
}
try {
  mysqlcommand mycommand = new mysqlcommand(
  "call error_test_proc(1)",
    myconnection
  );
  mycommand.executenonquery();
}
catch (mysqlexception myexception) {
  console.writeline("stored procedure error: mysql code: " + 
      myexception.number + " " + 
      myexception.message);
}

希望本文所述对大家的c#程序设计有所帮助。