I want to save a dataset table to an excel file just like the grid exporter. I want to dynamically create the grid without displaying anything and use the grid exporter to export it. The code below runs and there are multiple rows in the dataset with just 1 table. The wg.Refresh(); does not fill the grid. So I am asking how do I get the grid filled with the data. Again, the Grid is not on a form.
Infragistics.Win.UltraWinGrid.
();
wg.DataSource = dsInput;
wg.DataMember =
;
wg.Refresh();
band = wg.DisplayLayout.Bands[0];
//foreach (Infragistics.Win.UltraWinGrid.UltraGridBand band in wg.Rows.Band)
wg.Rows)
{
count = band.Columns.Count - 1; count >= 0; count--)
band.Columns[count].PerformAutoResize(Infragistics.Win.UltraWinGrid.
.AllRowsInBand);
}
Infragistics.Win.UltraWinGrid.ExcelExport.
ux.Export(wg,
);
Hello Rookertrusted,
I am not exactly sure what your scenario is, but if you still use a Windows Forms application you could set the BindingContext of the UltraGrid to one from the Form, or if you are using a console application you could try the second one like the following:
ultraGrid1.BindingContext = this.BindingContext;ultraGrid1.BindingContext = new BindingContext();
Also if you need to resize the columns of the UltraGrid you could try doing so directly like:
ultraGrid1.DisplayLayout.PerformAutoResizeColumns(true, PerformAutoSizeType.AllRowsInBand);If i missunderstood you in a way please feel free to let me know.
The grid is now filled with data with the line: mwg.BindingContext = new BindingContext (); which is perfect, but the line: wg.DisplayLayout.PerformAutoResizeColumns(true, PerformAutoSizeType.AllRowsInBand); does not expand all the columns in the grid. This is a console app and does not need to display the grid. Just need to export it to an excel file.
Infragistics.Win.UltraWinGrid.UltraGrid wg = new Infragistics.Win.UltraWinGrid.UltraGrid();
"objTable";
wg.BindingContext =
new BindingContext();
wg.DisplayLayout.PerformAutoResizeColumns(
true, PerformAutoSizeType.AllRowsInBand);
UltraGridExcelExporter ux = new Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter();
@"c:\rosslrooker.xls");