Calling a stored procedured in C#

Submitted by:Jhon Jhon

Date added:01 January, 2014

Category:C#

Example shown here how to call a stored procedured in C#

Tags: stored procedure , call procedure

Code Snippet:

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

Comments