Hi,

From my Presentation layer, how do I persist entitycollection data updated in my grid, via my Business layer?

I'm can easily call a method in my BL to populate the grid, as in:

    Dim Divisions As New DivisionManager
    BindingSource1.DataSource = Divisions.GetAllDivisions

but I can't find out how to pass back the updated collection from my grid to my BL to persist it as in adapter.SaveEntityCollection(gridDivisions) ?

I'm using version 1.0.2005.1/Adapter/VS2005/VB. I've looked closely at the docs and its driving me nuts. Seems simple , so where am I going wrong?

Read the data back from the grid, construct an entitycollection, fill it with the dataread, then pass it to the business layer.

Please refer to the following thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=4968

Walaa,

Read the data back from the grid, construct an entitycollection, fill it with the dataread, then pass it to the business layer.

Please refer to the following thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=4968

Ahhh, this is also necessary in my WinForm (not Web) client?

What's wrong with the approach you followed here: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=5979

Walaa wrote:

What's wrong with the approach you followed here: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=5979

I switched from Self-service to Adapter as it seemed to be more appropriate for my scenario of Win + Web Clients in various part of the world, but the learning curve is pretty steep

I've created a Presentation Layer linked to managers in a BL, linked to my DAL. While it was straightforward to pass my DivisionEntityCollection up to my grid, I was surprised at how awkward it is to pass the updated collection back.

Since the grid is able to display the data, I'm a little shell shocked that its necessary to read the collection out of the grid instead of just picking up a reference to it. Maybe I've got this wrong.

Any other thoughts gratefully received.

Thanks

Why can't you cast the grid's datasource property's value to IEntityCollection and pass it to your BL? (or cast it to IEntityCollection2 and pass it to the adapter)

You could also store the reference to the collection in a membervariable,...

Otis wrote:

Why can't you cast the grid's datasource property's value to IEntityCollection and pass it to your BL? (or cast it to IEntityCollection2 and pass it to the adapter)

Changes in the grid were successfully persisted when I cast as follows:

    Dim Divisions As New DivisionManager
    Divisions.SaveDivisions(CType(BindingSource1.DataSource(), EntityCollection))

But whenever I access a method in DivisionManager that instantiates a DataAccessAdapter (eg. Dim adapter As New DataAccessAdapter() ), Debug shows the following exception:

A first chance exception of type 'System.InvalidOperationException' occurred in System.dll

Any ideas?

Finally, is there another source of information that would have provided information about casting the Grid's data source property and avoided me asking the original question?

Thanks in advance, you've already been a great help.

whenever I access a method in DivisionManager that instantiates a DataAccessAdapter (eg. Dim adapter As New DataAccessAdapter() ), Debug shows the following exception:

A first chance exception of type 'System.InvalidOperationException' occurred in System.dll

Any ideas?

Please check the following threaad (which might be relevant to your issue): http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=5383

[quotenick="Walaa"]

Please check the following threaad (which might be relevant to your issue): http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=5383

It was, and it did

Much obliged!