Mega Code Archive

 

Categories / MySQL Tutorial / Procedure Function

 

Calling a stored procedured in C#

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