VB.NET调用MySQL存储过程并获得返回值的方法_ASP.NET教程

VB.NET调用MySQL存储过程并获得返回值的方法

2019-12-18 16:18鉴客 ASP.NET教程

这篇文章主要介绍了VB.NET调用MySQL存储过程并获得返回值的方法,涉及基于VB.NET操作MySQL数据库的相关技巧,具有一定参考借鉴价值,需要的朋友可以参考下

本文实例讲述了VB.NET调用MySQL存储过程并获得返回值的方法。分享给大家供大家参考。具体实现方法如下：

				?

									Dim myConnectionString As String = "Database=" & myDatabase & _

									   " ;Data Source=" & myHost & _

									   ";User Id=" & myUserId & ";Password=" & myPassword

									Dim myConnection As New MySqlConnection(myConnectionString)

									Try

									  myConnection.Open()

									Catch MyException As MySqlException

									  Console.WriteLine("Connection error: MySQL code: " & MyException.Number & _

									           " " + MyException.Message)

									End Try

									Try

									  Dim myCommand As New MySqlCommand("call error_test_proc(1)")

									  myCommand.Connection = myConnection

									  myCommand.ExecuteNonQuery()

									Catch MyException As MySqlException

									  Console.WriteLine("Stored procedure error: MySQL code: " & _

									      MyException.Number & " " & _

									      MyException.Message)

									End Try