Each week's monday date show as column header in GRID view

Question

0.00/5 (No votes)

See more:

I want to design a grid which contain data of weekly allocated project to each resource in ASP.Net MVC + C#

Please help me to design a grid logic where first column is Employee Name and against First Column, 52 more columns started from Calendar Week 39 of the current year to Calendar week 38 of the next year where Each column Header name is the Date-Month of the Monday of that week.

For Example:

For year 2017-18

Column Headers:

[Employee Name|25-Sep|2-Oct|9-Oct|16-Oct|23-Oct|30-Oct|..........|10-Sep|17-Sep]
--------------------------------------------------------------------------------
[Vaibhav|ABC|ABC|ABC|ABC|ABC|ABC|...........|XYZ|XYZ]
--------------------------------------------------------------------------------
[Pandya|XYZ|XYZ|XYZ|XYZ|XYZ|XYZ|...........|ABC|ABC]

Thank You,

What I have tried:

I am new with this grid view concept and logic.

Posted 17-Oct-17 20:30pm

VAIBHAV PANDYA

Updated 23-Oct-17 2:08am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2017-10-23T02:08:00

It's quite simple. Think of it!
Imagine, you have grid which is binded with DataTable. All what you need to do is to define starting date and ending date. Then you have to loop through 7 days. How? Please see:

C#

CultureInfo myCi = CultureInfo.CurrentCulture;
Calendar myCal = myCi.Calendar;
CalendarWeekRule myCWR = myCi.DateTimeFormat.CalendarWeekRule;
//first Monday of year
DateTime firstMonday = new DateTime(DateTime.Today.Year, 1, 1, myCal);
firstMonday = firstMonday.AddDays(-(int)firstMonday.DayOfWeek + (int)DayOfWeek.Monday);
//start date
DateTime startDate = myCal.AddWeeks(firstMonday, 38);
//end date
DateTime endDate = myCal.AddYears(startDate, 1);
endDate = myCal.AddWeeks(endDate, -1);

DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("EmpName", typeof(string)));
    //mondays
firstMonday = startDate;
while(firstMonday<endDate)
{
    dt.Columns.Add(new DataColumn(firstMonday.ToString("dd MMM yyyy", myCi), typeof(string)));
    firstMonday = firstMonday.AddDays(7);
}
//add employee name
dt.Rows.Add("Maciej Los");

For further details, please see:
How to: Extract the Day of the Week from a Specific Date | Microsoft Docs[^]
Calendar.AddWeeks Method (DateTime, Int32) (System.Globalization)[^]