Hi Handy,

We're saving the column preferences in our own xml file that is pretty straightforward, we have the report in question, a list of columns, and whether the user has indicated that they ought to be visible or hidden.

When we load a report, we inspect that file and it overrides whatever might be in the WebGrid column definition on the aspx page. So, we might have eight columns, all of which are designated as visible in our aspx file. But, when the user removes columns and moves them around, their column preferences are changed in the xml file and that is what is used to determine the columns which are loaded.

So, say we have eight columns defined, the user removes two, completes her task and closes her browser. She comes back the next day and when the report is loaded, only six columns are loaded. At this point, if she hits "Reset," she might think that she will get the other two columns back, but she won't. If she removes two more and, in the same session, hits "Reset," then she'll be back to six but she can't get back to eight without manually adding them back. So, what I'm saying is that we'd like to handle the "Reset" postback so that we can eliminate their column preferences altogether but I cannot figure out the difference between a reset call and a normal, manual, column change. Is there some way to determine whether the postback is a reset or if it is just a normal, user, column change?

Thanks,

Brad

Thanks Yudi. I was able to work with this code to achieve my goal here.  You had:

cells.GetNamedItem("Legal").SetText(val, true);
cells.GetNamedItem("Legal").SetText(val);
row.SetDataChanged();
WebGrid1.MarkEdit();

I changed it to:

cells.GetNamedItem("Legal").SetText(val, true);
row.Update();

Using Update() worked a bit better for our situation and I didn't want to call SetText() twice. I wasn't sure if you intended to call it twice for some reason or if it was a mistake but I took out the second call and it worked fine.

Thanks again,

Brad

Handy,

The columns are ultimately specified; what I meant is that they're not specified in the aspx page but, rather, RetrieveStructure() is used to specify the columns. We have some scenarios where the same WebGrid is used for a couple of different searches and we display the different result sets in the same WebGrid. Then the user is allowed to save their preferences, both their form field entries which generate the results, as well as the field(s) that they sorted on, columns that they filtered on, etc. So, we want our users to be able to load one of the reports that they have saved in this manor, call "RetrieveStructure" and then apply the filters via SortedColumns.Add() but it doesn't seem to work. It doesn't work if I call it before or after RetrieveStructure. Is there a way to accomplish this goal? This same process does work in situations where the columns are added to the grid without RetrieveStructure.

Thanks,

Brad

Handy,

I am able to get the checked data key values the following way

            For Each str As String In WebGrid1.RootTable.GetCheckedRows()
                Dim row As WebGridRow = Me.WebGrid1.RootTable.Rows.GetRowByKeyValue(str)
                cList.Add(row.Cells.GetNamedItem("ID").Text.Trim())
            Next

The difference was that I didn't have a DataKeyField on my grid and didn't have PersistRowChecker set to True.

So I am all set now on this one.

Thanks for your help.

Brad