Intersoft Community - WebGrid Enterprise - Select Columns

Select Columns

Hans — Thu, 21 Jun 2012 23:57:05 GMT

Hello,

You're welcome John.

Please don't hesitate to ask me again, if you have another question.

I would be happy to help you again.

Regards,

Hans

Select Columns

John.Bonin@dot.gov — Thu, 21 Jun 2012 07:12:04 GMT

Thank You, I will take a look shortly. Am in a release process at the moment.

Select Columns

Hans — Mon, 18 Jun 2012 22:53:52 GMT

Hello,

I’m sorry for this misunderstanding.
You can still get all columns even if the column is hidden.
I made a sample that maybe similar with your scenario.
In my sample, I use WebButton to get all columns name and display it to TextBox.
Here’s the snippet code in OnClientClick client side event:

function WebButton1_OnClientClick(controlId, parameter) {
    var WebButton1 = ISGetObject(controlId);
    var WebGrid1 = ISGetObject("WebGrid1");
    var TextBox1 = document.getElementById("TextBox1");

    var columnLenght = WebGrid1.RootTable.Columns.length;

    for (var i = 0; i < columnLenght; i++) {
        var columnName = WebGrid1.RootTable.Columns[i].Name;
        var columnVisibility = WebGrid1.RootTable.Columns[i].Visible;
        TextBox1.value = TextBox1.value + "Column Name: " + columnName + ";";
        TextBox1.value = TextBox1.value + " Column Visibility: " + columnVisibility + "; \n";
    }
            
    return true;
}

I attached my sample as well.

Hope this helps. Thank you.

Regrads,
Hans.

Select Columns

John.Bonin@dot.gov — Mon, 18 Jun 2012 07:00:45 GMT

Thanks Hans,

In this case I didn't want to get the value, but need to recreate the select columns menu due to a bug in the postioning of the context menu. I need a way to get the names of all the columns and whether they are hidden or not when the table is created.

Select Columns

Hans — Mon, 18 Jun 2012 00:19:54 GMT

Hello,

To get the hidden column value, you could use “HiddenDataMember” column property of WebGrid.
I made a sample to get the hidden column value. In my sample, I use Northwind.mdb database and Shipper table.

I set visibility of Phone column to “False”.
In ShipperID column, I set HiddenDataMember property to “Phone”.

I use OnRowSelect client side event to get the hidden column value, then set the value to TextBox

Here’s the snippet code in OnRowSelect client side event:

function WebGrid1_OnRowSelect(controlId, tblName, rowIndex, rowEl) {
    var WebGrid1 = ISGetObject(controlId);
    var TextBox1 = document.getElementById("TextBox1");
    //get HiddenDataMember
    TextBox1.value = WebGrid1.GetSelectedObject().GetRowObject().GetCells().GetNamedItem("ShipperID").GetElement().attributes["Phone"].value;
    return true;
}

I attached the sample as well.

Hope this helps. Thank you

Regards,
Hans.

Select Columns

John.Bonin@dot.gov — Fri, 15 Jun 2012 14:47:22 GMT

Hi, Since there is a bug in how the context menu is shown, I need to create my own form to allow users to select from. Is there a way to get all columns associated with the roottable and whether they are visible or not? I tried in the InitializeColumn even but it only shows what is visible. Can this be done client side and server side?

thanks

Select Columns

Hans — Tue, 12 Jun 2012 22:32:37 GMT

Hello,

I’m really sorry for the inconvenience.
But unfortunately, I have yet to get any update from our developer team about this issue.

However I’ll let you know if there is any update for this issue.

Thank you for your understanding.

Regards,
Hans.

Select Columns

John.Bonin@dot.gov — Tue, 12 Jun 2012 10:11:15 GMT

Thanks,

But the position of the ContextMenu is still off from an error I reported a while ago based upon the scrollbar location. This is happening with the latest framework. Any fix in the works?

http://www.intersoftpt.com/Community/WebGrid/WebGrid-7-and-Framework-801-error/

Select Columns

Hans — Mon, 11 Jun 2012 22:55:34 GMT

Hello,

I’ve modified my sample by adding WebGrid’s OnColumnContextMenu client side event.
On that event, I hide all menu item except “Select Column” menu item.
Here’s the snippet OnColumnContextMenu client side event:

function WebGrid1_OnColumnContextMenu(controlId, col, menu, isGroup, location) {
    var WebGrid1 = ISGetObject(controlId);
    var menuItemLength = menu.Items.length;

    for (var i = 0; i < menuItemLength; i++) {
        var menuItemName = menu.Items[i].Name;
        if (menuItemName != "mnuSelectColumns") {
            menu.Items[i].Hide();
        }
    }
    return true;
}

I attached the modified sample as well.

Thank you.
Regards,
Hans.

Select Columns

John.Bonin@dot.gov — Mon, 11 Jun 2012 06:48:34 GMT

Thanks Hans, but I don't want to show the entire context menu only the Select Columns menu.

Select Columns

John.Bonin@dot.gov — Fri, 08 Jun 2012 11:36:46 GMT

Just wondering is there a client side event that will show the Select Columns menu? I need to have this menu shown when a button is clicked, users have problems with right-clicking on header to bring up context menu and then selecting "Select Coumns". I know!

Thanks