public void ReadAsDataTable1() { DelimitedClassBuilder cb = new DelimitedClassBuilder("ImportContact", ","); cb.IgnoreEmptyLines = true; cb.GenerateProperties = true; cb.AddField("FirstName", typeof(string)); cb.LastField.TrimMode = FileHelpers.TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("LastName", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("StreetNumber", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("StreetAddress", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("Unit", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("City", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("State", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("Zip", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; engine = new FileHelperEngine(cb.CreateRecordClass()); string source = "Alex & Jen,Bouquet,1815,Bell Rd,, Batavia,OH,45103" + Environment.NewLine + "Mark & Lisa K ,Arlinghaus,1817,Bell Rd,, Batavia,OH,45103" + Environment.NewLine + "Ed & Karen S ,Craycraft,1819,Bell Rd,, Batavia,OH,45103" + Environment.NewLine; DataTable contactData = engine.ReadStringAsDT(source); Assert.AreEqual(3, contactData.Rows.Count); Assert.AreEqual(8, contactData.Columns.Count); Assert.AreEqual("Alex & Jen", contactData.Rows[0][0].ToString()); Assert.AreEqual("Mark & Lisa K", contactData.Rows[1][0].ToString()); // new DelimitedClassBuilder("", ","); }
/// <summary> /// Read the file as a data table /// </summary> private void cmdRun_Click(object sender, EventArgs e) { FileHelperEngine engine = new FileHelperEngine(typeof(CustomersFixed)); DataGridDatos.DataSource = engine.ReadStringAsDT(txtData.Text); ; }
private void RunTest() { try { string classStr = mLastCode; var selected = cboClassLanguage.SelectedItem as NetLanguageList.LanguageType; Type mType = ClassBuilder.ClassFromString(classStr, selected.Language); try { FileHelperEngine engine = new FileHelperEngine(mType); DataTable dt = engine.ReadStringAsDT(txtInput.Text); dgPreview.DataSource = dt; lblResults.Text = dt.Rows.Count.ToString() + " Rows - " + dt.Columns.Count.ToString() + " Fields"; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error Parsing the Sample Data", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error Compiling Class", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void ReadFile() { Type t = ClassBuilder.ClassFromSourceFile(TestCommon.GetPath("Classes", "ClassFromFile.cs")); var engine = new FileHelperEngine(t); DataTable dt = engine.ReadStringAsDT(""); Assert.AreEqual(0, dt.Rows.Count); }
public void ReadAsDataTable1() { DelimitedClassBuilder cb = new DelimitedClassBuilder("ImportContact", ","); cb.IgnoreEmptyLines = true; cb.GenerateProperties = true; cb.AddField("FirstName", typeof(string)); cb.LastField.TrimMode = FileHelpers.TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("LastName", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("StreetNumber", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("StreetAddress", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("Unit", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("City", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("State", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("Zip", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; var engine = new FileHelperEngine(cb.CreateRecordClass()); string source = "Alex & Jen,Bouquet,1815,Bell Rd,, Batavia,OH,45103" + Environment.NewLine + "Mark & Lisa K ,Arlinghaus,1817,Bell Rd,, Batavia,OH,45103" + Environment.NewLine + "Ed & Karen S ,Craycraft,1819,Bell Rd,, Batavia,OH,45103" + Environment.NewLine; DataTable contactData = engine.ReadStringAsDT(source); Assert.AreEqual(3, contactData.Rows.Count); Assert.AreEqual(8, contactData.Columns.Count); Assert.AreEqual("Alex & Jen", contactData.Rows[0][0].ToString()); Assert.AreEqual("Mark & Lisa K", contactData.Rows[1][0].ToString()); // new DelimitedClassBuilder("", ","); }
static void ReadDelimitedFile() { var detector = new SmartFormatDetector(); detector.FileHasHeaders = hasHeaders; detector.MaxSampleLines = 100; var formats = detector.DetectFileFormat(FilePath); if (formats.Length == 0) { return; } string FileInput = File.ReadAllText(FilePath); try { ClassBuilder sb = ClassBuilder.LoadFromXml(xmlTrasfertaClassPath); var type = ClassBuilder.ClassFromString(sb.GetClassSourceCode(NetLanguage.CSharp), NetLanguage.CSharp); FileHelperEngine engine = new FileHelperEngine(type); engine.ErrorMode = ErrorMode.SaveAndContinue; DataTable dt = engine.ReadStringAsDT(FileInput); if (engine.ErrorManager.Errors.Length > 0) { dt = new DataTable(); dt.Columns.Add("LineNumber"); dt.Columns.Add("ExceptionInfo"); dt.Columns.Add("RecordString"); foreach (var e in engine.ErrorManager.Errors) { dt.Rows.Add(e.LineNumber, e.ExceptionInfo.Message, e.RecordString); } MessageBox.Show("Error Parsing the Sample Data", "Layout errors detected", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { //dgPreview.DataSource = dt; //lblResults.Text = dt.Rows.Count.ToString() + " Rows - " + dt.Columns.Count.ToString() + " Fields"; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error Compiling Class", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void PasteFromClip() { DelimitedClassBuilder classBuilder = ExamineGridForColumnOrder("\t"); try { FileHelperEngine engine = new FileHelperEngine(classBuilder.CreateRecordClass()); DataTable dt = engine.ReadStringAsDT(Clipboard.GetText()); PasteDataTable(dt); } catch (Exception ex) { throw ex; //addInBase.MessageService.LogMessage(new ApplicationMessage(ex, ApplicationMessageType.ErrorNoPopup)); } }
private static void Main(string[] args) { var cb = new DelimitedClassBuilder("Customer", ","); cb.AddField("SomeField", typeof(String)); cb.LastField.Converter.TypeName = typeof(OtherNameSpace.MyConverter).ToString(); Type recordClass = cb.CreateRecordClass(); var engine = new FileHelperEngine(recordClass); var records = engine.ReadStringAsDT("aaa"); Assert.AreEqual("aaa", records.Rows[0].Field <string>(0)); Console.WriteLine("All OK"); Console.ReadKey(); }
private void RunTest() { try { string classStr = mLastCode; var selected = cboClassLanguage.SelectedItem is NetLanguage ? (NetLanguage)cboClassLanguage.SelectedItem : NetLanguage.CSharp; var type = ClassBuilder.ClassFromString(classStr, selected); FileHelperEngine engine = new FileHelperEngine(type); engine.ErrorMode = ErrorMode.SaveAndContinue; DataTable dt = engine.ReadStringAsDT(txtInput.Text); if (engine.ErrorManager.Errors.Length > 0) { dt = new DataTable(); dt.Columns.Add("LineNumber"); dt.Columns.Add("ExceptionInfo"); dt.Columns.Add("RecordString"); dt.Columns.Add("RecordTypeName"); foreach (var e in engine.ErrorManager.Errors) { dt.Rows.Add(e.LineNumber, e.ExceptionInfo.Message, e.RecordString, e.RecordTypeName); } dgPreview.DataSource = dt; MessageBox.Show("Error Parsing the Sample Data", "Layout errors detected", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { dgPreview.DataSource = dt; lblResults.Text = dt.Rows.Count.ToString() + " Rows - " + dt.Columns.Count.ToString() + " Fields"; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error Compiling Class", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void cmdReadTest_Click(object sender, EventArgs e) { try { string classStr = sdClassOut.Text; Type mType = null; switch (cboClassLeng.SelectedIndex) { case 0: mType = ClassBuilder.ClassFromString(classStr, NetLanguage.CSharp); break; case 1: mType = ClassBuilder.ClassFromString(classStr, NetLanguage.VbNet); break; default: break; } try { FileHelperEngine engine = new FileHelperEngine(mType); DataTable dt = engine.ReadStringAsDT(txtInput.Text); dgPreview.DataSource = dt; lblResults.Text = dt.Rows.Count.ToString() + " Rows - " + dt.Columns.Count.ToString() + " Fields"; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error Parsing the Sample Data", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error Compiling Class", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// Read the file as a data table /// </summary> private void cmdRun_Click(object sender, EventArgs e) { FileHelperEngine engine = new FileHelperEngine(typeof (CustomersFixed)); DataGridDatos.DataSource = engine.ReadStringAsDT(txtData.Text);; }
private void RunTest() { try { string classStr = mLastCode; var selected = cboClassLanguage.SelectedItem is NetLanguage ? (NetLanguage) cboClassLanguage.SelectedItem : NetLanguage.CSharp; var type = ClassBuilder.ClassFromString(classStr, selected); FileHelperEngine engine = new FileHelperEngine (type); engine.ErrorMode = ErrorMode.SaveAndContinue; DataTable dt = engine.ReadStringAsDT (txtInput.Text); if (engine.ErrorManager.Errors.Length > 0) { dt = new DataTable (); dt.Columns.Add ("LineNumber"); dt.Columns.Add ("ExceptionInfo"); dt.Columns.Add ("RecordString"); foreach (var e in engine.ErrorManager.Errors) { dt.Rows.Add (e.LineNumber, e.ExceptionInfo.Message, e.RecordString); } dgPreview.DataSource = dt; MessageBox.Show ("Error Parsing the Sample Data", "Layout errors detected", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { dgPreview.DataSource = dt; lblResults.Text = dt.Rows.Count.ToString () + " Rows - " + dt.Columns.Count.ToString () + " Fields"; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error Compiling Class", MessageBoxButtons.OK, MessageBoxIcon.Error); } }