I find myself occasionally needing to update a single record within a BO, usually after messing with data via a sproc. Is there any way to update just one record (row) in the BO?

Well, if it's the only DataRow in the BO that is not Unchanged (modified), then it will be the only row that is saved.  Otherwise, you would need to create a new business object, filter the current one down to that record, use MergeDataFrom to copy over the record, and save the new business object with just that one record in it.

Oops, you misunderstand. How do I refresh that single data row with data from the database?

Aha, that makes more sense   You can use the AppendDataTable method and pass the query that will only retrieve that one record (we don't have an AppendByPrimaryKey).  The other argument for the AppendDataTable() method, besides the DbCommand, is an enum that specifies whether to overwite duplicate records or keep duplicate records; you want to overwrite the record.

Does the AppendDataTable fire the CurrentDataTableRefilled Event ?

Thanks,

Robin Giltner

Yes.  When tables are merged it goes through the ChangeCurrentDataTable method which ultimately raises the CurrentDataTableRefilled event.