Frank,

You are coding this like its a Windows application and you need to start thinking in web application terms, which means that when you want to do something like this (saving a transaction) you will need to do it differently than what you might be used to. I do not know how to save the deleted rows in a transaction for possible rollback if the user hit cancel, but what I would possibly suggest is just add a delete checkbox in each row of your grid. When it is checked you do nothing, however when the Save button is clicked then you scan your grid entries and issue the delete for those rows and then also save your client record. When cancel is clicked, you do nothing.

HTH

Bob
>Hi,
>
>I have a Client Table with a 1 to Many relationship with an Addresses Table. My form to edit this data has the Client data and a GridView with the Addresses. This is an ASP.NET application using MM.NET and C#.
>
>When I delete an address from this grid view I want the address to disappear from the form, but I don't want it actually deleted from the data until the user clicks on the Save button.
>
>Currently my code for the deletion is this:
>
>

        /// <summary>
>        /// Addresses Row Deleting Event Handler
>        /// </summary>
>        protected void grdAddresses_RowDeleting(object sender, GridViewDeleteEventArgs e)
>        {
>            DataSet dsAddress = (DataSet)Session["dsAddress"];
>            this.oAddress.Delete(dsAddress, e.RowIndex);
>            this.BindControl(this.grdAddresses);
>        }

>
>But this removes the address completely from the database, even if the user subsequently presses the Cancel button.
>
>So I tried changing the code to this:
>
>

        protected void grdAddresses_RowDeleting(object sender, GridViewDeleteEventArgs e)
>        {
>            DataSet dsAddress = (DataSet)Session["dsAddress"];
>            dsAddress.Tables[0].Rows[e.RowIndex].Delete();
>            Session["dsAddress"] = dsAddress;
>            this.BindControl(this.grdAddresses);
>        }

>
>This removes the row from the dataset and is reflected properly in the grid. But when I subsequently hit the Save button I get this error:
>
>Deleted row information cannot be accessed through the row.
>Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
>
>Exception Details: System.Data.DeletedRowInaccessibleException: Deleted row information cannot be accessed through the row.
>
>Source Error:
>
>Line 24: {
>Line 25: if (this.Row != null)
>Line 26: return (string)mmType.GetNullableDbValue(this.Row["Address1"]);
>Line 27: else
>Line 28: return this._address1;
>
>
>Source File: C:\Development\Mere Mortals .NET Framework 2008\SamaanSystems\IAS.Business\Address\AddressEntity.cs Line: 26
>
>Stack Trace:
>
>[DeletedRowInaccessibleException: Deleted row information cannot be accessed through the row.]
> System.Data.DataRow.GetDefaultRecord() +4814901
> System.Data.DataRow.get_Item(String columnName) +22
> SamaanSystems.IAS.Business.AddressEntity.get_Address1() in C:\Development\Mere Mortals .NET Framework 2008\SamaanSystems\IAS.Business\Address\AddressEntity.cs:26
> SamaanSystems.IAS.Business.AddressRules.CheckRulesHook(mmBindingList`1 entityList) in C:\Development\Mere Mortals .NET Framework 2008\SamaanSystems\IAS.Business\Address\AddressRules.cs:41
> OakLeaf.MM.Main.Business.mmBusinessRule.CheckRules(mmBindingList`1 entityList) +335
> OakLeaf.MM.Main.Business.mmBusinessObjectGeneric`1.CheckRules(mmBusinessObjectGeneric`1 businessObject, mmBindingList`1 entityList) +437
> OakLeaf.MM.Main.Business.mmBusinessObjectGeneric`1.CheckRules() +71
> OakLeaf.MM.Main.Business.mmBusinessObjectGeneric`1.CheckRules(mmBusinessObjectGeneric`1 businessObject, mmBindingList`1 entityList) +695
> OakLeaf.MM.Main.Business.mmBusinessObjectGeneric`1.CheckRules() +71
> OakLeaf.MM.Main.Business.mmBusinessObjectGeneric`1.CheckRules(mmBusinessObject businessObject, DataSet ds, String tableName) +97
> OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName, String databaseKey, IDbDataAdapter dbAdapter) +410
> OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName, String databaseKey) +53
> OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName) +83
> OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds) +74
> OakLeaf.MM.Main.Web.UI.mmBusinessWebPage.Save(mmBusinessObject bizObj, DataSet ds, String tableName) +128
> SamaanSystems.IAS.Web.AgentEdit.btnSave_Click(Object sender, EventArgs e) in C:\Development\Mere Mortals .NET Framework 2008\SamaanSystems\IAS.Web\AgentEdit.aspx.cs:240
> System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
> System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
> System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
> System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
> System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
> System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
>
>Any ideas how I can accomplish this?