how to run a custome query

Question

0.00/5 (No votes)

See more:

Hi there
i have 12 tables with name Table1,table2......table12
tables has columns like (Date,number)
my tables are displaying results date wise.
now i want that only 3 table should be displayed at a time,
and so soon as i start entering data into 4th table the 1st table is hidden.
explanation: i have a database where i have 12 table with date and number to display,
dates will start from 1,2,3.....31
and number will be displayed with each date.
i want that suppose for march result, Grid view will display Jan,Feb,March results.
As soon as April data display starts jan data should be hidden from grid view.
so my question is how can i achieve this,
my columns had the data type (Date int,number varchar(20))
Note: All this tables will be displayed in one grid-view.
txs in advance

Posted 6-Jan-15 3:42am

Shantanu sinha

Add a Solution

Comments

Maciej Los 6-Jan-15 9:59am

I really do not understand this: now i want that only 3 table should be displayed at a time,
and so soon as i start entering data into 4th table the 1st table is hidden.

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 · Answer 1 · 2015-01-06T04:02:00

Solution 1

As per i understand your requirements, you have to create only one table which holds a date, then you'll be ablt to filter data based on that date.

Posted 6-Jan-15 4:02am

Maciej Los