datagridview - How to set by code value to a cell when editing a new row and before persisting data.

Finally I found this:  (http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/30a196ae-8fc9-4a31-a6fb-8724e5200e1c)

  private void BtnAddNew_Click(object sender, EventArgs e)
  {
  MyTable k = new MyTable();

  k.Field1 = Value1;
  k.Field2 = Value2;

  Myentities.AddToMyTable(k);

  Myentities.SaveChanges();

  MyBindingSource.RaiseListChangedEvents = true;
  MyBindingSource.ResetBindings(false);
}

this code worked well, data has been persisted, but could not refresh the datagridview.

You might be able to customize the addition of new rows with the BindingSource.AddingNew event.

I don't recall ever using this event before but here's the documentation if you want to play around with it:

http://msdn.microsoft.com/en-us/library/system.windows.forms.bindingsource.addingnew.aspx 

I have found this:

http://blog.gfader.com/2009/02/entity-framework-why-not-use.html

I wish I could adapt it to my case.

It seems not be possible to add row directly to a bound datagridview, row should be added to the list returned by databindingsource1 first, ...

I'll try something like this:

dataBindingSource1.AddNew(new value1, value2, value3,  ....);

It would appear that the DataGridViewColumn in which that cell is located does not have a Name property of TestCell.

I'd see if you can locate it using its column index instead - for example if it's in the third column:

datagridview.CurrentRow.Cells[2].Value = "Test";

Hi Vulpes,

In my datagridview I have a column named "TestCell", and I have already got error using the next event:

        private void BtnAddNew_Click(object sender, EventArgs e)
        {
            datagridview.CurrentRow.Cells["TestCell"].Value = "Test";
        }

Where BtnAddNew is the button within databindingNavigator dedicated to add rows.

The error is:

System.ArgumentException was unhandled
  Message=the column labeled "TestCell" was not found.
Parameter Name : columnName
  Source=System.Windows.Forms
  ParamName=columnName

I think you'll need to handle the AddNew button's Click event.

If you select the BindingNavigator's AddNew button in the VS designer and then, in the Properties Box, locate the Click event and double click it, a skeleton handler should open up so you can add your code: