в 13:44, 26 мая 2010

2010-05-26T13:44:56Z

Admin: 1 версия

2010-05-26T09:53:41Z

1 версия

Новая страница

== 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>

← Предыдущая	Версия 13:44, 26 мая 2010
(нет различий)

MySQL Tutorial/Procedure Function/CSharp - История изменений

в 13:44, 26 мая 2010

Admin: 1 версия