Clear the Data View in Graph

public SelectFrom<HMRCVendorRegisterDetail>.View VendorRegisterDetail_X;



public IEnumerable vendorRegisterDetail_X()
{
    var result = new List<HMRCVendorRegisterDetail>();

    return result;
}

Hi @darylbowman ,

I tried this one too. But the problem is VendorRegisterDetail cache contains two instered cache objects. But in my grid contains only one record at this time. How to remove that unwanted object. I tried following in RowPersisting event but no luck. Please check the screen shots which I’ve provided.

HMRCVendorRegisterDetail row = e.Row;
            if (row != null)
            {               

                if (row.BAccountID == null)
                {                    
                    VendorRegisterDetail.Cache.Remove(row);
                    e.Cancel = true;
                    return;
                }

           }

Thanks

What about adding a field to the DAC/Table that is a flag for whether it is an existing record or not and then have a where clause on the Select to exclude those records. Then somewhere in the process prior to save set that same flag so that it wont show up again later when queried?

This feels like it would be unnecessary, but might help you avoid doing too much Cache manipulation.

Hi @bhagyat25,

Could you please try below code to display an empty grid.

VendorRegisterDetail_X.Cache.Clear();

Hope, it helps!

Regards,

Sweta

Hi All,

Need to clear the data view in the graph in the beginning. Currently following view returns data from the table. But I need to remove coming data from the view and show the grid empty(As per attached image).

public SelectFrom<HMRCVendorRegisterDetail>.View VendorRegisterDetail_X;

Can someone help me out?

Thanks

When do you expect to display the data in the grid?
What data should it display?

Hi @vardan22 

After adding new record button then verify the particular record(s) using verify vendor button click event and do the save.