C# 调用 MySQL 存储过程的代码
本文导语: 本文中的代码演示:在C# 程序中调用 MySQL 的存储过程,没有返回值,没有参数传递。 代码如下: MySqlConnection myConnection; myConnection = new MySqlConnection(); myConnection.ConnectionString = "database="+database+";server="+ server+";user...
本文中的代码演示:在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);
}