/// <summary> /// Builds a table of records for a given record set. /// </summary> /// <returns> /// The table of records. /// </returns> /// <param name='recordSet'> /// The record set. /// </param> public static DataTable BuildTableOfRecords(RecordSet recordSet) { var table = new DataTable(); var values = new FieldValueTableBuildingVisitor(recordSet); foreach (string column in values.ColumnNames) { table.Columns.Add(column, typeof(string)); } foreach (Dictionary<string, string> fieldSet in values.Rows) { DataRow row = table.NewRow(); foreach (KeyValuePair<string, string> entry in fieldSet) { row[entry.Key] = string.Format("\"{0}\"", entry.Value.Replace("\"", "\\\"")); } table.Rows.Add(row); } return table; }
/// <summary> /// Builds a table of records for a given record set. /// </summary> /// <returns> /// The table of records. /// </returns> /// <param name='recordSet'> /// The record set. /// </param> public static DataTable BuildTableOfRecords(RecordSet recordSet) { var table = new DataTable(); var values = new FieldValueTableBuildingVisitor(recordSet); foreach (string column in values.ColumnNames) { table.Columns.Add(column, typeof(string)); } foreach (Dictionary <string, string> fieldSet in values.Rows) { DataRow row = table.NewRow(); foreach (KeyValuePair <string, string> entry in fieldSet) { row[entry.Key] = string.Format("\"{0}\"", entry.Value.Replace("\"", "\\\"")); } table.Rows.Add(row); } return(table); }