Get week number from a given date

public static int GetWeekNumber(string date)
{
DateTimeFormatInfo dfi = DateTimeFormatInfo.CurrentInfo;
DateTime dt = DateTime.ParseExact(date,"dd-MM-yyyy",null);
System.Globalization.Calendar cal = dfi.Calendar;
return cal.GetWeekOfYear(dt, dfi.CalendarWeekRule, dfi.FirstDayOfWeek);
}

Get the first day of week from the week number

public string GetFirstDayOfWeek(int weekNum)
{
DateTime dt = new DateTime(DateTime.Now.Year, 1, 1);
int days = (weekNum) * 7;
DateTime dt1 = dt.AddDays(days);
DayOfWeek dow = dt1.DayOfWeek;
DateTime startDateOfWeek = dt1.AddDays(-(int)dow);
return startDateOfWeek.ToString("dd MMM");
}
public static string GetFirstDayOfWeek(DateTime dayInWeek)
{
CultureInfo cultureInfo = CultureInfo.CurrentCulture;
DayOfWeek firstDay = cultureInfo.DateTimeFormat.FirstDayOfWeek;
DateTime firstDayInWeek = dayInWeek.Date;
while (firstDayInWeek.DayOfWeek != firstDay)
firstDayInWeek = firstDayInWeek.AddDays(-1);
return firstDayInWeek;
}

SQL Pivoting weekdays

DECLARE @COLUMNS VARCHAR(8000)
SELECT
@COLUMNS =
COALESCE
(
@COLUMNS + ',[' + CAST(DATEPART(WW, TR_DATE) as varchar) + ']',
'[' + CAST(DATEPART(WW, TR_DATE) as varchar)+ ']'
)
FROM
TRANSACTIONS
GROUP BY
DATEPART(WW, TR_DATE)
ORDER BY DATEPART(WW,TR_DATE)
select @COLUMNS
DECLARE @QUERY VARCHAR(8000)
SET @QUERY = 'SELECT *
FROM
(
SELECT
TR_PR_NO,
DATEPART(ww, TR_DATE) as weekdate,
ISNULL(TR_AMOUNT,0) as amount
FROM
TRANSACTIONS
) PIV
PIVOT
(
SUM(amount) FOR weekdate in (' + @columns + ')
) AS chld'
EXECUTE (@query)
GO

Get all monday of a month

DateTime date = DateTime.Today;
var dates = Enumerable.Range(1, DateTime.DaysInMonth(date.Year, date.Month)).Select(n => new DateTime(date.Year, date.Month, n));
var weekends = from d in dates
where d.DayOfWeek == DayOfWeek.Monday
select d;
Response.Write(weekends.ToList());

ADODB using JavaScript

var connection = new ActiveXObject("ADODB.Connection") ;
var connectionstring="Data Source=myserver;Initial Catalog=myDB;User ID=testuser;Password=password;Provider=SQLOLEDB";
connection.Open(connectionstring);
var rs = new ActiveXObject("ADODB.Recordset");
rs.Open("SELECT * FROM testtable", connection);
rs.MoveFirst
while(!rs.eof)
{
document.write(rs.fields(0)+" " +rs.fields(1) + "
");
rs.movenext;
}
rs.close;
connection.close;