Hi imoleayoemman,
You need to make use of SQL JOIN.
Please refer the below query.
SQL
DECLARE @Year TABLE ([Year] INT)
DECLARE @Month TABLE([Month] VARCHAR(10))
DECLARE @User TABLE ([Name] VARCHAR(20))
INSERT INTO @Year VALUES ('2024'), ('2025')
INSERT INTO @Month VALUES ('January'), ('February'), ('March')
INSERT INTO @User VALUES ('John'), ('Mudassar'), ('Robert')
SELECT [Name], [Year], [Month]
FROM @User, @Month, @Year
ORDER BY [Name]
Output
Name Year Month
John Hammond 2024 January
John Hammond 2025 January
John Hammond 2024 February
John Hammond 2025 February
John Hammond 2024 March
John Hammond 2025 March
Use the query to populate the GridView. For more details refer below article.
Implement Pagination in ASP.Net Gridview Control
