每月将Datagridview保存到本地数据库表 [英] Saving Datagridview to Local databse table each month

问题描述

你好

我是 和vb.net的新功能我正在做一个小项目我在哪里使用本地数据库在该数据库中，我有一张表人" (ID，名称，工作，小时).

i'm  new to here and vb.net   i'm working on a small project  where i use  a local database  in that database i have a table  "Person" (ID,Name, Job , hours) .

我显示该数据在datagridview上，例如每个周或月份我更改(小时)每个人以及多少小时工作(kinda存档)   我需要保存 每次使用不同名称的表格数据例如Tab_January_2015，Tab_Feb_2015 ... etc到树状视图

i display that data  on a datagridview  , for example  each  week  or month   i change (hour)   each person  and how many hours  worked  (kinda archive )     i need to save that table data each time with a different name  for example Tab_January_2015 , Tab_Feb_2015 ...etc  to a treeview  .

我不知道是否有人可以帮我一个主意或代码.

i don't know if anybody  can  help me out with an idea  or code .

提前感谢

推荐答案

我显示该数据在datagridview上，例如每个周或月份我更改(小时)每个人以及多少小时工作(kinda存档)   我需要保存 每次使用不同名称的表格数据例如Tab_January_2015，Tab_Feb_2015 ... etc到树状视图

i display that data  on a datagridview  , for example  each  week  or month   i change (hour)   each person  and how many hours  worked  (kinda archive )     i need to save that table data each time with a different name  for example Tab_January_2015 , Tab_Feb_2015 ...etc  to a treeview  .

您好Marco_Ne，

Hi Marco_Ne,

正如您所说的每周或每月"，如果您想每周或每月过滤并显示数据，则可以在数据库中添加一个时间字段，然后按时间过滤.

As you said that "each week or month", If you want to filter and show the Data each week or month, you could add a field of time to the DataBase, Then filter by the time.

您想保存该表数据，我想知道将此数据保存在哪里?您要保存到数据库吗?还是在dataGridView中修改小时数据，然后将修改后的数据保存到数据库中?

And you want to save that table data, I would like to know where you save this data? You'd like to save to DataBase? Or you modify the data of hours in the dataGridView, then save the modified data to the DataBase?

您还提到了TreeView，此Treeview的功能是什么?

And you also mention the TreeView, what is the function of this treeview?

如果您可以分享有关所需内容的更多详细信息，那么我会更好地帮助您.

If you could share more details about what you want, I could help you better.

最诚挚的问候，
唐友军

Best regards,
Youjun Tang

这篇关于每月将Datagridview保存到本地数据库表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！