示例#1
0
        public static string ToTSVString(System.Data.DataTable datatable, bool write_column_headers)
        {
            if (datatable == null)
            {
                throw new System.ArgumentNullException("datatable");
            }

            var string_builder = new System.Text.StringBuilder();
            var string_writer  = new System.IO.StringWriter(string_builder, System.Globalization.CultureInfo.InvariantCulture);

            var tsvb = new Isotope.Data.Formats.TSVWriter(string_writer);

            // Handle Column Headers
            if (write_column_headers)
            {
                foreach (System.Data.DataColumn col in datatable.Columns)
                {
                    tsvb.AppendItem(col.ColumnName);
                }

                tsvb.NewLine();
            }

            // Handle Rows
            foreach (System.Data.DataRow row in datatable.Rows)
            {
                foreach (var o in row.ItemArray)
                {
                    tsvb.AppendItem(o.ToString());
                }

                tsvb.NewLine();
            }

            return(string_builder.ToString());
        }
示例#2
0
        public static string ToTSVString(System.Data.DataTable datatable, bool write_column_headers)
        {
            if (datatable == null)
            {
                throw new System.ArgumentNullException("datatable");
            }

            var string_builder = new System.Text.StringBuilder();
            var string_writer = new System.IO.StringWriter(string_builder, System.Globalization.CultureInfo.InvariantCulture);

            var tsvb = new Isotope.Data.Formats.TSVWriter(string_writer);

            // Handle Column Headers
            if (write_column_headers)
            {
                foreach (System.Data.DataColumn col in datatable.Columns)
                {
                    tsvb.AppendItem(col.ColumnName);
                }

                tsvb.NewLine();
            }

            // Handle Rows
            foreach (System.Data.DataRow row in datatable.Rows)
            {
                foreach (var o in row.ItemArray)
                {
                    tsvb.AppendItem(o.ToString());
                }

                tsvb.NewLine();
            }

            return string_builder.ToString();
        }