Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language

Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

C# Programming

How do convince a DataGridView it's been edited?

The situation:

* I have a ButtonColumn in a DataGridView.
* When the user preses one of the buttons, a dialog appears.
* Based on what the user selects in the dialog, data is entered
programmatically into the the underlying cell (i.e., I'm setting Value
property of the cell based on user input, but the user is not directly
entering any data).

The problem:

The DataGridView doesn't seem believe the user has edited the row, so
if the user clicks or tabs somewhere else (which causes the
DataGridView to lose focus), all the changes to the row get

Other information:

Looking at the RowHeaderCell for the row as it's being edited, it
changes from a large asterisk [*] to a right arrow + asterisk [>*].
This is different than if the user directly edits a cell by typing (in
that case, you'd get a pencil icon while the cell is in edit mode
followed by a large right arrow after the change is committed).

My question:

So, how do I programmatically tell the DataGridView that the user
really has touched/edited this row and that the data should stick even
if the DataGridView loses focus.



If the grid is bound, edit the underlying data source. I dont ever add rows
and columns to a grid with out binding it. I make a DataTable first and let
that be the container for the data. Then I can bind the grid to it and update
the DataTable when needs be.

Ciaran O''Donnell

Thanks to both of you for your replies.

The problem is that I'm not creating a new row programmatically then
filling it with values. Rather, the user is interacting with the "row
for new records" and I'm programmatically entering values into that row
based on what the user does.

If I were just trying to add a new record entirely through code, I
could easily see how this would be done using the underlying DataTable.
But, in this case, if I were to add a new row to the DataTable when the
user interacts with row for new records, It seems like I'd just end up
with two unsync'd versions of the same row.

I like the SendKeys idea, but it only works for tables where there is a
visible DataGridViewTextBoxCell available to send input to. Sending
keys to a DataGridViewButtonCell, for example, doesn't trick the
DataGridView into thinking the row has been edited.

Is there really no way to simply set the status of a row to

There seems to be a way to set the DirtyState of a cell to True
(NotifyCurrentCellDirty), but this still isn't enough to prevent the
problem of all values disappearing when the row loses focus. I also
can't seem to programmatically change the CurrentCell to any other type
of cell besides a DataGridViewTextBoxCell.

Right now, the only solution I can think of is to create a dummy
DataGridViewTextBoxColumn in a every table just so that I can use
SendKeys with it. Someone please tell me I don't have to resort to
something that kludgey!

Thanks again,


On Jan 25, 2:41 am, "ClayB" <c@syncfusion.com> wrote:

Why can't you create a new row for your datatable, and put the user's
entries into it, then add it to the DataGridView?

What are you binding your datagridview to? Is it by chance a list of
objects? Or is it a datatable or dataset?

Robin S.

"DanThMan" <danth@cox.net> wrote in message


It looks like the solution was to place the following code in the
DataGridView'sRowLeave event handler:

'make sure row is not empty
'binding = reference to the binding for the DataGridView

I'd feel better about this if I knew why it worked. I just sort of
stumbled upon it after playing with several different solutions,
including using SendKeys and adding a row to the DataTable.

Thanks for all the advice,


On Jan 25, 2:09 pm, "RobinS" <Rob@NoSpam.yah.none> wrote:

I have found that if I want to be sure that changes to a cell in a
datagridview are made that I need to click on any other row before doing the
update command for the dataadapter.

I am sure there is another way.

"DanThMan" <danth@cox.net> wrote in message


Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc