Databases
StackOverflow2013
Postsdbo
POGet,Set using Lists in C# ...Help Needed
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGet,Set using Lists in C# ...Help Needed
    primarykey
    data
    text
    <p>I need to read a CSV file in C# and drop the data into a list and then dump the data to a SQL Database database.</p> <p>The class I'm interested using is using CsvHelper.</p> <p>This is two sample data in the CSV File:</p> <pre><code>1,2013-05-14,NISSAN,059 7013,1995,VAN,Deisel,NISSAN,0000,NISSAN,Red,MARADANA,op1,description,p1.jpg+p2.jpg+p3.jpg,r1+r2+r3 2,2013-05-14,NISSAN2,059-7013,1995,VAN,Deisel,NISSAN,0000,NISSAN,Red,MARADANA,op1,description,p1.jpg+p2.jpg+p3.jpg,r1+r2+r3 </code></pre> <p>This is the class for the CSV file</p> <pre><code>class Vehicle { public int ID { get; set; } public string ClosingDate { get; set; } public string Model { get; set; } public string Reg { get; set; } public string YearOfManufacture { get; set; } public string VehicleType { get; set; } public string Fuel { get; set; } public string Brand { get; set; } public string Mileage { get; set; } public string Make { get; set; } public string Colour { get; set; } public string VehicleYard { get; set; } public string BasicOptions { get; set; } public string Description { get; set; } public List&lt;string&gt; Photos { get; set; } public List&lt;string&gt; Regions { get; set; } } </code></pre> <p>I tried and read the CSV file using this code:</p> <pre><code>namespace ConsoleApplication2 { class Program { static void Main(string[] args) { CsvHelperRead(); Console.Read(); } private static void CsvHelperRead() { CsvConfiguration config = new CsvConfiguration(); config.HasHeaderRecord = false; using (var reader = new CsvReader(new StreamReader(@"C:\Users\afshandc\Desktop\0729\vTest.csv"), config)) { while (reader.Read()) { Console.WriteLine(reader.GetField(1)); } } } } } </code></pre> <p>I need to read the CSV file and drop it to this list.</p> <pre><code> class CSV { public List&lt;Vehicle&gt; ReadVechileCSV() { } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAdel Khayata
    1. USDrek John
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POGet,Set using Lists in C# ...Help Needed
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POGet,Set using Lists in C# ...Help Needed
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POGet,Set using Lists in C# ...Help Needed
      1. This table or related slice is empty.
      1. VTDownMod
    1. COYour post missing section where you describe problem you have writing the code. So far there are only vague requirements...
      singulars
      1. POGet,Set using Lists in C# ...Help Needed
      1. USAlexei Levenkov
    2. COI would advice you first to use `""data1"",""data2""` in your CSV, I think your description will contain commas in the future and that will corrupt your records. Then you can trust on other solutions like suggested by @No Idea For Name
      singulars
      1. POGet,Set using Lists in C# ...Help Needed
      1. USglautrou
    3. CO_Off-topic:_ your `Vehicle` has too much strings while respective data-types exist in C#. Basically, while creating this kind of applications it's always a good idea to have some helper utility that hides this ugly parsing at the top level of application.
      singulars
      1. POGet,Set using Lists in C# ...Help Needed
      1. USLeri
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload