在 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); 

原创文章，作者：Maggie-Hunter，如若转载，请注明出处：https://blog.ytso.com/6663.html