Hi Veli,
Yes, I did try Brent's suggestion with no luck. So, I have a subset of the grid columns that are not visible when the grid is initially displayed. When the user clicks the context menu on a column header they can hide/show columns. Even after implementing Brent's suggestion the initially hidden columns never become visible. This is a snippet of code for how I define my grid:
<telerik:RadGrid AutoGenerateColumns="False" ID="RadGrid1" DataSourceID="projectAdhocDS"
Width="760px" AllowFilteringByColumn="True" AllowSorting="True" GridLines="Both"
PageSize="2" ShowFooter="True" AllowPaging="True" runat="server" OnDataBound="RadGrid1_DataBound"
GroupingEnabled="true"
EnableLinqExpressions="False" OnItemDataBound="RadGrid1_ItemDataBound"
OnItemCommand="RadGrid1_ItemCommand">
<ExportSettings />
<MasterTableView ShowFooter="true" Width="100%" TableLayout="Fixed" CommandItemDisplay="Top">
<PagerStyle Mode="NextPrevNumericAndAdvanced" />
<CommandItemSettings ShowAddNewRecordButton="false" ShowExportToWordButton="true" ShowExportToExcelButton="true"
ShowExportToCsvButton="true" />
<Columns>
<telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Left" Visible="true"
HeaderText="Project Number" SortExpression="ProjectNumber"
HeaderStyle-Wrap="true" HeaderStyle-Width="100px" ItemStyle-Wrap="true" DataField="ProjectNumber" >
</telerik:GridBoundColumn>
I have more columns, but they're setup the same way. Here's my menu which is defined outside the grid.
<telerik:RadContextMenu ID="RadMenu1" runat="server" Skin="Outlook"
CollapseAnimation-Type="None" OnClientItemClicked="ClientItemClicked">
<Items>
<telerik:RadMenuItem Text="Hide Column" />
<telerik:RadMenuItem Text="Show Column" />
<telerik:RadMenuItem Text="Restore All" />
</Items>
<Targets>
<telerik:ContextMenuTagNameTarget TagName="thead" />
</Targets>
</telerik:RadContextMenu>
I dynamically populate the "show column" menu with the columns that happen to be hidden at that time. Now, here are the JS functions I use to update and handle the menu. I'm actually having another issue. I can't seem to delete a sub menu item client side without getting a js error.
<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">
<script type="text/javascript">
var activeTable;
var colIndex;
function ColumnContextMenu(sender, eventArgs) {
var radGrid = $find('<%= RadGrid1.ClientID %>');
activeTable = document.getElementById(radGrid.get_masterTableView().get_id());
colIndex = GetRealCellIndex(activeTable, eventArgs.targetElement);
}
function GetRealCellIndex(cols, cell) {
for (var i = 0; i < cols.length; i++) {
if (cols[i].get_element() == cell) {
return i;
}
}
}
function ClientItemClicked(sender, eventArgs) {
var radGrid = $find('<%= RadGrid1.ClientID %>');
var activeTable = $find(radGrid.get_masterTableView().get_id());
if (eventArgs.get_item()._text == "Hide Column") {
var tableCols = activeTable._columnsInternal;
colIndex = GetRealCellIndex(tableCols, eventArgs.get_targetElement());
activeTable.hideColumn(colIndex);
PopulateShowMenu(colIndex);
} else if (eventArgs.get_item()._text == "Restore All") {
RestoreColumns();
}
else {
radGrid.get_masterTableView().showColumn(eventArgs.get_item()._properties._data.value);
//now remove this entry from the hide menu
UpdateMenu(eventArgs.get_item()._properties._data.text);
}
}
function UpdateMenu(entry) {
var menu = $find("<%=RadMenu1.ClientID%>");
var deleteItem = menu.findItemByText(entry);
if (deleteItem != null) {
menu.trackChanges();
var parentItem = deleteItem.get_parent();
if (parentItem != null) {
var subMenu = menu.findItemByText("Show Column");
if (subMenu._children._array.length > 1) {
menu.close();
deleteItem.disable();
}
else
parentItem.disable();
}
menu.commitChanges();
}
}
function PopulateShowMenu(colIndex) {
var grid = $find("<%=RadGrid1.ClientID %>");
var showCount = -1;
var menu = $find("<%=RadMenu1.ClientID%>");
var rootItem;
rootItem = menu.findItemByText("Show Column");
if (rootItem != null) {
rootItem.enable();
for (i = 0; i < grid.get_masterTableView().get_columns().length; i++) {
var gridEle = grid.get_masterTableView().get_columns()[i].get_element();
if (gridEle.currentStyle.display != "block") {
var col = grid.get_masterTableView().get_columns()[i].get_element().firstChild.childNodes;
var childNode = menu.findItemByText(col[0].data);
if (childNode == null) {
var subItem = new Telerik.Web.UI.RadMenuItem();
subItem.set_text(col[0].data);
subItem.set_value(colIndex);
rootItem.get_items().add(subItem);
}
}
}
menu.commitChanges();
}
}
function RestoreColumns() {
var grid = $find("<%=RadGrid1.ClientID %>");
for (i = 0; i < grid.get_masterTableView().get_columns().length; i++) {
grid.get_masterTableView().showColumn(i);
}
}
</script>
</telerik:RadCodeBlock>
I appreciate all your help.
Jessica