如何运行客户查询 [英] how to run a custome query

查看:62
本文介绍了如何运行客户查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

您好

i有12个表名为Table1,table2 ...... table12

表有列(日期,数字)

我的表格显示日期结果。

现在我想要一次只显示3个表格,

我开始输入数据时很快第4个表隐藏第1个表。

说明:我有一个数据库,我有12个表格,显示日期和数字,

日期将从1,2开始, 3 ..... 31

和数字将与每个日期一起显示。

i想要3月结果,网格视图将显示1月,2月,3月结果。

一旦4月数据显示开始,jan数据应该从网格视图中隐藏。

所以我的问题是如何实现这一点,

我的列有数据类型(Date int,number varchar(20))

注意:所有这些表都将显示在一个网格视图中。

txs提前

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

推荐答案

as pe我理解你的要求,你必须只创建一个包含日期的表,然后你将根据该日期过滤数据。
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.


这篇关于如何运行客户查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆