Fetch data Week Wise from SQL Server database and display using C# .Net

You need to create the Stored Procedure and write this Select Query in it.

SELECT * FROM tbltask
WHERE Taskdate BETWEEN DATEADD(WK, DATEDIFF(WK, 0, Taskdate), 0) AND DATEADD(WK, DATEDIFF(WK, 0, Taskdate) + 1, 0) 

It will take the records between todays date and 6 days. If any record is available between these two dates then it will be shown in the GridView.

Please refer this code

HTML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="TaskId" HeaderText="Task Id" />
        <asp:BoundField DataField="TaskDate" HeaderText="Task Date" />
        <asp:BoundField DataField="TaskName" HeaderText="Task Name" />
    </Columns>
</asp:GridView>

Namespaces

using System.Configuration;
using System.Data.SqlClient;
using System.Data;

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.PopulateGridView();
    }
}

private void PopulateGridView()
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("Select * from Task where Taskdate >= dateadd(day, 2-datepart(dw, getdate()), CONVERT(dateTime,getdate())) AND Taskdate <  dateadd(day, 9-datepart(dw, getdate()), CONVERT(dateTime,getdate()))", con))
        {
            using (SqlDataAdapter da = new SqlDataAdapter(cmd))
            {
                DataTable dt = new DataTable();
                da.Fill(dt);
                this.GridView1.DataSource = dt;
                this.GridView1.DataBind();
            }
        }
    }
}

SQL

Create Table Task (TaskId int,TaskDate DATETIME,TaskName nvarchar(250))
insert into Task (TaskId,Taskdate,Taskname) values (1,'20141003','Going Home')
insert into Task (TaskId,Taskdate,Taskname) values (2,'20141004','Birthdayy')
insert into Task (TaskId,Taskdate,Taskname) values (3,'20141005','Anniversery')
insert into Task (TaskId,Taskdate,Taskname) values (4,'20141006','Festival')
insert into Task (TaskId,Taskdate,Taskname) values (5,'20141007','Meeting')
insert into Task (TaskId,Taskdate,Taskname) values (6,'20141008','Outing')
insert into Task (TaskId,Taskdate,Taskname) values (7,'20141009','Cinema')
insert into Task (TaskId,Taskdate,Taskname) values (8,'20141010','Television')
insert into Task (TaskId,Taskdate,Taskname) values (9,'20141011','ParaGliding')
insert into Task (TaskId,Taskdate,Taskname) values (10,'20141012','IceSkating')
insert into Task (TaskId,Taskdate,Taskname) values (11,'20141013','Going Home') 
Select * from task
/* Monday TO Sunday */ 
Select * from Task where Taskdate >= dateadd(day, 2-datepart(dw, getdate()), CONVERT(dateTIME,getdate()))
AND Taskdate <  dateadd(day, 9-datepart(dw, getdate()), CONVERT(dateTIME,getdate()))

Screenshot