| 注册
请输入搜索内容

热门搜索

Java Linux MySQL PHP JavaScript Hibernate jQuery Nginx
dfeeee
10年前发布

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