110,571
社区成员
发帖
与我相关
我的任务
分享
Private Shared SQLCMD As SqlCommand
Private Shared SQLConn As SqlConnection
Private Shared SQLMessage As String = String.Empty
Public Shared Sub OpenConnection(ByRef conn As SqlConnection)
Try
If (conn.State = ConnectionState.Open) Then
Return
Else
conn.Open()
SQLConn = conn
'SQLConn.InfoMessage += New SqlInfoMessageEventHandler(conn_InfoMessage)
AddHandler SQLConn.InfoMessage, New SqlInfoMessageEventHandler(AddressOf conn_InfoMessage)
SQLCMD = conn.CreateCommand()
SQLCMD.CommandTimeout = 1000
End If
Catch ex As Exception
Throw ex
End Try
End Sub
Private Shared Sub conn_InfoMessage(ByVal sender As Object, ByVal e As SqlInfoMessageEventArgs)
SQLMessage = e.Message
End Sub
使用找个SQLConn连接执行完sql语句后直接取SQLMessage就可以了:
SQLCMD.CommandText="print 'TestMessage'"
SQLCMD.ExecuteNonQuery()
Messagebox.show(SQLMessage)
var conn = new SqlConnection("");
conn.InfoMessage += new SqlInfoMessageEventHandler(conn_InfoMessage);
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "Print 1";
cmd.ExecuteNonQuery();
}
void conn_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
MessageBox.Show(e.Message);
}