Help with JSON file reading

Question

1.00/5 (2 votes)

See more:

I have this json file located in my Assets/Dec1.js .
How can i make it appear in my textblock?
When i run it in the emulator it shows "This" instead of showing the content in the Assets/Dec1.js

xaml

HTML

<ScrollViewer>
                <TextBlock x:Name="textblock" TextWrapping="Wrap" Foreground="White"/>
            </ScrollViewer>

xaml.cs

C#

//JSON starts here
public string ReadJsonFile(string JsonfilePath)
{
    string strText = "This";

    using (StreamReader r = new StreamReader("Assets/Dec1.js"))
    {

        string json = r.ReadToEnd();
        dynamic array = JsonConvert.DeserializeObject(json);
        //... read text from json file


    }

    return strText;

}

//Daily Devotion starts here
protected override void OnNavigatedTo(NavigationEventArgs e)
{

    AddDevotions();
    int index = DateTime.Now.DayOfYear;
    textblock.Text = devotions[index];
}

List<String> devotions = new List<string>();
private void AddDevotions()
{
devotions.Add(ReadJsonFile("Assets/Dec1.js"));
    devotions.Add(ReadJsonFile("Assets/Dec1.js"));
    devotions.Add(ReadJsonFile("Assets/Dec1.js"));
    }

Thank you in advance and reply soon

Posted 16-Jan-15 3:37am

Member 10627743

Updated 16-Jan-15 5:17am

CPallini

v3

Add a Solution

Comments

Afzaal Ahmad Zeeshan 16-Jan-15 10:24am

.js is not a JSON file brother, it is a JavaScript script file. You should change that to .json.

Member 10627743 16-Jan-15 10:41am

When i changed the file to .json this is the error given "An exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.ni.dll but was not handled in user code

If there is a handler for this exception, the program may be safely continued."

Kindly proffer a solution

Thank you

Afzaal Ahmad Zeeshan 16-Jan-15 10:56am

That is because you are required to change the File name in the Code too...

Member 10627743 16-Jan-15 11:07am

Hi Afzaal Ahmad Zeeshan

Sorry to bother you, i have changed all the extension see the code below

xaml.cs
//JSON starts here
public string ReadJsonFile(string JsonfilePath)
{
string strText = "This";

using (StreamReader r = new StreamReader("Assets/Dec1.json"))
{

string json = r.ReadToEnd();
dynamic array = JsonConvert.DeserializeObject(json);
//... read text from json file

}

return strText;

}

//Daily Devotion starts here
protected override void OnNavigatedTo(NavigationEventArgs e)
{

AddDevotions();
int index = DateTime.Now.DayOfYear;
textblock.Text = devotions[index];
}

List<string> devotions = new List<string>();
private void AddDevotions()
{
devotions.Add(ReadJsonFile("Assets/Dec1.json"));
devotions.Add(ReadJsonFile("Assets/Dec1.json"));
devotions.Add(ReadJsonFile("Assets/Dec1.json"));
}

What else am i doing wrong kindly help

Afzaal Ahmad Zeeshan 16-Jan-15 11:09am

So, what is the error here now? Can you share that error also?

Member 10627743 16-Jan-15 11:32am

Hi
I am new to working with json kindly read
Let me tell you what i wanted to acheive. I am developing a daily devotional that has different devotion for each day. Instead of hard coding it i.e copy pasting for each day in the code, i want to store everything in json file in my project folder and refference it to appear in the textblock. Kiindly help this is my code without json reader or stream reader and how am i going to add json reader or stream reader into this code below

xaml

xaml
<scrollviewer>
<textblock x:name="textblock" textwrapping="Wrap" foreground="White">

xaml.cs
protected override void OnNavigatedTo(NavigationEventArgs e)
{
AddDevotions();
int index = DateTime.Now.DayOfYear;
textblock.Text = devotions[index];
}
List<string> devotions = new List<string>();
private void AddDevotions()
{
devotions.Add("4 Faith works miracles");
devotions.Add("5 Faith works miracles");
devotions.Add("6 Faith works miracles");
devotions.Add("7 Faith works miracles");
devotions.Add("8 Faith works miracles");
}

Thank you in advance and reply soon

Afzaal Ahmad Zeeshan 16-Jan-15 12:01pm

Please see my answer to your question, you might need to understand the JSON notation, and the API you're using (Newtonsoft.Json). I have tried to explain a little, if you need more help please ask me under the answer. Also, have a look at the linked URLs.

Thanks.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Afzaal Ahmad Zeeshan · Answer 1 · 2015-01-16T05:59:00

Working with JSON data in a file is just as reading the file resource, and then in the JSON file you just deserialize the data to create an object of that data, it can be anonymous or, you can create a special (custom) class for working with data coming through the file. Supposing that you're going to store the data for Daily data. You can create a class as,

C#

class Devotion {
   public int DevotionID { get; set; }
   public int DevotionLabel { get; set; }
   // all other properties
}

.. then you can use the Newtonsoft.JSON API to create the JSON notation for the data. For example, to read the objects, you should create a list of these objects as,

C#

string jsonData = File.ReadAllText("/file.json"); // or that r.ReadToEnd()
List<devotion> devotions = new List<devotion>();
// make sure that the data in file starts with [ and ends at ]; because of List object
devotions = JsonConvert.DeserializeObject<list><devotion>>(jsonData);
</devotion></list></devotion></devotion>

Now the devotions objects is an enumerable containing all of your daily devotions. You can use a foreach loop, to use each of these objects and write their values in TextBlock. Same method is used to save the values in the JSON file.

You can learn more from these...

JSON Serialization Using Newtonsoft JSON Serialize[^]

Documentation of JSON.NET[^]