SQL/MySQL/Procedure Function/CSharp

Calling a stored procedured in C#

   <source lang="sql">

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

}

       </source>
   
  

Get returning value from a stored procedure in C#

   <source lang="sql">

CallableStatement PreparedFunc = MyConnect.prepareCall("{ ? = call isodd( ? ) }"); PreparedFunc.registerOutParameter(1, Types.INTEGER); PreparedFunc.setInt(1, aNumber); PreparedFunc.execute(); if (PreparedFunc.getInt(1) == 1)

    System.out.println(aNumber + " is odd");

else

    System.out.println(aNumber + " is even");

       </source>