Vb.net datagridview binding with MS access database

Question

1.00/5 (1 vote)

See more:

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.

Posted 18-Jul-17 10:06am

Member 13316338

Updated 13-Oct-17 8:43am

Add a Solution

Comments

j snooze 18-Jul-17 17:11pm

There should be like a row selected or cell selected event that passes in the current row or cell object. You should be able to grab the information from that.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2017-10-13T08:43:00

Solution 1

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[^]

Posted 13-Oct-17 8:43am

Maciej Los

Vb.net datagridview binding with MS access database

1 solution

Solution 1

Add your solution here

Preview 0

Vb.net datagridview binding with MS access database

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us