Hi,

I'm updating a record in a DataTable based on a selected cell in a DataGridview. Here is my code:
((DataRowView)dgv.CurrentRow.DataBoundItem)["Name"] = name;

My questions are:
1. Is there a better way to write the above code to access a bound cell/record?
2. Would it be better to update the DataRow instead of the DataRowView or does updating the DataRowView also update the DataRow?


thanks,
Ron

If it is bound, it should already be updated with the selected cell.

But in terms of accessing the data, yes. I often use the DataBoundItem property to get at the data bound to the DataGridView.

Since you are updating the DataBoundItem, you *ARE* updating the DataRow.

Hope this helps.

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

If it is bound, it should already be updated with the selected cell.

But in terms of accessing the data, yes. I often use the DataBoundItem property to get at the data bound to the DataGridView.

Since you are updating the DataBoundItem, you *ARE* updating the DataRow.

Hope this helps.

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

Thanks Deborah,

I did notice that updating DataRowView did not work with my Expression column automatically (but updating the DataRow worked):

myDataTable.Columns["Subtotal"].Expression = "Price * Quantity";

// Update the DataRow
((DataRowView)dgv.CurrentRow.DataBoundItem).Row ["Quantity"] = newQuantity;


Ron

Cool. So all is well?

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

All is good, I noticed that when I update the bound DataRow, the DataGridView does not automatically refresh. I use dgv.Refresh(), but let me know if you think there's a better way.

thanks,
Ron

I normally bind to a BindingList instead of a DataSet. The business objects in the BindingList implement INotifyPropertyChanged. So when I update the list, it automatically keeps the UI (grid in this case) in sync.

It sounds like the DataSet does not do that. So it seems that a refresh is in order.

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!