Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Your question is a little vague, but I'll try and answer it as best I can.</p> <p>A CSV file is (by definition) a file containing comma seperated values - the key here is that a comma is used as the delimiter. Personally, I find that using a different delimiter is prone to less nasties when parsing.</p> <p>I've created the following test CSV file:</p> <pre><code>Column1,Column2,Column3,Column4 Row1Value1,Row1Value2,Row1Value3,Row1Value4 Row2Value1,Row2Value2,Row2Value3,Row2Value4 Row3Value1,Row3Value2,Row3Value3,Row3Value4 Row4Value1,Row4Value2,Row4Value3,Row4Value4 Row5Value1,Row5Value2,Row5Value3,Row5Value4 </code></pre> <p>Here's some code to read that file into some simple structures that you can then manipulate. You might want to extend this code by creating classes for the columns and rows (and values as well).</p> <pre><code> string sFileContents = ""; using (StreamReader oStreamReader = new StreamReader(File.OpenRead("Test.csv"))) { sFileContents = oStreamReader.ReadToEnd(); } List&lt;string[]&gt; oCsvList = new List&lt;string[]&gt;(); string[] sFileLines = sFileContents.Split(Environment.NewLine.ToCharArray(), StringSplitOptions.RemoveEmptyEntries); foreach (string sFileLine in sFileLines) { oCsvList.Add(sFileLine.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries)); } int iColumnNumber = 0; int iRowNumber = 0; Console.WriteLine("Column{0}, Row{1} = \"{2}\"", iColumnNumber, iRowNumber, oCsvList[iColumnNumber][iRowNumber]); iColumnNumber = 4; iRowNumber = 2; Console.WriteLine("Column{0}, Row{1} = \"{2}\"", iColumnNumber, iRowNumber, oCsvList[iColumnNumber][iRowNumber]); </code></pre> <p>Keep in mind that values are accessed by the column number, and then the row number.</p> <p>I hope this helps.</p>
    singulars
    1. This table or related slice is empty.
    1. PORead a CSV file in to an array using C#
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USRastus7
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PORead a CSV file in to an array using C#
      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
    1. COThis is what my csv looks like. I want to pull each line in to an an array that has 1 (the atomic number) and 1.007.... (the atmoic mass) all separately callable. Im trying to put together a periodic table of sorts. 1,1.0079400000,Hydrogen,H 2,4.0026020000,Helium,He 3,6.9410000000,Lithium,Li 4,9.0121820000,Beryllium,Be
      singulars
      1. PO
      1. USrreichel
    2. COThere is a new line started after each atomic symbol.
      singulars
      1. PO
      1. USrreichel
    3. COAlright, I just attempted to implement your block of code and it didn't give me any errors, however I am not able to call the array list name (oCsvList) from outside of the reading (specifically trying to call it from a for loop.
      singulars
      1. PO
      1. USrreichel
 

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