首页 > 编程 > .NET > 正文

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

2020-01-17 23:12:28
字体:
来源:转载
供稿:网友

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

Dim myConnectionString As String = "Database=" & myDatabase & _   " ;Data Source=" & myHost & _   ";User Id=" & myUserId & ";Password=" & myPasswordDim myConnection As New MySqlConnection(myConnectionString)Try  myConnection.Open()Catch MyException As MySqlException  Console.WriteLine("Connection error: MySQL code: " & MyException.Number & _           " " + MyException.Message)End TryTry  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

希望本文所述对大家的VB.NET程序设计有所帮助。

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表