C#

static void displayinarray()
{
    int rows = 0;
    int averagewins;
    //in global     static OleDbConnection connection;
    //in main       connection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\\connected\\users.accdb");
    try
    {
        OleDbCommand command = new OleDbCommand("select * from users", connection);
        connection.Open();
        OleDbDataReader reader = command.ExecuteReader();
        while (reader.Read()) {rows++;};
        string[,] results = new string[6,rows];
        for (int loop = 0; loop <= rows; loop++)
        {
            results[0,loop] = reader.GetString(0);
            results[1,loop] = reader.GetString(1);
            results[2,loop] = reader.GetString(2);
            results[3,loop] = reader.GetInt32(3).ToString();
            results[4,loop] = reader.GetInt32(4).ToString();
            averagewins = (reader.GetInt32(4) / reader.GetInt32(3))*100;
            results[5,loop] = Convert.ToString(averagewins);
        }

        Console.Clear();
        Console.WriteLine("{0}", rows);
        Console.WriteLine("  ┌──────────────┬──────────────┬──────────────┬────────┬────────┬─────────┐");
        Console.WriteLine("  │ username     │ name         │ surname      │ played │ won    │ % won   │");
        Console.WriteLine("  ├──────────────┼──────────────┼──────────────┼────────┼────────┼─────────┤");

            for (int loop = 0; loop <= rows ; loop++)
        {
            Console.SetCursorPosition(2, loop + 4);
            Console.WriteLine("│ {0} ", results[0,loop]);
            Console.SetCursorPosition(17, loop + 4);
            Console.WriteLine("│ {0} ", results[1,loop]);
            Console.SetCursorPosition(32, loop + 4);
            Console.WriteLine("│ {0} ", results[2,loop]);
            Console.SetCursorPosition(47, loop + 4);
            Console.WriteLine("│ {0} ", results[3,loop]);
            Console.SetCursorPosition(56, loop + 4);
            Console.WriteLine("│ {0} ", results[4,loop]);
            Console.SetCursorPosition(65, loop + 4);
            Console.WriteLine("│ {0} ", results[5,loop]);
            Console.SetCursorPosition(75, loop + 4);
            Console.WriteLine("│");
        }
        Console.WriteLine("  └──────────────┴──────────────┴──────────────┴────────┴────────┴─────────┘");

        reader.Close();
        connection.Close();
    }
    catch (OleDbException e)
    {
        Console.WriteLine("error: {0}", e.Errors[0].Message);
    }
    Console.ReadLine();
}}

void OnDataChange(object sender, SqlNotificationEventArgs e)
        {
            BBALogger.Write("PartIndexer Service OnDataChange called start", BBALogger.MsgType.Info);

<pre>
        if (e.Source == SqlNotificationSource.Timeout)
        {
            BBALogger.Write("PartIndexer Service SqlNotificationSource.Timeout error", BBALogger.MsgType.Error);
            Environment.Exit(1);
        }
        else if (e.Source != SqlNotificationSource.Data)
        {
            BBALogger.Write("PartIndexer Service SqlNotificationSource.Data", BBALogger.MsgType.Error);
            Environment.Exit(1);
        }
        else if (e.Type == SqlNotificationType.Change)
        {
            BBALogger.Write("PartIndexer Service Data changed detected", BBALogger.MsgType.Info);
        }
        else
        {
            BBALogger.Write(string.Format("Ignored change notification {0}/{1} ({2})", e.Type, e.Info, e.Source), BBALogger.MsgType.Warnings);
        }

        CallWebService();
        //((SqlDependency)sender).OnChange -= OnDataChange;
        //RegisterNotification();
    }</pre>

void OnDataChange(object sender, SqlNotificationEventArgs e)
{
    BBALogger.Write("PartIndexer Service OnDataChange called start", BBALogger.MsgType.Info);

    if (e.Source == SqlNotificationSource.Timeout)
    {
    BBALogger.Write("PartIndexer Service SqlNotificationSource.Timeout error", BBALogger.MsgType.Error);
    Environment.Exit(1);
    }
    else if (e.Source != SqlNotificationSource.Data)
    {
    BBALogger.Write("PartIndexer Service SqlNotificationSource.Data", BBALogger.MsgType.Error);
    Environment.Exit(1);
    }
    else if (e.Type == SqlNotificationType.Change)
    {
    BBALogger.Write("PartIndexer Service Data changed detected", BBALogger.MsgType.Info);
    }
    else
    {
    BBALogger.Write(string.Format("Ignored change notification {0}/{1} ({2})", e.Type, e.Info, e.Source), BBALogger.MsgType.Warnings);
    }

    CallWebService();
    //((SqlDependency)sender).OnChange -= OnDataChange;
    //RegisterNotification();
}

private void RegisterNotification()
    {
        string tmpdata = "";
        BBALogger.Write("PartIndexer Service RegisterNotification called start", BBALogger.MsgType.Info);

        System.Data.SqlClient.SqlDependency.Stop(connectionString);
        System.Data.SqlClient.SqlDependency.Start(connectionString);

        try
        {
        using (SqlConnection conn = new SqlConnection(connectionString))
        {
            conn.Open();
            SqlCommand cmd = conn.CreateCommand();
            cmd.CommandText = "SELECT ActivityDate FROM [dbo].tablename";
            dep = new SqlDependency(cmd);
            dep.OnChange += new OnChangeEventHandler(OnDataChange);
            SqlDataReader dr = cmd.ExecuteReader();
            {
            if (dr.HasRows)
            {
                dr.Read();
                tmpdata = dr[0].ToString();
            }
            }
            dr.Dispose();
            cmd.Dispose();
        }
        }
        catch (Exception ex)
        {
        BBALogger.Write("PartIndexer Service RegisterNotification Error "+ex.Message.ToString(), BBALogger.MsgType.Error);
        }
        finally
        {
        BBALogger.Write("PartIndexer Service RegisterNotification called end", BBALogger.MsgType.Info);

        }

}

public partial class PartIndexer : ServiceBase
{
    static string connectionString = "server=xxx;uid=xxx;password=xxx;database=xxx;Pooling=true;Connect Timeout=20;";
    SqlDependency dep;

<pre>
public PartIndexer()
{
    InitializeComponent();
}

private string GetLoggedInUser()
{
    string userName = "";
    if (System.Security.Principal.WindowsIdentity.GetCurrent() != null)
    {
        userName = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
    }
    return userName;
}

#region OnStart
protected override void OnStart(string[] args)
{
    BBALogger.Write("PartIndexer Service OnStart called start", BBALogger.MsgType.Info);
    RegisterNotification();
    MailSend(); // notification mail send
    BBALogger.Write("PartIndexer Service OnStart called end, logged in user " + GetLoggedInUser(), BBALogger.MsgType.Info);
}
#endregion

#region RegisterNotification
/// <summary>
/// RegisterNotification
/// this is main routine which will monitor data change in ContentChangeLog table
/// </summary>
private void RegisterNotification()
{
    string tmpdata = "";
    BBALogger.Write("PartIndexer Service RegisterNotification called start", BBALogger.MsgType.Info);

    System.Data.SqlClient.SqlDependency.Stop(connectionString);
    System.Data.SqlClient.SqlDependency.Start(connectionString);

    try
    {
        using (SqlConnection conn = new SqlConnection(connectionString))
        {
            conn.Open();
            SqlCommand cmd = conn.CreateCommand();
            cmd.CommandText = "SELECT TestTable FROM [dbo].ContentChangeLog";
            dep = new SqlDependency(cmd);
            dep.OnChange += new OnChangeEventHandler(OnDataChange);
            SqlDataReader dr = cmd.ExecuteReader();
            {
                if (dr.HasRows)
                {
                    dr.Read();
                    tmpdata = dr[0].ToString();
                }
            }
            dr.Dispose();
            cmd.Dispose();
        }
    }
    catch (Exception ex)
    {
        BBALogger.Write("PartIndexer Service RegisterNotification Error "+ex.Message.ToString(), BBALogger.MsgType.Error);
    }
    finally
    {
        BBALogger.Write("PartIndexer Service RegisterNotification called end", BBALogger.MsgType.Info);

    }

}
#endregion

#region OnDataChange
/// <summary>
/// OnDataChange
/// OnDataChange will fire when after data change found in ContentChangeLog table
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void OnDataChange(object sender, SqlNotificationEventArgs e)
{
    ((SqlDependency)sender).OnChange -= OnDataChange;

    BBALogger.Write("PartIndexer Service RegisterNotification called end", BBALogger.MsgType.Info);

    if (e.Source == SqlNotificationSource.Timeout)
    {
MailSend(); // notification mail send
BBALogger.Write("PartIndexer Service SqlNotificationSource.Timeout error", BBALogger.MsgType.Error);

        Environment.Exit(1);
    }
    else if (e.Source != SqlNotificationSource.Data)
    {
    MailSend(); // notification mail send
        BBALogger.Write("PartIndexer Service SqlNotificationSource.Data", BBALogger.MsgType.Error);

        Environment.Exit(1);
    }
    else if (e.Type == SqlNotificationType.Change)
    {
        StartIndex();
        BBALogger.Write("PartIndexer Service Data changed", BBALogger.MsgType.Info);
    }
    else
    {
        BBALogger.Write(string.Format("Ignored change notification {0}/{1} ({2})", e.Type, e.Info, e.Source), BBALogger.MsgType.Warnings);
    }

    RegisterNotification();
}
 #endregion

#region StartIndex
/// <summary>
/// StartIndex
/// this routine will call web service in bba reman website which will invoke routine to re-index data
/// </summary>
void StartIndex()
{
    // calling web service if change is notified

}
#endregion

#region MailSend
/// <summary>
/// MailNotify
/// fire mail when apps start & exit
/// </summary>