version 1.0.2005.1 final (self-servicing) VS2005 winforms

hiya,

Is it possible to remove an entityCollection row that is bound to datagridview, simply by using the "delete" button?

This behaviour is available thru standard winforms 2.0 RAD, can the same be done with an entityCollection?

cheers,

yogi

You will need to set the AllowRemove property for the collection to true. It will not delete the row from the database, but will remove it from the collection.

hiya,

If that is the case, then If i call the "SaveMulti" method of the entityCollcetion, should the row should be removed fro the underlying database?

I have called the "SaveMulti" method in the datagridView_RowsRemoved event handler, but nothing happens.

How can I remove the row from the underlying database?

many thanks,

yogi

Take a look at this thread http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=4944&HighLight=1. You will need to add the removed entities to either a collection or unit of work and commit the change when you want to remove them from the database using delete methods.

hiya, Thanks for that.

I am struggling to see where this would fit in with a datagridView_RowsRemoved eventHandler....I can't see how I can grab the Id of the selected row from the event args.

This the code I have so far..far from complete but I am hoping that it can show where I am going wrong.

 private void dgvDeliveryProducts_RowsRemoved(object sender, DataGridViewRowsRemovedEventArgs e)
        {


            //at the moment, I have hard-coded the args..but I have to somehow apply these args to the entityCollection
            TblDeliveryProductsEntity deliveryProductToBeDeleted = new TblDeliveryProductsEntity(0, "12344");
            
            
            UnitOfWork uow = new UnitOfWork();

            uow.AddForDelete(deliveryProductToBeDeleted);       
            uow.Commit(new Transaction(IsolationLevel.ReadCommitted, "UOW"), true);
            //ERROR: isolationLevel does not exist in this context.

Does anyone know why I get the "isloationLevel" error?

many thanks,

yogi

I can grab the Id of the selected row from the event args.

I think you may the cells of your acted upon row by the following: e.Item.Cells[i]

For example if you have the id of you entity in the first cell then to get back the id you might use the following:

int nID = Int32.Parse(e.Item.Cells[0].Text);

ok thanks Walaa.

do youhave any idea why I am getting the "isolationLevel" error, I thought I had declared all the "using" statements that I need, but I can't find the one that contains "isolationLevel"

may thanks,

yogi

Would you please post the complete exception stack trace?

hiya,

I needed to include the system.data namespace.

here's the code that worked. Thanks for the help,

yogi

private void dgvDeliveryProducts_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e)
        {
            object deliveryId = e.Row.Cells[0].Value;
            object productId = e.Row.Cells[1].Value;   

            TblDeliveryProductsEntity delivery = new TblDeliveryProductsEntity(deliveryId , productId );

            UnitOfWork uow = new UnitOfWork();
            uow.AddForDelete(delivery);
            uow.Commit(new Transaction(IsolationLevel.ReadCommitted, "UOW"), true);
        }

You may want to take a look at e.Row.DataBoundItem.

You could then cast e.Row.DataBoundItem to the EntityType contained in the collection bound to the grid.

Then you could have:

private void dgvDeliveryProducts_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e)
        {
            TblDeliveryProductsEntity delivery = (TblDeliveryProductsEntity) e.Row.DataBoundItem;

            UnitOfWork uow = new UnitOfWork();
            uow.AddForDelete(delivery);
            uow.Commit(new Transaction(IsolationLevel.ReadCommitted, "UOW"), true);
        }

cheers Jim, I like your style :-)

I had been trying to figure out how to cast and trim the cell values.

ta,

yogi