How do I insert new json data in a text file

Question

0.00/5 (No votes)

See more:

i have read the text file i need to insert a new data in the text file
this is the method i have read the text file

C#

try

            {

                var path = @"text file\\GetAllEmp.txt";
                

                string rawJson = File.ReadAllText(path, Encoding.UTF8);

                ObservableCollection<EmployeeItem> Employee = new ObservableCollection<EmployeeItem>();
                var jsonData = JsonConvert.SerializeObject(rawJson);

                List<EmployeeItem> emp = JsonConvert.DeserializeObject<List<EmployeeItem>>(rawJson);

                listitem.ItemsSource = emp;

What I have tried:

i just new to add new data in the text file
how to add new data

My data base contains

C#

public static void AddEmployee(EmployeeItem Employee)
{
    string dbpath = Path.Combine(ApplicationData.Current.LocalFolder.Path, "chillDatabase.db");
    using (SqliteConnection db =
      new SqliteConnection($"Filename={dbpath}"))
    {
        db.Open();

        SqliteCommand insertCommand = new SqliteCommand();
        insertCommand.Connection = db;

        insertCommand.CommandText = "INSERT or REPLACE INTO SiteInfoTable VALUES (@EMP_SITEID, @EMP_GroupID, @EMP_ID,)";

        insertCommand.Parameters.AddWithValue("@EMP_SITEID ", Employee.SiteID);
        insertCommand.Parameters.AddWithValue("@EMP_GroupID ", Employee.GroupID);
        insertCommand.Parameters.AddWithValue("@EMP_ID ", Employee.Id);



        try
        {
            insertCommand.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message);
        }
    }

Posted 27-Nov-22 19:49pm

Ailiseu Brigitta

Updated 28-Nov-22 4:54am

PIEBALDconsult

v3

Add a Solution

Comments

pkfox 28-Nov-22 9:46am

Now you have your data in a database you can do what you like with it - what is the problem ?

Richard Deeming 29-Nov-22 4:20am

catch (Exception ex)
{
    throw new Exception(ex.Message);
}

Seriously, don't do that! You've just thrown away any information you could possibly use to diagnose the exception.

If you need to throw a different exception type, then pass the exception you caught as the inner exception, and use a more specific type than the base Exception class:

catch (Exception ex)
{
    throw new InvalidOperationException(ex.Message, ex);
}

If you want to re-throw the original exception, then use throw; instead of throw ex;:

catch (Exception ex)
{
    throw;
}

But since you're not actually doing anything with the exception, then there's no point in catching it in the first place. Just remove the try..catch block, and let the exception propagate normally.

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)

OriginalGriff · Answer 1 · 2022-11-27T20:00:00

THe only practical way to add data to a JSON file is to add it to the objects(s) you read from the file into your application, then write a new file that includes the old data.

JSON is not a database, it's a data transfer format - and it isn't organised in a way that makes "adding rows" or "adding columns" simple. If you regularly want to change JSON, you are probably better off using a database instead.

Quote:
there is no way to insert a new object? is there is othere way to insert a data

JSON files are text, just that: they aren't structured data until you read them with software the "understands" JSON.

And text files don't insert *anything* the only way to insert even a single character into a text file is to read all the characters up to the insertion point while writing them to a second file, write the new character to the second file, then copy all the other characters over.
When you have finished doing that, you close both the files, delete the original, and rename the new file to the old name.

That's a PITA with text, but with JSON data in a file it's worse, because it's structured in a way that JSON apps can understand and humans (with training) can read but not in a way that means it's easy to do as there is no way to tell where any object in the data starts or ends unless you read and process the JSON data as you go to find the end of the object to want to add something after! Which means ... your app needs to understand JSON extremely well in code you have written to do that as well as how to insert strings into text files!

If you want to insert (or update- or delete-) objects into existing data regularly, don't use JSON: use a proper database where the file format and the library code to handle it is designed to make that both easy and reliable.