日期问题................................. [英] 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屋!