我有一个带有2个参数的存储过程,返回结果是一条PRINT消息。我可以传入参数并运行存储过程,但是我不知道如何返回结果。
Imports System.Data.Sql
Imports System.Data.SqlClient
Public Class Form1
Dim SQL As New SQLControl
Dim cmd As New SqlCommand
Private Sub RunSql_Click(sender As System.Object, e As System.EventArgs) Handles RunSql.Click
Try
If SQL.HasConnection = True Then
SQL.SQLCon.Open()
cmd.Connection = SQL.SQLCon
cmd.CommandText = "Exec stored procedure " & param1.Text & "," & param2.Text
cmd.ExecuteNonQuery()
End If
Catch ex As Exception
MsgBox(ex.Message)
Finally
SQL.SQLCon.Close()
End Try
End Sub
End Class提前谢谢。
发布于 2014-08-21 23:04:42
可以使用InfoMessage对象的SqlConnection事件从Server数据源检索警告和信息性消息。
这在一个类似的问题中得到了回答:Get the value of print statement of sql server in vb.net by using oledb
发布于 2014-08-21 23:53:43
谢谢!我用你的链接做了更多的调查,我让它起作用了。
如果其他人需要一个例子,下面的代码会被修改。
Imports System.Data.Sql
Imports System.Data.SqlClient
Public Class Form1
Dim SQL As New SQLControl
Dim cmd As New SqlCommand
Private Sub RunSql_Click(sender As System.Object, e As System.EventArgs) Handles RunSql.Click
Try
If SQL.HasConnection = True Then
SQL.SQLCon.Open()
cmd.Connection = SQL.SQLCon
cmd.CommandText = "Exec stored procedure " & param1.Text & "," & param2.Text
cmd.ExecuteNonQuery()
AddHandler SQL.SQLCon.InfoMessage, New SqlInfoMessageEventHandler(AddressOf OnInfoMessage)
End If
Catch ex As Exception
MsgBox(ex.Message)
Finally
SQL.SQLCon.Close()
End Try
End Sub
Private Shared Sub OnInfoMessage(sender As Object, args As SqlInfoMessageEventArgs)
Dim err As SqlError
For Each err In args.Errors
MsgBox(err.Message)
Next
End Sub
End Class再次感谢刘易斯
https://stackoverflow.com/questions/25437207
复制相似问题