Intersoft Community - WebGrid Enterprise - Any way to get webgrid's column resized width to save

Any way to get webgrid's column resized width to save

yudi — Thu, 24 Nov 2016 08:39:44 GMT

... return resized webgrid columns so it could be save and used to fix the width when user return to that page next time...

WebGrid has SaveTablesStructureToXml() method which allows you to save RootTable properties – including its Columns and ChildTables – along with all objects contained to an XML file. The table structure can be applied to WebGrid by using LoadTablesStructureFromXml method. The method will loads table file structure from an XML file and restore it to RootTable of WebGrid.

The snippet code below shows how to save and restore WebGrid's table structure to/from XML file.

protected void Button1_Click(object sender, EventArgs e)
{
	WebGrid1.SaveTablesStructureToXml(Server.MapPath("WebGridTableStructure.xml"));
}

protected void Button1_Click(object sender, EventArgs e)
{
	WebGrid1.LoadTablesStructureFromXml(Server.MapPath("WebGridTableStructure.xml"));
}

Alternatively, you can save the structure to memorystream by invoking SaveTablesStructure() method.

protected void Button1_Click(object sender, EventArgs e)
{
    MemoryStream ms = new MemoryStream();
    WebGrid1.SaveTablesStructure(ms);

    Session["wgState"] = ms;
}

Then load it by invoking LoadTablesStructure() method.

protected void Button2_Click(object sender, EventArgs e)
{
    // retrieve the saved state
		object state = Session["wgState"];
        if (state != null)
        {
            MemoryStream ms = (MemoryStream)state;
            ms.Seek(0, SeekOrigin.Begin);
            WebGrid1.LoadTablesStructure(ms);
            WebGrid1.RebindDataSource();
        }
}

Hope this helps.

Any way to get webgrid's column resized width to save

sjain — Fri, 18 Nov 2016 08:06:51 GMT

Hi,
I used OnColumnResize client event to get width of all columns as

<ClientSideEvents OnColumnResize="TestresizeColumn" />

function TestresizeColumn(controlId, tblName, rowIndex, cellIndex, cellEl) {
var WebGrid1 = ISGetObject(controlId);
var ColumnHeaderElement = WebGrid1.GetRootTable().GetElement(WG40.COLHEADER, WG40.HTMLTABLE);
var SelectedCell = ColumnHeaderElement.rows[0].cells;
for( i=1; i<SelectedCell.length; i++ )
{
alert(SelectedCell[i].colName + ' ' + SelectedCell[i].clientWidth);

}

return true;
}

but it gave use clientwidth before column reszied.
As per documentation
Description
Specifies the client-side function to be invoked when a column is being resized.

Would you mind to suggest some other event or way which can be use for get modified column's width after column is resized? Client requires to have same column width which he/she resized in last visit.
regards
Sachin

Any way to get webgrid's column resized width to save

sjain — Fri, 11 Nov 2016 13:00:53 GMT

Hi,

As we can get access of webgrid applied filter on server and client side, is any specific function(server/client) available which can return resized webgrid columns so it could be save and used to fix the width when user return to that page next time ?

regards

Sachin