Write EventLogs with C# class

Here is the orijinal article.  http://www.kad1r.com/article.aspx?articleId=306&Category=ASP.Net&title=Write-EventLog-with-ASP.Net

using System;
using System.Diagnostics;

namespace smsXmlWS
{
    public class LogManager
    {
        // EventLogEntryType.Error
        // EventLogEntryType.FailureAudit
        // EventLogEntryType.Information
        // EventLogEntryType.SuccessAudit
        // EventLogEntryType.Warning
       
        public LogManager()
        { }

        public static void WriteLog(string message, EventLogEntryType eventType)
        {
            if (!System.Diagnostics.EventLog.SourceExists("LOGNAME"))
            {
                EventSourceCreationData data = new EventSourceCreationData("LOGNAME", "LOGNAME");
                System.Diagnostics.EventLog.CreateEventSource(data);
            }

            if (eLog == null)
                eLog = new System.Diagnostics.EventLog();

            eLog.Source = "LOGNAME";
            eLog.WriteEntry(message + " DATE : " + System.DateTime.Now.ToString(), eventType);
        }
        private static System.Diagnostics.EventLog eLog = null;
    }
}

Combine rows into one row in mssql

Combine lines instead: As you know, we obtained data from the database when we receive lines. But sometimes we need them in a row. We do this, view, or just use a temporary table. I use a temporary table in it. Here is an easy transition.

CREATE TABLE #Temp([Numbers] varchar(20))
INSERT INTO #Temp VALUES('asp');
INSERT INTO #Temp VALUES('.net');
INSERT INTO #Temp VALUES('database');
INSERT INTO #Temp VALUES('views');
INSERT INTO #Temp VALUES('temp');
DECLARE @str VARCHAR(200)
SELECT @str = COALESCE(@str + '-', '') + [Numbers]
FROM #Temp
Print @str

Here is the output: asp-.net-database-views-temp

Orijinal article for combine rows in one table in mssql