Updating a datagridview
Now What I'm trying to do is when user do the changes in the grid those changes should be reflected in the list (in object properties) and then it should be updated in the database.
hey frnds, Firstly I pick the records from the databse into the Data Grid View, Then I want that If we made changes to the records in the Grid View & Click on Update Button, Changes are Reflected into the Datbase .
I have to set the columns' Auto Size to None before changing the data and set them back to All Cells afterwards.
Usually, you bind to a Binding Source that manages the interaction with the data source.
The Binding Source can be any Windows Forms data source, which gives you great flexibility when choosing or modifying your data's location. Add Range(New Control() ) Text = "Data Grid View data binding and updating demo" End Sub Private Sub Get Data(By Val select Command As String) Try ' Specify a connection string.
Is there any way to prevent the Data Grid View to do anything while I am updating the data in the Data Table?
If I want to update one column of every rows in the Data Table, my whole appliation freezes with any response. If I set the Data Source to null before changing the data and set it back after changing. But I lost the status of the Data Grid View, like current selected row, sorting, etc. Finally I found because I set all columns' Auto Size to All Cells, everytime I changes a value in one cell, it goes through all the cells in the column to recaculate the column's width.