Vb.net datagridview与MS访问数据库绑定 [英] Vb.net datagridview binding with MS access database

问题描述

VB.Net。 visual studio 2010



Windows格式的DataGridView。 MS Access数据库。数据库中的所有表都没有关系。



通过DGV修改访问数据库表，添加新行，删除行，没有任何问题，将值更改为任何单元格等。我可以将更改保存到表格中。



问题是如何在移动时显示当前记录编号，表中的总记录编号从DGV内的细胞到细胞。每个DGV行对应一个表的记录。我想显示该记录号（不是DGV的行号）。我还想在表格中显示总记录数量（不是DGV的总可见行数）



我尝试了什么：



DataGridView.datasource = bindingSource



DataGridView与数据库表完全兼容。

解决方案

请按以下链接：

BindingSource查找和过滤基础知识，以推进VB.NET for Visual Studio 2012中的操作 [ ^ ]

将新记录添加到Microsoft Access表中并显示在C＃中的DataGridView中，VB.NET for Visual Studio 2013 [ ^ ]

VB.Net. visual studio 2010

DataGridView in windows form. MS Access database. All tables in the database has no relation to each other.

There is no any issue with modify the access database table through the DGV, add new rows, delete rows, change values to any cell etc. I can save the change to the table.

The issue is how to display current record number, total record number in the table when moving from cell to cell inside the DGV. Each DGV row corresponding to one table's record. I want to display that record number (no the row number of the DGV). I also want to display the total record number in the table (not the total visible row number of DGV)

What I have tried:

DataGridView.datasource=bindingSource

DataGridView is totally working fine with database table.

解决方案

Please, follow the links:
BindingSource Find and Filtering basics to advance operations in VB.NET for Visual Studio 2012[^]
Adding new records into Microsoft Access tables and display in a DataGridView in C#, VB.NET for Visual Studio 2013[^]

这篇关于Vb.net datagridview与MS访问数据库绑定的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！