I have a datagridview. I disable its AllowUsertoAddRows property. This datagridview is bound to a bindingsource. I am adding rows using bindingsource.addnew(). Afterfinishing entering the data in the last column, which is a mandatory columnI call update function of the tableadapter. I am getting errors that says the last column does not allow nulls. Even though I entered the data before calling the update function.

Hi UrNot,

We need to call the EndEdit method of the DataGridView and the BindingSource before we update the data to database. This is the code:
dataGridView1.EndEdit();
bindingSource1.EndEdit();

Let me know if this helps.
Aland Li

---

Please mark the replies as answers if they help and unmark if they don't. This can be beneficial to other community members reading the thread.

Hi UrNot,

We need to call the EndEdit method of the DataGridView and the BindingSource before we update the data to database. This is the code:
dataGridView1.EndEdit();
bindingSource1.EndEdit();

Let me know if this helps.
Aland Li

---

Please mark the replies as answers if they help and unmark if they don't. This can be beneficial to other community members reading the thread.

Hi UrNot,

We need to call the EndEdit method of the DataGridView and the BindingSource before we update the data to database. This is the code:
dataGridView1.EndEdit();
bindingSource1.EndEdit();

Let me know if this helps.
Aland Li

---

Please mark the replies as answers if they help and unmark if they don't. This can be beneficial to other community members reading the thread.