public GridCellGroup Execute()
{
reader = (DataReader)command.ExecuteReader();
ResultsetGridBuilder builder = new ResultsetGridBuilder();
GridCellGroup res = builder.Parse(reader.Source);
canExportDS = builder.CanExportDS;
return res;
}
public void ExportTo(GridCellGroup rootCell, string fileName, ExportTarget target)
{
string ext = Path.GetExtension(fileName);
AbstractWriter writer = null;
switch (target)
{
case ExportTarget.Xml:
writer = new XmlFileWriter(fileName);
break;
case ExportTarget.Csv:
writer = new CsvWriter(fileName,
CultureInfo.CurrentCulture.TextInfo.ListSeparator, true);
break;
case ExportTarget.TabDelimited:
writer = new CsvWriter(fileName, "\t", true);
break;
case ExportTarget.FixedLength:
writer = new FlvWriter(fileName, true);
break;
case ExportTarget.AdoNet:
writer = new AdoNetWriter(fileName);
break;
}
if (writer != null)
{
ResultsetGridBuilder builder = new ResultsetGridBuilder();
Resultset rs = builder.CreateResultset((ResultsetGridBuilder.RootCell)rootCell);
writer.Write(rs);
}
}
public void BatchMove(GridCellGroup cell, string name)
{
ResultsetGridBuilder.RootCell rootCell = (ResultsetGridBuilder.RootCell)cell;
CreateTableDialog dlg = new CreateTableDialog();
dlg.TableName = name;
ResultsetGridBuilder builder = new ResultsetGridBuilder();
Resultset rs = builder.CreateResultset(rootCell);
dlg.BatchMove.Source = rs;
if (dlg.ShowDialog() == true)
{
AdoProviderWriter writer = new AdoProviderWriter(dlg.BatchMove);
writer.Write(rs);
}
}
public string GetSourceXML(GridCellGroup rootCell)
{
XmlWriterSettings settings = new XmlWriterSettings
{
Indent = true,
OmitXmlDeclaration = true
};
StringBuilder sb = new StringBuilder();
ResultsetGridBuilder builder = new ResultsetGridBuilder();
Resultset rs = builder.CreateResultset((ResultsetGridBuilder.RootCell)rootCell);
new XmlFileWriter(XmlWriter.Create(sb, settings)).Write(rs);
return sb.ToString();
}
