GridView Data Display On The Basis Of Date

Question

0.00/5 (No votes)

See more:

I have a table Ex (ID,one,Two,three,Four,five,six,seven,eight,nine,ten) and values are in following format . .

SQL

ID one Two three Four five six seven eight nine ten

1 10 11 12 13 14 15 16 17 18 19

2 21 21 22 23 24 25 26 27 28 29

3 13 14 12 13 54 55 46 13 18 19

4 10 11 12 13 14 15 16 17 18 19

5 10 14 124 113 114 115 116 117 118 119

Here The Column Represents The Months and Id represents The Date. so I want a query where only three month data will be displayed on the basis of the month. suppose we have records of Jan,Feb,march now as soon as April comes (It will be compared or fetched through label displaying Current Date) Jan Data Automatically be removed. now the record will have only Feb,March,April data (current) To Kindly Help me How To achieve this.

Posted 13-Jan-15 1:43am

Shantanu sinha

Updated 13-Jan-15 2:20am

King Fisher

v2

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Jan-15 13:24pm

What have you tried and where is the issue?

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)

Suvendu Shekhar Giri · Answer 1 · 2015-01-13T08:57:00

Yes, you can do this. Little weird though. Have a look.

SQL

--Get current month
DECLARE @MONTH INT
SELECT @MONTH=DATEPART(MONTH,GETDATE())

--Get first column/month name 
DECLARE @MONTH1 VARCHAR(10)
SELECT @MONTH1 = COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'MYTABLE'
AND ORDINAL_POSITION = @MONTH+1	--added 1 to exclude column 'ID'

--get second column/month name
DECLARE @MONTH2 VARCHAR(10)
IF(@MONTH<12) SET @MONTH=@MONTH+1 ELSE SET @MONTH=1
SELECT @MONTH2 = COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'MYTABLE'
AND ORDINAL_POSITION = @MONTH+1

--get third column/month name
DECLARE @MONTH3 VARCHAR(10)
IF(@MONTH<12) SET @MONTH=@MONTH+1 ELSE SET @MONTH=1
SELECT @MONTH3 = COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'MYTABLE'
AND ORDINAL_POSITION = @MONTH+1

DECLARE @SQL AS NVARCHAR(1000)
SET @SQL = 'SELECT ' + @MONTH1 +',' + @MONTH2 +','+@MONTH3 +' FROM MYTABLE' 

EXEC(@SQL)

I have tried this in my local and should do your job. In case this doesn't work or you want me to explain anything, please let me know :)