Thursday, April 3, 2014

Get Date from week number

1. Function is created to get date from week number and day of the week



static DateTime GetDateFrmWkNumberAndDayOfWk(int weekNumber, int dayOfWeek)
    {
        DateTime jan1 = new DateTime(DateTime.Now.Year, 1, 1);
        int daysOffset = DayOfWeek.Monday - jan1.DayOfWeek;

        DateTime firstMonday = jan1.AddDays(daysOffset);

        var cal = CultureInfo.CurrentCulture.Calendar;
        int firstWeek = cal.GetWeekOfYear(jan1, CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday);

        var weekNum = weekNumber;
        if (firstWeek <= 1)
        {
            weekNum -= 1;
        }

        var result = firstMonday.AddDays(weekNum * 7 + dayOfWeek - 1);
        return result;
    }


2. pass week number and day of week to get date



DateTime theDate = GetDateFrmWkNumberAndDayOfWk(6, 1);


Friday, March 21, 2014

Convert Datatable to html table

1. pass datatable as parameter to function below it generates html table

public static string ConvertDataTableToHTML(DataTable dt)
    {
        string html = "<table>";
        //add header row
        html += "<tr>";
        for (int i = 1; i < dt.Columns.Count; i++)
            html += "<td>"
                + dt.Columns[i].ColumnName + "</td>";
        html += "</tr>";
        //add rows
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            html += "<tr>";
            for (int j = 1; j < dt.Columns.Count; j++)
            {
                    html += "<td>" + dt.Rows[i][j].ToString() + "</td>";
            }
            html += "</tr>";
        }
        html += "</table>";
        return html;

    }