C#

namespace WindowsService1
{
    public partial class ServiceName : ServiceBase
    {
        public ServiceName()
        {
            InitializeComponent();
            string sSource;
            string sLog;
            string sEvent;

            sSource = "MyServiceName";
            sLog = "Application";
            sEvent = "MyServiceName starting";

            if (!EventLog.SourceExists(sSource))
                EventLog.CreateEventSource(sSource, sLog);

            EventLog.WriteEntry(sSource, sEvent);// this works
          
EventLog sysLog = new EventLog("System", ".");
sysLog.EntryWritten += new EntryWrittenEventHandler(OnEntryWritten);
EventLog.WriteEntry(sSource, "logger started");// this works too

Console.WriteLine("Logger started");// nothing writes to console
       }       

        public void OnEntryWritten(object source, EntryWrittenEventArgs e)
        {
string sSource;
            string sLog;
            sSource = "MyServiceName";
            sLog = "Application";
            if (!EventLog.SourceExists(sSource))
                EventLog.CreateEventSource(sSource, sLog);
           EventLog.WriteEntry(sSource, "sqllogger started");//this  doesn't work

SqlConnection Conn = new SqlConnection("User id = x; password = y; server=z;database=dbname;connection timeout=30");
            SqlCommand ins = new SqlCommand("INSERT INTO dbo.TableName(TimeWritten, Source)VALUES (@TimeWritten, @Source)", Conn);
            ins.Parameters.Add("@TimeWritten", SqlDbType.DateTime);
            ins.Parameters.Add("@Source", SqlDbType.NVarChar, 20);

            ins.Parameters["@TimeWritten"].Value = e.Entry.TimeWritten;
            ins.Parameters["@Source"].Value = e.Entry.Source;

            TableName.Open();
            ins.ExecuteNonQuery();
            TableName.Close();// nothing written to db
        }

private uint rgb(byte r, byte g, byte b)
{
    return ((uint)((r|((uint)(g)<<8))|(((uint)b)<<16)));
}

private uint rgb(byte r, byte g, byte b)
{
    return ((uint)((r|((ushort)(g)<<8))|(((uint)b)<<16)));
}