DataGrid: Update data source when editing a cell and closing the f

[TT (Tom Tempelaere)]

Hi,

Suppose there is a DataGrid on a form bound to a DataTable. When a user is
editing a cell without leaving the cell, and then closes the form, the value
is not updated to the underlying data source.

How can I accomplish this?

Thanks,
--
Tom Tempelaere.

[Dmytro Lapshyn [MVP]]

CurrencyManager cm =
(CurrencyManager)this.BindingContext[dataGrid.DataSource,
dataGrid.DataMember];
cm.EndCurrentEdit();
DataGridColumnStyle curColumn =
dataGrid.TableStyles[0].GridColumnStyles[dataGrid.CurrentCell.ColumnNumber];
dataGrid.EndEdit(curColumn, dataGrid.CurrentRowIndex, false);

--
Sincerely,
Dmytro Lapshyn [Visual Developer - Visual C# MVP]
"TT (Tom Tempelaere)" <_|\|_0$P@|/\|titi____AThotmailD.Tcom|/\|@P$0_|\|_>
wrote in message news:5E**********************************@microsof t.com...

Hi,

Suppose there is a DataGrid on a form bound to a DataTable. When a user is
editing a cell without leaving the cell, and then closes the form, the
value
is not updated to the underlying data source.

How can I accomplish this?

Thanks,
--
Tom Tempelaere.

[TT (Tom Tempelaere)]

It doesn't work. EndEdit *always* returns false, even if the entry is valid.

Unbelievable that even such trivial operations are so hard to find, and when
you try them they don't even work.

Duh,
Tom T.

"Dmytro Lapshyn [MVP]" wrote:

CurrencyManager cm =
(CurrencyManager)this.BindingContext[dataGrid.DataSource,
dataGrid.DataMember];
cm.EndCurrentEdit();
DataGridColumnStyle curColumn =
dataGrid.TableStyles[0].GridColumnStyles[dataGrid.CurrentCell.ColumnNumber];
dataGrid.EndEdit(curColumn, dataGrid.CurrentRowIndex, false);

--
Sincerely,
Dmytro Lapshyn [Visual Developer - Visual C# MVP]
"TT (Tom Tempelaere)" <_|\|_0$P@|/\|titi____AThotmailD.Tcom|/\|@P$0_|\|_>
wrote in message news:5E**********************************@microsof t.com...

Hi,

Suppose there is a DataGrid on a form bound to a DataTable. When a user is
editing a cell without leaving the cell, and then closes the form, the
value
is not updated to the underlying data source.

How can I accomplish this?

Thanks,
--
Tom Tempelaere.

[Dmytro Lapshyn [MVP]]

Try to swap the order - call EndEdit first and then EndCurrentEdit on the
CurrencyManager.

--
Sincerely,
Dmytro Lapshyn [Visual Developer - Visual C# MVP]
"TT (Tom Tempelaere)" <_|\|_0$P@|/\|titi____AThotmailD.Tcom|/\|@P$0_|\|_>
wrote in message news:8D**********************************@microsof t.com...

It doesn't work. EndEdit *always* returns false, even if the entry is
valid.

Unbelievable that even such trivial operations are so hard to find, and
when
you try them they don't even work.

Duh,
Tom T.

"Dmytro Lapshyn [MVP]" wrote:

CurrencyManager cm =
(CurrencyManager)this.BindingContext[dataGrid.DataSource,
dataGrid.DataMember];
cm.EndCurrentEdit();
DataGridColumnStyle curColumn =
dataGrid.TableStyles[0].GridColumnStyles[dataGrid.CurrentCell.ColumnNumber];
dataGrid.EndEdit(curColumn, dataGrid.CurrentRowIndex, false);

--
Sincerely,
Dmytro Lapshyn [Visual Developer - Visual C# MVP]
"TT (Tom Tempelaere)" <_|\|_0$P@|/\|titi____AThotmailD.Tcom|/\|@P$0_|\|_>
wrote in message
news:5E**********************************@microsof t.com...

> Hi,
>
> Suppose there is a DataGrid on a form bound to a DataTable. When a user
> is
> editing a cell without leaving the cell, and then closes the form, the
> value
> is not updated to the underlying data source.
>
> How can I accomplish this?
>
> Thanks,
> --
> Tom Tempelaere.

[TT \(Tom Tempelaere\)]

Dmytro,

Thanks for the suggestion. I'll try it out.

Thank you,
Tom T.
PS: Sorry for the frustrated tone ;-), DataGrid is rather complex sometimes.

"Dmytro Lapshyn [MVP]" <x-****@no-spam-please.hotpop.com> schreef in bericht
news:%2****************@TK2MSFTNGP15.phx.gbl...

Try to swap the order - call EndEdit first and then EndCurrentEdit on the
CurrencyManager.

--
Sincerely,
Dmytro Lapshyn [Visual Developer - Visual C# MVP]
"TT (Tom Tempelaere)" <_|\|_0$P@|/\|titi____AThotmailD.Tcom|/\|@P$0_|\|_>
wrote in message
news:8D**********************************@microsof t.com...

It doesn't work. EndEdit *always* returns false, even if the entry is
valid.

Unbelievable that even such trivial operations are so hard to find, and
when
you try them they don't even work.

Duh,
Tom T.

"Dmytro Lapshyn [MVP]" wrote:

CurrencyManager cm =
(CurrencyManager)this.BindingContext[dataGrid.DataSource,
dataGrid.DataMember];
cm.EndCurrentEdit();
DataGridColumnStyle curColumn =
dataGrid.TableStyles[0].GridColumnStyles[dataGrid.CurrentCell.ColumnNumber];
dataGrid.EndEdit(curColumn, dataGrid.CurrentRowIndex, false);

--
Sincerely,
Dmytro Lapshyn [Visual Developer - Visual C# MVP]
"TT (Tom Tempelaere)"
<_|\|_0$P@|/\|titi____AThotmailD.Tcom|/\|@P$0_|\|_>
wrote in message
news:5E**********************************@microsof t.com...
> Hi,
>
> Suppose there is a DataGrid on a form bound to a DataTable. When a
> user is
> editing a cell without leaving the cell, and then closes the form, the
> value
> is not updated to the underlying data source.
>
> How can I accomplish this?
>
> Thanks,
> --
> Tom Tempelaere.