Exemplo n.º 1
0
        private void ExportColumns([NotNull] StreamWriter output, [NotNull] QueryAnalyzer.ResultDataTable dataTable)
        {
            Debug.ArgumentNotNull(output, nameof(output));
            Debug.ArgumentNotNull(dataTable, nameof(dataTable));

            var first = true;

            foreach (var column in dataTable.Columns)
            {
                if (first)
                {
                    first = false;
                }
                else
                {
                    output.Write(',');
                }

                var dataColumn = (DataColumn)column;

                output.Write(dataColumn.ColumnName);
            }

            output.WriteLine();
        }
Exemplo n.º 2
0
        private void ExportRows([NotNull] StreamWriter output, [NotNull] QueryAnalyzer.ResultDataTable dataTable)
        {
            Debug.ArgumentNotNull(output, nameof(output));
            Debug.ArgumentNotNull(dataTable, nameof(dataTable));

            foreach (QueryAnalyzer.ResultDataRow dataRow in dataTable.Rows)
            {
                var first = true;

                foreach (var t in dataRow.ItemArray)
                {
                    if (first)
                    {
                        first = false;
                    }
                    else
                    {
                        output.Write(',');
                    }

                    var value = t;
                    if (value != null)
                    {
                        output.Write("\"" + value.ToString().Replace("\"", "\"\"") + "\"");
                    }
                }

                output.WriteLine();
            }
        }