Saving Changes to a DataTable bound to a DataGridView

-
Ok,

So I'm working on app that binds a datatable to a data grid view. Normally you would just edit right in the grid and be done. However our table has too much data to edit right in the grid so instead users have to click a row on the grid to load a details panel below the grid. This works great except I noticed changes made to the last row weren't being saved. This is because the grids don't commit changes to their datasource unless a new row is clicked. So after a few hours of digging I found this bit of code worked very well.

// commit all our changes to the datasource of our grid
if( dataGridViewVariables.BindingContext[_tableEditVariables] != null )
{
  dataGridViewVariables.BindingContext[_tableEditVariables].EndCurrentEdit();
}//end if

Check that the object in this case a data table being used to bind exists. And if it does call the end current edit on that object. However if you're binding to a custom collection of objects I believe you need to implement a certain interface for this to work.

Quick update!

I found for custom collections etc, you need to implement the IEditableObject interface. Also when calling the EndCurrentEdit this ends all databinding on the grid so you need to re-bind the datasource to the grid.

Comments

Anonymous said…
I've just spent several hours trying to work this out - your solution seems to work better than any other I've seen.

Cheers!
Friday, February 29, 2008 7:17:00 AM
Anonymous said…
Solution is great, thanks!
Tuesday, February 23, 2010 2:43:00 PM
Anonymous said…
That was GREAT!
Thanks
Monday, May 17, 2010 1:30:00 AM
Anonymous said…
Thanks for this short solution. I couldn't really understand how should I suddenly use BindingContext when I bind to DataTable and this kind of helped.

Wokrs great! :)
Wednesday, October 06, 2010 7:32:00 AM
Dan said…
Thanks for posting this solution. This has been an issue I have been struggling with forever.
Tuesday, January 24, 2012 9:50:00 AM
Tony Awad said…
This comment has been removed by the author.
Monday, February 20, 2012 11:43:00 AM
Tony Awad said…
This works perfectly fine.
I just needed to Google how to use binding context.

I basically had a Grid_View that has its Data Source set to a Data_Table.

Everytime I update the Grid_View I needed to create a new row so my changes are added to the Data_Table. But using

Me.BindingContext(Data_Table).EndCurrentEdit()

after a cell_value_Changed event made it work perfectly.

Cheers.
Monday, February 20, 2012 11:44:00 AM
Post a Comment

Popular posts from this blog

String.Replace vs Regex.Replace

-
Image
I recently ran into a situation where I had to do some string manipulation. I had to replace some bad text with valid text. All this had to do with creating valid xml element names. So we had to string white space and some other invalid characters and replace them with valid xml element formatting. To do this we ended up using the Regex.Replace static method. Simply because there was some complexity involved that would have entailed using more then 1 String.Replace call when we can do it all with one regular expression. This caused some discussion about how heavy the regex class is and when to use it. I decided to do some testing and these are my results. First the code static void Main( string[] args ) { // this is our test value string testValue = "This is a test string"; int count; // run the regex replace DateTime regexStart = DateTime.Now; for( count = 0; count < 10000000; count++ ) { string newValue = Regex.Replace( testValue, ...
Read more

C# Producer Consumer using Rabbit MQ

-
So I've been learning about the different message queuing systems and discovered rabbit MQ, an open source and very popular message queuing system. I've created a very basic producer/consumer system that sends a message to a rabbit MQ queue. Producer/Consumer is pretty simple, you have two systems a producer that writes to a queue and a consumer that reads from a queue. This is desirable because it splits responsibility and allows for scalability. The code below is going to assume you have a rabbit MQ instance installed on your local machine. You can get rabbit MQ here:  https://www.rabbitmq.com/ Now the code is broken down into 3 parts, the main program, the producer, and the consumer. This is a basic example so its using old school threading rather than the new async/await .net prefers. But this is just to show how to use rabbit MQ in C# and to demonstrate a producer/consumer example. You will need to make sure your project has the rabbit MQ client nuget package installed...
Read more

C# Form Application in Kiosk Mode/Fullscreen

-
Sometimes you need to have a C# windows form application run in full screen mode.  Like you see on a kiosk at a mall or some stand alone machine.  It's fairly easy you just need to set some of the properties on the Form either in it's OnLoad method or directly in the designer. In the OnLoad method of the main Form set these values, or again set them directly in the designer. this.MaximizeBox = false; this.TopMost = true; this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None; this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
Read more