Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Don't use a <code>.Split()</code> function to read your csv data. Not only does it cause the kind of error you just ran into but it's slower as well. You need a <em>state machine</em> -based parser. That will be faster and make it easier to correctly handle quote-enclosed text.</p> <p>I have an example here:<br> <a href="https://stackoverflow.com/questions/1544721/reading-csv-files-in-c/1544743#1544743">Reading CSV files in C#</a></p> <p>and there's also a highly-respected CSV reader on codeplex you can use:<br> <a href="http://www.codeproject.com/KB/database/CsvReader.aspx" rel="nofollow noreferrer">http://www.codeproject.com/KB/database/CsvReader.aspx</a></p> <hr> <p>You'd use my code like this:</p> <pre><code>Function DataTableFromCSV(ByVal filename As String) As DataTable Dim table As New DataTable Dim colAdded As Boolean = False For Each record As IList(Of String) In CSV.FromFile(filename) ''# Add column headers on first iteration If Not colAdded Then For Each token As String In record table.Columns.Add(token) Next token colAdded = True Else ''# add the row to the table Dim row As DataRow = table.NewRow() For i As Integer = 0 To table.Columns.Count - 1 row(i) = record(i) Next table.Rows.Add(row) End If Next record Return table End Function </code></pre> <p>If you're using .net 3.5 or later, I'd write it a little differently to pull the column creation out of the for each loop (using type inference and <code>.Take(1)</code> ), but I wanted to be sure this would work with .Net 2.0 as well. </p>
    singulars
    1. This table or related slice is empty.
    1. POAdding a Way To preserve A Comma In A CSV To DataTable Function
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USJoel Coehoorn
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POAdding a Way To preserve A Comma In A CSV To DataTable Function
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COJoel is there no easy way to fix my code to account for this. I dont want to start over and I dont want to use any open source dll either
      singulars
      1. PO
      1. USNick LaMarca
    2. COIt is technically possible to re-write the regular expression to account for your quote-enclosed text. However, this will not be a simple regex. Whenever you have nested components to a regex (ie, commas inside quotes) you should start to look at alternatives. In this case, because you can guarantee you're only nesting one level deep a regex is still possible, but it's not going to be a trivial expression. You'll likely find it easier to move to state-machine based code, especially as that code will be faster and is already written for you. Don't succumb to NIH.
      singulars
      1. PO
      1. USJoel Coehoorn
    3. COOne more note: the nice thing about open source is you don't have to use a dll. You can include the code in your project directly. If you don't like the license of the code project link, my code will work and won't encumber your project. In fact, you should read the other answers to the same question. You might be able to use the Microsoft.VisualBasic.FileIO.TextFieldParser answer, for example.
      singulars
      1. PO
      1. USJoel Coehoorn
 

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