Show/Hide Grod Columns baed on selected view

[Colin Mulcahy]

Hi,

I have a grid that has a number of columns that must be shown or hidden based on a selection from an external combobox.

Where is the best place(event) to place the code to show/hide these columns in an ajaxed gird? 

Page_Init, Page_Load or perhaps NeedDataSource?

Thanks

Colin

[Shinu]

Hi Colin,

You can show or the hide the column in the SelectIndexChanged event of the ComboBox.

ASPX:

<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" Width="109px" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
          <asp:ListItem Text="ProductName" ></asp:ListItem>
          <asp:ListItem  Text="SupplierID" ></asp:ListItem>
        </asp:DropDownList>

CS:

 protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        string strSelectedItem = DropDownList1.SelectedItem.ToString(); ;
        if (strSelectedItem == "ProductName")

            RadGrid1.MasterTableView.GetColumn(strSelectedItem).Visible = true;

        else if(strSelectedItem == "SupplierID")
            RadGrid1.MasterTableView.GetColumn(strSelectedItem).Visible = true;
        RadGrid1.MasterTableView.Rebind();

    }

Thanks
Shinu.