if you are asking for getting current week range then below is the function code for getting current week range
public string fDate()
{
DayOfWeek weekStart = new DayOfWeek();
DateTime startdate = DateTime.Today.AddDays(weekStart - DateTime.Today.DayOfWeek);
string Fdateofweek= startdate.ToShortDateString();
return Fdateofweek;
}
public string cDate()
{
DateTime enddate = DateTime.Today;
string CurrnetDay =enddate.ToShortDateString();
return CurrnetDay;
}
Now Make Sql Query
like
string query = "select * from tablename WHERE Date BETWEEN '" + fDate() + "' AND '" + cDate() + "'";