Calling a stored procedured in C# : CSharp « Procedure Function « SQL / MySQL

1. SQL / MySQL
2. Procedure Function
3. CSharp

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

        

Related examples in the same category