Is it possible to get messages back SSMS style in a C# winforms application?

See more:

C#

SQL-Server

SSMS

Hi All

I have an application that uses MS SQL and from time to time I need to alter tables, add columns, etc. Obviously this could be done using SSMS, but not all my clients have the ability to install and use that on their workstations (their IT departments restrict them) so I was wondering whether there was a way to create a basic one that I can use without the need to install SSMS?

I have tried the ".InfoMessage" event and I do not receive messages back, I tried the ".StatementCompleted" and that works fine if say I am updating a record. but I want to enter a command (or a series of commands) like

ALTER TABLE [dbo].[Batch] ADD [totalLoose] int

and receive back the message as I would in SSMS, either it finished successfully or failed.

Is this possible, as I have spent so much time searching and trying a few things and all have so far fallen well short?

thanks, in advance.

DT

What I have tried:

using (conn = new SqlConnection(ConnectionString))
{

    conn.FireInfoMessageEventOnUserErrors = true;
    conn.InfoMessage += OnInfoMessage;
    conn.Open();
    using (sc = new SqlCommand(sql, conn))
    {
        sc.StatementCompleted += OnStatementCompleted;
        sc.ExecuteNonQuery();
    }
    conn.Close();
    conn.InfoMessage -= OnInfoMessage;
    conn.FireInfoMessageEventOnUserErrors = false;
}

private void OnStatementCompleted(object sender, StatementCompletedEventArgs e)
{
    ResultTBC.Text += "\n" + "("+e.RecordCount + " row(s) affected)";
}

private void OnInfoMessage(object sender, SqlInfoMessageEventArgs e)
{
    ResultTBC.Text += "\n" + e.Message;
}