日期问题................................. [英] Problem with dates.................................

问题描述

我有两个表，一个表包含收入，另一个表包含费用.
两者都有DATE列(日期时间类型，大小8)，两者的属性相同.我正在尝试使用datetimepicker从这些表中选择数据.
代码如下:

Hi,
I have two tables, one contains income and other contains expense.
There are DATE coloumns in both (type Datetime, size 8) Same properties for both. I am trying to pick data from these tables using datetimepicker.
Code is as follows:

Me.taGetExpense.Fill(Me.DsGetExpense.tblExpenseSide, dpkCashBook.Value)
Me.taGetIncome.Fill(Me.DsGetIncome.tblIncomeSide, dpkCashBook.Value)

我检查了我的两个表都包含两个记录，但是当我运行上面的代码时，费用方显示2条记录，但收入方显示0
我还检查了dpkCashBook的值，两者都保持不变.


我尝试了一切，但没有任何改变.
有人可以告诉我为什么会这样吗?

非常感谢，
Furqan

I have checked both my tables contain two records but when I run the code above, expense side show 2 records but income side shows 0
I also checked value of dpkCashBook, it remains the same for both.


I tried everything but nothing changed.
Could anybody advise me why this is happening?

Thanks a lot,
Furqan

推荐答案

您可以为费用表发布适配器填充查询吗?
很有可能您弄错了查询

Could you post your adapter fill query for the expense table?
In all probability you have gotten the query mistaken

这篇关于日期问题.................................的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！