using System;
using System.Data;
using System.Data.SqlClient;

class StatementTest
{

    private static SqlConnection connection;
    private static SqlDataAdapter dataadapter;

    static void Main()
    {
        try
        {
            connection = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=test;Integrated Security=SSPI;");
            connection.Open();
        }
        catch (Exception err)
        {
            Console.Write("Error connect to DB: " + err.ToString());
        }

        try
        {
            dataadapter = new SqlDataAdapter("SELECT * FROM Table_1 WHERE id < 2", connection);

            if (dataadapter != null)
            {
                SqlCommand insCmd = dataadapter.InsertCommand;
                SqlCommand delCmd = dataadapter.DeleteCommand;
                SqlCommand updCmd = dataadapter.UpdateCommand;
                SqlCommand selCmd = dataadapter.SelectCommand;
                if (insCmd != null) insCmd.StatementCompleted += Command_StatementCompleted;
                if (delCmd != null) delCmd.StatementCompleted += Command_StatementCompleted;
                if (updCmd != null) updCmd.StatementCompleted += Command_StatementCompleted;
                if (selCmd != null) selCmd.StatementCompleted += Command_StatementCompleted;
            }

        }
        catch (Exception err)
        {
            Console.Write("Error in execute query");
        }

        Console.ReadLine();
    }


    static void Command_StatementCompleted(object sender, System.Data.StatementCompletedEventArgs e)
    {
        SqlCommand cmd = sender as SqlCommand;
        if (cmd != null)
        {
            object container = cmd.Container;
            if (container != null)
            {
                Console.WriteLine(string.Format("[Command_StatementCompleted]: Container's Type: {0};", container.GetType().ToString()));
            }
            Console.WriteLine("===============================================================");
            foreach (SqlParameter parm in cmd.Parameters)
            {
                Console.WriteLine(string.Format("[Command_StatementCompleted]:"
                + " ParameterName: {0}; "
                + " Size: {1}; "
                + " Value: {2}; "
                + " SourceColumn: {3}; "
                + " IsNullable: {4}; "
                + " Direction: {5}; "
                + " DbType: {6}; "
                + " SqlDbType: {7}; "
                , parm.ParameterName
                , parm.Size
                , parm.Value
                , parm.SourceColumn
                , parm.IsNullable
                , parm.Direction
                , parm.DbType
                , parm.SqlDbType
                ));
            }
            Console.WriteLine(string.Format("[Command_StatementCompleted]: Text: {0}; RecordCount: {1}", cmd.CommandText, e.RecordCount));
        }
    }
}