- 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);
- }
- //该片段来自于http://www.codesnippet.cn/detail/2003201511921.html
来源: http://www.codesnippet.cn/detail/2003201511921.html