每月数据加载In.net [英] Monthly Data Loading In.net

问题描述

大家好，

我比较新鲜，Windows应用程序对我来说是新的，
我有一个月的数据，在我的后端数据加载应用程序发生在每月的第5天，第8天，第20天到每月的第31天，我必须存储并获取每月的第一天和该月的第一个星期一，在用户界面级别，我们必须找出特定日期有多少记录处于插入状态.
我如何将整个月存储在数据库中或以其他方式建议使用.


感谢Adv
Kunal

Hi All,

I am Fresher and Windows Application is new for me,
I have one month data,In My application in backend data loading is happning on 5th Day,8th Day, 20th Day e to or31st Day of the month,I have to store and fetch First Day of the Month and First Monday of the month,at UI level we have to find out on particular day how many Records are Pendding.
How i can store the whole month in Database or is anyother way pls suggest.


Thanks in Adv
Kunal

推荐答案

您只需将所有与当前日期时间(C#DateTime.Now或SQL getDate())一起插入.

在月底运行查询.

从创建了> =``每月1天''并创建< =``每月的最后一天''的数据中选择*

You simply insert all the with the current datetime (C# DateTime.Now or SQL getDate()).

At the end of the month run your query.

select * from Data where created >= ''1 day on month'' and created <= ''last day of the month''

e.g select * from data where created >= '1 March 2011' and created <= '31 March 2011'

这篇关于每月数据加载In.net的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！