Intersoft Community - WebGrid Enterprise - Exporting to XML

Exporting to XML

John.Bonin@dot.gov — Mon, 05 Oct 2009 12:08:40 GMT

Yudi,

Your first example of changing a column name works, although you can't add a space, like "Carrier State" the export replaces the space with "_0020_".

In the second example in changing the Text value doesn't work. You can change the Value but not the Text that gets exported.

thanks

Exporting to XML

John.Bonin@dot.gov — Mon, 05 Oct 2009 10:40:44 GMT

Thanks, I will try out as soon as I can and let you know of any problems.

John

Exporting to XML

yudi@intersoftpt.com — Sun, 04 Oct 2009 23:12:46 GMT

WebGrid has “OnExport” server side event. You can handle the OnExport server side event, write customized exporting codes and set the event’s ReturnValue to false for cancelling default process. You can also have your scenario implemented by using this server side event.

Please try to use following code in order to change the name of the fields that get exported (in the following sample, I use “Shippers” table in Northwind.mdb file as the reference). The sample below shows how to change the “CompanyName” field into “Company”.

protected void WebGrid1_Export(object sender, ISNet.WebUI.WebGrid.ExportEventArgs e)
{
    e.Table.Columns.GetNamedItem("CompanyName").Name = "Company";
}

In order to change a value of field, please try to use following code. The sample below shows how to change the value of a cell, from “United Package” into “United Package Service”.

protected void WebGrid1_Export(object sender, ISNet.WebUI.WebGrid.ExportEventArgs e)
{
    e.Table.Rows[1].Cells.GetNamedItem("CompanyName").Text = "United Package Service";
}

Hope this helps.

Exporting to XML

John.Bonin@dot.gov — Fri, 02 Oct 2009 12:31:34 GMT

Hi,

I am exporting my grid to an XML file and was wondering if there is a way to change the name of the fields that get exported. For example, on the Grid I have a column defined as:

<ISWebGrid:WebGridColumn Caption="State" DataMember="CARRIER_STATE" Name="CarrierState" Width="50px"> </ISWebGrid:WebGridColumn>

When it is exported to XML the Field name is CARRIER_STATE, I would like it to use the Caption name of "State" instead. Is this possible?

Also I would like to change a value of the field when it gets exported. For example a field in the database has the value of -1 but when I display it in the Grid, I change it to "**", but the export uses -1 but I want to use "**". Is this possible?

Thanks

John