Setting values in a new row that a user is editing.

I am using a bound datagrid and allowing the users to add rows to the datsource using the new row in the datagrid. However, I need to modify some cells in the row after the user fills out the first 2 column. How do I go about doing this?

I can't use the .NewRow method because that appends another row under the one the user is editing.

Any ideas??

Thanks!!!

Not sure if this is exactly what you're looking for, but here's how I do dataset updates from code:

Code:

---

dsDataSet.Tables("TableName").Rows.Find("KeyField").BeginEdit()
dsDataSet.Tables("TableName").Rows.Find("KeyField").Item("ItemToChange") = "SomeValue"
dsDataSet.Tables("TableName").Rows.Find("KeyField").EndEdit()
dsDataSet.Tables("TableName").Rows.Find("KeyField").AcceptChanges()

---

Sounds like you want to update values in a record -after- the user has inserted that record? Depending on how your data source is defined the syntax may not be exactly right, but I happened to use this a little while ago on a project I'm working on. I'm pretty green so there is probably a better way to do this but it seems to work fine for my purposes.

If you want to do it before the record gets inserted I guess you could watch for a .CurrentCellChanged event but I don't think I'd do it that way (but what do I know heh)

Hope this helps.