How to refresh valuelist in webgrid EditType="DropDownList"?

yudi — Mon, 17 Oct 2011 00:52:36 GMT

You need to invoke the ClearCachedDataSource() method. ClearCachedDataSource method is used to clear the cache of the data source. After the cache has been cleared, user can use the RebindDataSource method to rebind the data source.

protected void Button2_Click(object sender, EventArgs e)
{
    WebGrid1.ClearCachedDataSource();
    WebGrid1.RebindDataSource();
}

A simple sample of WebGrid’s page was created based on the description of your scenario. WebGrid1 has “DropDownList” EditType on the “Category” column. A WebDialogBox, WebDialogBox1, containing another WebGrid, WebGrid2, is used so that user can add values to the Category list. After user add a new “Category”, click the “Refresh” button to invoke the ClearCachedDataSource and RebindDataSource method.

Please have the attached sample tested on your end and let us hear your feedback.

Hope this helps.

How to refresh valuelist in webgrid EditType="DropDownList"?

bbucher — Fri, 14 Oct 2011 07:23:59 GMT

I have a webgrid with an EditType="Dropdownlist" like this:

                <ISWebGrid:WebGridColumn Caption="Bank" DataMember="BankID" FilterEditType="DropdownList"
                    Name="BankID" Width="240px" DataType="System.Int32" EditType="DropdownList">
                    <ValueList DataSourceID="SqlDataBanks" DataTextField="BankName" 
                        DataValueField="BankID">
                    </ValueList>
                </ISWebGrid:WebGridColumn>

It works fine, except there's also a webdialog on the page so that the user can add values to the Bank List. After the user adds a bank, I refresh the datasource (SqlDataBanks), I refresh the grid, I rebind the grid, etc., but the dropdown list itself won't refresh to include the new bank.

Any ideas?

Thanks, Beryl

Intersoft Community - WebGrid Enterprise - How to refresh valuelist in webgrid EditType="DropDownList"?

How to refresh valuelist in webgrid EditType="DropDownList"?

How to refresh valuelist in webgrid EditType="DropDownList"?