Q:

.NET How to get Sql response to string?

After inserting something into the DB I would like to get the server's response.
For example "x rows effected" or other messages, and put them into a string variable.
How do I implement this in code? C# or VB - doesn't matter to me.
I couldn't find anything specific on this, but I am a n00b @ programming.
Thank you kindly.Could you kindly provide an example for me? Here is my code: 
    Private Function insertScr(ByVal byte2insert As Byte()) As Boolean

    Dim _con As SqlConnection
    Dim queryStmt As String
    Dim _cmd As SqlCommand
    Dim param As SqlParameter

    Try

        _con = New SqlConnection(My.Settings.DBconnStr)
        queryStmt = "update ErrorLog set screen =  @Content where(ErrorLogID = 2)"
        _cmd = New SqlCommand(queryStmt, _con)
        param = _cmd.Parameters.Add("@Content", SqlDbType.VarBinary)

        param.Value = byte2insert

        _con.Open()
        _cmd.ExecuteNonQuery()
        _con.Close()

        Return True

    Catch ex As Exception

        Return False

    End Try

End Function  

A:

Assuming SQL Server, the SqlConnection object has an InfoMessage event that is raised for each of these sorts of messages (it also has a mode that can be enabled so that error messages are delivered via the same event, see FireInfoMessageEventOnUserErrors)
You would access the text of these messages by extracting the Message property from the second argument passed to your event handler.

Something like:
    ...
    _con = New SqlConnection(My.Settings.DBconnStr)
    AddHandler _con.InfoMessage,Sub(sender,e)
                                    MessageBox.Show(e.Message)
                                End Sub
    queryStmt = "update ErrorLog set screen =  @Content where(ErrorLogID = 2)"
    ...

