Exporting to XML

[User (Old forums)]

#16165 |

Guys,

 I’m having an issue Exporting the data from a Datagrid into XML format all I’ve done is implement the three lines of code that are given in the documentation (See Below) and when the code executes I get an InvalidOperationException, the XML file is created but it’s empty.

I’m currently using VB.NET (Visual Studio 2005 Professional), Windows XP SP3, Office 2007 Xceed Grid 3.6.7614.

Any ideas to what could be happening, and any push in a direction would be much appreciated.

 Imports Xceed.Grid.Exporting

Dim excelExporter1 As New ExcelExporter()
        excelExporter1.Export(Me.gridResults, “C:\Test.xml”)

 

Thank you in Advance

Imported from legacy forums. Posted by Brandon (had 771 views)

[User (Old forums)]

#16166

Honestly, this works fine here, so it is hard to tell what can be wrong.  Can you post the complete exception message and stack trace, in case we can point to something?

Imported from legacy forums. Posted by André (had 312 views)

[User (Old forums)]

#16167

Sorry it took a bit to get back to you, the exception detail is below

 

System.InvalidOperationException was unhandled
  Message=”An exception occurred while exporting.”
  Source=”Xceed.Grid”
  StackTrace:
       at Xceed.Grid.Exporting.ExcelExporter.Export(DetailGrid detailGrid, Stream stream)
       at Xceed.Grid.Exporting.ExcelExporter.Export(DetailGrid detailGrid, String filename)
       at Xceed.Grid.Exporting.ExcelExporter.Export(GridControl gridControl, String filename)
       at DuProcessAdvancedSearch.frmAdvSearch.mnFilePrint_Click(Object sender, EventArgs e) in C:\VSS_BUG\.NET\WinForms\DuProcessAdvancedSearch\DuProcessAdvancedSearch\frmAdvSearch.vb:line 229
       at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
       at System.Windows.Forms.ToolStripItem.OnClick(EventArgs e)
       at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
       at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
       at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
       at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
       at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
       at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
       at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
       at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
       at System.Windows.Forms.ToolStrip.WndProc(Message& m)
       at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Imported from legacy forums. Posted by Brandon (had 504 views)

[User (Old forums)]

#16168

Is there an InnerException that would give more information as to what is wrong?

It could be a config problem, like IncludeDetailGrids set to true and DetailGridsMode set to Joined on the ExcelExporter, but SynchronizeDetailGrids set to false on the GridControl­.

It could be a access permission problem on the underlying file of the stream (the “C:\test.xml” ).

It could be a bug.

 

Imported from legacy forums. Posted by André (had 305 views)

[User (Old forums)]

#16169

That was it…my SynchronizeDetailGrids property was set to False, thanks for your help guys I’ll make sure to take note of that issue if anyone here runs into it again. Thanks again

Imported from legacy forums. Posted by Brandon (had 1141 views)

[Author]

Posts