Hi, (LLBL 2.5/Adapter/SQL Srv 2.5/VB 2005/DevEx)

I can delete a row from a grid with reference to an index using:

CType(StaffBindingSource.DataSource(), EntityCollection(Of StaffEntity)).RemoveAt(idx)

but I need to specify its PK, as in

CType(StaffBindingSource.DataSource(), EntityCollection(Of StaffEntity)).Remove(rowPK)

but what is the syntax for avoiding this 'rowPK' error:

Value of type 'String' cannot be converted to 'MIS.DAL.EntityClasses.StaffEntity'

Pls note: I'm not trying to delete from the DB, just the collection that forms the datasource for the grid.

Thanks

Hi,

Maybe you could first try to retrieve it's index in the DataSource (not per definition the same as the row number I thought) and then use it in RemoveAt().

Or use an EntityView, filter on the PrimaryKey to fetch the entity and use it in Remove()

Cheers, Gab

Create an entity using the PK then use the collection.Remove() method passing that entity. Also you can use the collection.FindMatches() to return the index of the matched PK predicate, and then you can use the index to remove the entity from the collection.

Thanks guys. Happy new year