Read and parse a Json File in C#

I have spent the best part of two days “faffing” about with code samples and etc., trying to read a very large JSON file into an array in c# so I can later split it up into a 2d array for processing.

The problem I was having was I could not find any examples of people doing what I was trying to do. This meant I was just editing code a little an hoping for the best.

I have managed to get something working that will:

  • Read the file Miss out headers and only read values into array.
  • Place a certain amount of values on each line of an array. (So I could later split it an put into 2d array)

This was done with the code below but it crashes the program after entering a few lines into the array. This might have to do with the file size.

// If the file extension was a jave file the following 
// load method will be use else it will move on to the 
// next else if statement
if (fileExtension == ".json") 
{
    int count = 0;
    int count2 = 0;
    int inOrOut = 0;
    int nRecords=1; 
    JsonTextReader reader = new JsonTextReader(new StreamReader(txtLoaction.Text));
    string[] rawData = new string[5];
    while (reader.Read())
    {
        if (reader.Value != null)
            if (inOrOut == 1)
            {
                if (count == 6)
                {
                    nRecords++;
                    Array.Resize(ref rawData, nRecords);
                    //textBox1.Text += "\r\n";
                    count = 0;
                }
                rawData[count2] += reader.Value + ","; //+"\r\n"
                inOrOut = 0;
                count++;
                if (count2 == 500)
                {
                    MessageBox.Show(rawData[499]);
                }
            }
            else
            {
                inOrOut = 1;
            }
    } 
}

A snippet of the JSON I am working with is:

[ 
    { "millis": "1000", 
      "stamp": "1273010254", 
      "datetime": "2010/5/4 21:57:34", 
      "light": "333", 
      "temp": "78.32", 
      "vcc": "3.54" }, 
]

I need the values out of this JSON. For example, I need “3.54”, but I would not want it to print the “vcc”.

I am hoping someone can show me how to read a JSON file in and only extract the data that I need and put it into an array or something that I can use to later put into an array.

Related Posts:

  1. How can I parse JSON with C#?
  2. Convert JSON String to JSON Object c#
  3. C# HttpClient An existing connection was forcibly closed by the remote host
  4. What is parsing?
  5. How to convert JSON to XML or XML to JSON?
  6. Deserialize JSON with C#
  7. Convert JSON String To C# Object
  8. How to convert code from C# to PHP
  9. IsNumeric function in c#
  10. Parse Json string in C#
  11. How to post JSON to a server using C#?
  12. JSON.NET Error Self referencing loop detected for type
  13. Unexpected character encountered while parsing value
  14. What is IP address ‘::1’?
  15. How to parse data in JSON format?
  16. What is the yield keyword used for in C#?
  17. Join/Where with LINQ and Lambda
  18. C# compiler error: “not all code paths return a value”
  19. C# equivalent of C++ map
  20. The page was not displayed because the request entity is too large on IIS
  21. Export Pervasive to MySQL (C#)
  22. Why use the params keyword?
  23. What does plus equals(+=) operator means here?
  24. Unity cannot convert from ‘string’ to ‘int’
  25. The request was aborted: Could not create SSL/TLS secure channel
  26. The request was aborted: Could not create SSL/TLS secure channel
  27. finding the maximum length of lists in c#
  28. How to convert jsonString to JSONObject in Java
  29. The located assembly’s manifest definition does not match the assembly reference
  30. OnTriggerEnter not working at Unity3D
  31. The requested resource does not support HTTP method ‘GET’
  32. Rename a file in C#
  33. What does mscorlib stand for?
  34. What is the best way to iterate over a dictionary?
  35. Does not contain a static ‘main’ method suitable for an entry point
  36. Checking if an object is null in C#
  37. How to use Global Variables in C#?
  38. Unity3d no Monobehaviour scripts in the file, or their names don’t match the file name
  39. What is and how to fix System.TypeInitializationException error?
  40. Adding values to a C# array
  41. Reading settings from app.config or web.config in .NET
  42. How to initialize a list of strings (List) with many string values
  43. What does {0} mean when found in a string in C#?
  44. Collection was modified; enumeration operation may not execute
  45. How to use html.ValidationMessageFor
  46. EF 5 Enable-Migrations : No context type was found in the assembly
  47. Visual studio 2019 freezes when debugging
  48. How to make an HTTP POST web request
  49. How to easily initialize a list of Tuples?
  50. How do I target @Model within a src of an image tag?
  51. How to round up in c#
  52. Converting from IEnumerable to List
  53. Escape double quotes in a string
  54. Specified cast is not valid?
  55. Get int value from enum in C#
  56. How to do constructor chaining in C#
  57. “Too many characters in character literal error”
  58. Is dependency injection useful in C++
  59. What represents a double in sql server?
  60. How do you get the index of the current iteration of a foreach loop?
  61. Expression denotes a `type’, where a `variable’, `value’ or `method group’ was expected UNITY3D
  62. How do I restart my C# WinForm Application?
  63. WSACancelBlockingCall exception
  64. Padding is invalid and cannot be removed?
  65. Why is it that “No HTTP resource was found that matches the request URI” here?
  66. Best way to reverse a string
  67. C# Foreach statement does not contain public definition for GetEnumerator
  68. “Invalid JSON primitive” in Ajax processing
  69. I got error “The DELETE statement conflicted with the REFERENCE constraint”
  70. Non-invocable member cannot be used like a method?
  71. How do I exit a foreach loop in C#?
  72. How can I know if a process is running?
  73. Fastest way to remove first char in a String
  74. How to convert datetime format to date format in crystal report using C#?
  75. Most efficient way to remove special characters from string
  76. When do we use ANTLR
  77. How to convert UTF-8 byte[] to string
  78. How would you count occurrences of a string (actually a char) within a string?
  79. Socket.Select returns error “An operation was attempted on something that is not a socket”
  80. Get dictionary key by value
  81. Convert from List into IEnumerable format
  82. How do I exit from a function?
  83. Rotate object in Unity 3D
  84. Using OpenGl with C#? [closed]
  85. C# equivalent to Java’s charAt()?
  86. How to play a sound in C#, .NET
  87. Convert SQL to LINQ Query
  88. How to resolve file being used by another process?
  89. How to crop an image using C#?
  90. How do you wait for input on the same Console.WriteLine() line?
  91. Why doesn’t C# have header files? Will the namespace take care of everything?
  92. How to avoid a System.Runtime.InteropServices.COMException?
  93. Define: What is a HashSet?
  94. Convert string to decimal, keeping fractions
  95. “A namespace cannot directly contain members such as fields or methods”
  96. Format of the initialization string does not conform to specification starting at index 0
  97. How can I generate random alphanumeric strings?
  98. How do you do a deep copy of an object in .NET? 
  99. Cannot declare instance members in a static class in C#
  100. How to convert HTML to PDF using iTextSharp

Leave a Comment