public static BulkUploadToSql Load(Stream dataSource) { // create a new object to return BulkUploadToSql o = new BulkUploadToSql(); // replace the code below // with your custom logic for (int cnt = 0; cnt < 20; cnt++) { MyRecord rec; if (cnt % 2 == 1) { rec = new MyRecord("Test", "Test Job", $"ID{cnt}", $"Component{cnt}"); } else { rec = new MyRecord("Test", "Test Job", $"ID{cnt}", $"Component{cnt}", $"ComponentId{cnt}"); } o.internalStore.Add(rec); } return(o); }
private void PopulateDataTable(MyRecord record) { DataRow row; // populate the values // using your custom logic row = this.dataTable.NewRow(); row["Client"] = record.Client; row["AssetId"] = record.AssetId; row["Job"] = record.Job; row["Component"] = record.Component; row["ComponentId"] = record.ComponentId; // add it to the base for final addition to the DB this.dataTable.Rows.Add(row); this.recordCount++; }