Refresh button – Refreshing data grid view after inserting, deleting, updating

by

The easiest way to handle this is to use a Binding Source object.

If your loading information into your DataGridView from an Access Database then your most likely storing the Data in a Dataset or DataTable.

Create a Binding Source object, and once you have populated your DataTable/Dataset, set the datasource for your Binding Source to your DataTable. Then set the Datasource from the DataGridView as the Binding Source object.

Doing this ensures that any changes in your datagridview or reflected in the DataTable and vice Versa. If you reload data into your DataTable it will reflect in the Data Grid Automatically.

DataTable dt = new DataTable();

BindingSource bs = new BindingSource();

bs.DataSource = dt;

dataGridView1.DataSource= bs;

All changes will now happen automatically.

More Related Contents:

  1. OLEDB Parameterized Query
  2. The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine while data export to MS ACCESS
  3. How to insert a record into a access table using oledb?
  4. How to create Microsoft Access database in C# programmatically?
  5. SQL connection string for microsoft access 2010 .accdb
  6. How do I get output from a command to appear in a control on a Form in real-time?
  7. c# open a new form then close the current form?
  8. How do I use OpenFileDialog to select a folder?
  9. Using FileSystemWatcher to monitor a directory
  10. Multi-threaded splash screen in C#?
  11. Which Radio button in the group is checked?
  12. Handling a Click for all controls on a Form
  13. How to crop a polygonal area from an image in a WinForm pictureBox? [closed]
  14. Blocking dialogs in .NET WebBrowser control
  15. Validation using Validating event and ErrorProvider – Show Error Summary
  16. expose and raise event of a child control in a usercontrol in c#
  17. How to drag and drop a button from one panel to another panel?
  18. How do I double buffer a Panel?
  19. Transparent window layer that is click-through and always stays on top
  20. Replacing colour of an Image
  21. Simple animation using C#/Windows Forms
  22. C# Get a control’s position on a form
  23. center MessageBox in parent form [duplicate]
  24. insert item in combobox after binding it from a Dataset in c#
  25. How to display text with subscripts or superscripts in the Title Bar?
  26. User Control vs. Windows Form
  27. Windows Forms ToolTip will not re-appear after first use
  28. Populating a DataGridView with Text and ProgressBars
  29. Change the location of an object programmatically
  30. Cursor Position relative to Application

Leave a Comment