Intersoft Community - WebGrid Enterprise - Reset columns' visible, lost data

Reset columns' visible, lost data

chermaine.hiew@dextrys.com — Thu, 26 May 2011 01:51:37 GMT

Maybe i did not describle exactly. we just want use the function as the attch file.

The picture just change webgrid's column,but use the JavaScript(WebGrid1.RefreshAll()), the webgrid will structure again,so the unsaved data will lost.

When you modify data on the webgrid,reset the columns' visible,use the following JavaScript ,data will lost.

<!--

function button1_onclick() {

var WebGrid1 = ISGetObject("WebGrid1");

var rootTable = WebGrid1.GetRootTable();

var PhoneColumn = rootTable.Columns.GetNamedItem("Phone");

PhoneColumn.Set("Visible", "false", true);

WebGrid1.RefreshAll();

return true;

}

// -->

</script>

Reset columns' visible, lost data

lili — Thu, 26 May 2011 00:21:59 GMT

Hi Chermaine,

In your code, you set the visible property of Phone column to false. That's why the column is invisible. The RefreshAll function refreshed the grid according to the previous code, which is setting the column visible to false. The column data is not lost, it's just invisible.

If you want to view the Phone column again, simply set the visibility to true and call the RefreshAll function again. You could see my sample as a reference.

Hope it helps.

Regards,

Lili Khiung

Reset columns' visible, lost data

chermaine.hiew@dextrys.com — Wed, 25 May 2011 04:18:36 GMT

i control the columns' visible, and refresh the webgird, then the data has lost, how can i avoid?

I just used the code, following:

<!--

function button1_onclick() {

var WebGrid1 = ISGetObject("WebGrid1");

var rootTable = WebGrid1.GetRootTable();

var PhoneColumn = rootTable.Columns.GetNamedItem("Phone");

PhoneColumn.Set("Visible", "false", true);

WebGrid1.RefreshAll();

return true;

}

// -->

</script>