I use "EnableCaching", so when I do Sort or Filter on the Grid, Select Method retrieve the data from the cache rather than from business object that associated with it.

But I when I change the Year selection from the dropdown list, I want the refreshed data from the business object (from database). Because the data may be changed. That's why I want to clear the ISDataSource cache when the year list selection is changed.

If I don't use ISDataSource for the data binding, with AllowAutoDataCaching property on grid set to True, webgrid.Refresh() will make _webGrid_InitializeDataSource called again where retrieve the data from business object. Can the ISDataSource behave the same way?

Maybe I didn't explain the problem clear enough. I have a ISDataSource which is using CustomObject. Its SelectMethod is set to "GetLeaseActivity" which is in TestIntersoft.UI.DataLayer. You have to set a Breakpoint inside function GetLeaseActivity and debug to it. GetLeaseActivity will only get called once for the same year. For example, I selected 2009 and then 2008, and then 2009 again. GetLeaseActivity function only get called at first time I selected 2009 or 2008, not on the seconde time I select 2009.

On your sample, there is no way I can check if the SelectMothed got called on the second time.

Handy, have you figured out a way to do this?

Thanks!

You are right about disable editing and deleting in the client side but not for enable them. If I invoke JS function in InitializeLayout server side event to enable them, they will be disabled. So I have to remove the invoke script line, and then it is working. Here is the updated code snippet.

How come enable editing/deleting doesn't have to set in the client side but disable does?

Thanks!

protected void _webGrid_InitializeLayout(object sender, ISNet.WebUI.WebGrid.LayoutEventArgs e)
    {
        short fiscalYear = short.Parse(_fiscalYearList.SelectedValue);
        if (fiscalYear == 2009)
        {
            e.Layout.AllowAddNew = AddNew.Yes;
            e.Layout.AllowEdit = Edit.Yes;
            e.Layout.AllowDelete = Delete.Yes;

            //comment out this line, will make it to work.
            //_webGrid.ClientAction.InvokeScript("setWebGridAccess('write')");
        }
        else
        {
            e.Layout.AllowAddNew = AddNew.No;
            e.Layout.AllowEdit = Edit.No;
            e.Layout.AllowDelete = Delete.No;

            _webGrid.ClientAction.InvokeScript("setWebGridAccess('read')");
        }
    }

On your sample, you make the checkbox on each row disabled but if you click on the header checkbox, every row checkbox will become selected. That is not what I wanted. I don't want the disabled row be selectable. I modified your InitializeRow as below, it shows the way I wanted. But when you click on the header checkbox, you'll get the javascript error. Screenshot is attached.

Is there a way to make the header CheckBox to only select thoes selectable rows? If not, how can I hide or disable the header checkbox when the page is load?

Thanks,

Yuting

protected void WebGrid1_InitializeRow(object sender, ISNet.WebUI.WebGrid.RowEventArgs e)
    {
        //e.Row.Cells[0].ForceNoEdit = true;
        if (e.Row.Cells[2].Text == "ANATR" || e.Row.Cells[2].Text == "AROUT")
        {
            e.Row.Table.Columns[0].IsRowChecker = false;
            e.Row.ForceNoEdit = true;
        }
        else
        {
            e.Row.Table.Columns[0].IsRowChecker = true;
            e.Row.ForceNoEdit = false;
        }
    }