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

Question

I have datagridview1 and databindingNavigator1 both bound to databindingSource1

I wonder how to set a value by code to a cell in datagridview1 as soon as I click on the AddNew button of the databindingNavigator.

I tried datagridview1_RowsAdded event without success.

Thanks in advance.

Vulpes · Answer

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

ahmad alsafi · Answer

Hi Samio TestCell is not the name of the column it's the data property name. The name is under design category usually something like dataGridViewTextBoxColumn123 etc

Samio · Answer

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.

Samio · Answer

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.

Samio · Answer

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 ....);

Vulpes · Answer

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;

Samio · Answer

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

Vulpes · Answer

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: private void bindingNavigatorAddNewItem_Click(object sender EventArgs e) { // add code }