Updating DataTable bound to a DataGridView

[Carlos Cruz]

Hi,

I've a DataGridView with Datasourse = Datatable.
The problem is that I can't get my last record updated at the database
unless I change the row where I'm editing...
Can anyone explain me why and how can I manage to get rid of this?

By the way, Im' updating with DataAdapter.Update(DataTable)

Thanks in advance
CC

 

[Cor Ligthert [MVP]]

Carlos,

Was that in past (version 1.x) the currentmanager.endcurrentedit is it now
the Bindingsource.endedit which is doing the trick to force the rows into
the datasource.

http://msdn2.microsoft.com/en-us/library/system.windows.forms.bindingsource.endedit.aspx

I hope this helps,

Cor

 

[JeremyGrand]

Cor, I'm having a similar problem. Tried dropping a bindingsource on my
form & used it as the datasource for my datagridview. Assigned my dataset as
datasource for the bindingsource. However, this seems to have no effect --
no rows are displayed (if I use the dataset as the datasource for the grid,
I do have rows). What is the magic step I'm leaving out?

Jeremy

 

[Cor Ligthert [MVP]]

Jeremy,

Did you do it like this?

http://www.vb-tips.com/dbpages.aspx?ID=1139f14a-c236-4ad7-8882-b1ed16424252

Cor