Extracting a node from Json File in C# - C# Discussion Boards

ormonds27-Dec-17 20:59

27-Dec-17 20:59

I am new to C# (using VS 2017 CE) and have a Windows Forms App in which I would like to use MessageBoxManager.
The .DLL is present and correct in my solution, showing under References in the same manner as another .DLL which works fine.
I thought that I needed to add a "using MessageBoxManager" to my project, but when I do I get the error:
CS0246 The type or namespace "MessageBoxManager" could not be found (are you missing a using directive or an assembly reference?
If I remove the "using" line I get no error and the code runs fine, ignoring all lines such as:-

MessageBoxManager.Yes = "Yes/Oo";
MessageBoxManager.No = "No/Hindi";
MessageBoxManager.Unregister();

I suspect I am missing some elementary understanding, can anyone help me?

Re: MessageBoxManager .dll using

Pete O'Hanlon27-Dec-17 22:02

Pete O'Hanlon

27-Dec-17 22:02

using MessageBoxManager; states that you expect that the namespace that your MessageBoxManager class is in has to be called MessageBoxManager. This cannot be the case because you cannot declare a class and namespace with the same name; .NET doesn't allow this. If you use the Object Browser View > Object Broswer, you should be able to search for MessageBoxManager. When you find it, it will tell you which namespace it is actually in. If you then look in your code, I suspect you'll find that you already have that using statement in place.

This space for rent

Re: MessageBoxManager .dll using

ormonds28-Dec-17 9:56

ormonds

28-Dec-17 9:56

That's it, thank you for your answer.

Re: MessageBoxManager .dll using

BillWoodruff29-Dec-17 14:51

BillWoodruff

29-Dec-17 14:51

Pete O'Hanlon wrote:
you cannot declare a class and namespace with the same name;

I respectfully suggest this is a case where C# (VS 2017, 4.7.1, Debug, error check level #4) ... still ... lets you "get away with murder:" this will compile and run:

namespace SomeClass // a Project added to a WinForm app
{
    public class SomeClass
    {
        public int I { get; }
        public string S { get; }

        public SomeClass(int i, string s)
        {
            I = i;
            S = s;
        }
    }
}

// invoked in the WinForm app NameSpace;
// using SomeClass;

// sample call
// SomeClass.SomeClass dc = new SomeClass.SomeClass(100,"ddd");

The user is seeing an ambiguous reference exception because he has not dot-qualified his call. imho, the C# compiler should never allow this ! I;m surprised ReSharper doesn't red-line this.

Happy New Year !

«While I complain of being able to see only a shadow of the past, I may be insensitive to reality as it is now, since I'm not at a stage of development where I'm capable of seeing it.» Claude Levi-Strauss (Tristes Tropiques, 1955)

modified 29-Dec-17 20:58pm.

Re: MessageBoxManager .dll using

BillWoodruff29-Dec-17 14:56

BillWoodruff

29-Dec-17 14:56

See my explanation of why your code does not work in my response to Pete O'Hanlon on this thread. I think you may be surprised by what you learn.

A NameSpace with a Class (or anything else) with the same name inside it is a bad practice that will cause problems.

Issue while parsing HTML string in C#

Mateen1127-Dec-17 18:59

Mateen11

27-Dec-17 18:59

Hi,

HTML string as a JSON output.

Facing issue with the HTML string: String has HTML tags and text.

Actual string - There are HTML tags and text. In <span> tag there is id with double quotes, and there is text "since the 1500s" which also has double quotes.

<p>Lorem Ipsum is simply dummy text of the printing <span id="#" ids="#" display="inline"></span> and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever "since the 1500s".<br></p>

Expected string - All double quotes in the HTML tags should be converted into single quote but the text quotes should be as it is.

"<p>Lorem Ipsum is simply dummy text of the printing <span id='#' ids='#' display='inline'></span> and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever \"since the 1500s\".</p>"

Re: Issue while parsing HTML string in C#

OriginalGriff27-Dec-17 20:05

OriginalGriff

27-Dec-17 20:05

Try a (complicated) regex:

public static Regex regex = new Regex(
      "\"+(?=[^<]*?>)",
    RegexOptions.Multiline
    | RegexOptions.Singleline
    | RegexOptions.CultureInvariant
    | RegexOptions.Compiled
    );
...
string result = regex.Replace(InputText,"'");

Get a copy of Expresso[^] - it's free, and it examines and generates Regular expressions. It helped me create and test that, then generated the C# code automatically.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

Extracting a node from Json File in C#

Sandeep Vemulapalli27-Dec-17 11:10

Sandeep Vemulapalli

27-Dec-17 11:10

Hey Guys,

Hope you guys are doing great! I have one question kind of stuck there. In the JSON File, I would like to extract the data from the node. Say like I wanted to extract the book node or value which is within goods node. Here is my JSON file.

{"store": [
{
    "name": "Sunshine Department Store",
    "address": "Wangfujing Street",
    "goods": {
        "book": [
            {
                "category": "Reference",
                "title": "Sayings of the Century",
                "author": "Nigel Rees",
                "price": 8.88
            },
            {
                "category": "Fiction",
                "title": "Sword of Honour",
                "author": "Evelyn Waugh",
                "price": 12.66
            }
        ],
        "bicycle": {
            "type": "GIANT OCR2600",
            "color": "White",
            "price": 276
        }
    }
}
]
}

Here is my code

private string ParseBookNode(JObject bookJSONFile)
        {
            JArray bookJson = null;
            string bookFarmNode = null;
            if (bookJSONFile != null && bookJSONFile["store"] != null)
            {
                bookJson = (JArray)bookJSONFile["store"];
                bookFarmNode = bookJson[0].ToString();

                if (bookJSONFile["book"] != null)
                {
                    bookJson = (JArray)bookJSONFile["book"];
                    bookFarmNode = bookJson[0].ToString();
                }
            }
            else
            {
                throw new Exception("Book node not found.");
            }
            return bookFarmNode;
        }

How I can able to extract data along this lines??

if (bookJSONFile["book"] != null)
                {
                    bookJson = (JArray)bookJSONFile["book"];
                    bookFarmNode = bookJson[0].ToString();
                }

Re: Extracting a node from Json File in C#

Nathan Minier28-Dec-17 1:52

Nathan Minier

28-Dec-17 1:52

You will find that life will be much, much easier if you write container classes for these JSON objects and deserialize directly into instances of those objects. It'll also help you handle these items as strongly-typed objects in your code. I can tell you've done a bit of XML handling in the past, and it's just a different way of handling it.

public abstract class Product
{
   public decimal Price { get; set; }
}

public class Book : Product
{
   public string Category { get; set; } // This could be a relationship or enum
   public string Title { get; set; }
   public string Author { get; set; }
}

public class Bicycle : Product
{
   public string Type { get; set; } //this would be a good spot for an entity relationship
   public string Color { get; set; } // This could be a relationship or enum

}

public class Store
{
   public string Name { get; set; } 
   public string Address { get; set; }
   public Dictionary<string,List<Product>> Goods { get; set; }

   public Store()
   {
      Goods = new Dictionary<string,List<Product>>();
   }
}

There are a couple of ways to handle the "goods" collection, but this is the easiest and should work with JSON.Net out of the box. How you obtain your object can vary a little, but parsing it directly from the original stream is preferable just for efficiency:

public Store GetStoreInventory(string fileName)
{
   using(var jsonFile = new FileStream(fileName))
   {
      using(var reader = new StreamReader(jsonFile))
      {
         return JsonConvert.DeserializeObject<Store>(reader.ReadToEnd());
      }
   }
}

From here you can handle the data just like you would any normal .NET CLR type, i.e.

var store = GetStoreInventory(FILEPATH);
var firstBook = store.Goods["book"].FirstOrDefault();

The only "gotcha" is that the JSON.NET deserialize does not play nicely with interfaces, so use abstract classes instead (hence Product rather than IProduct).

"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli

C # + Regex help (for a newbie)

Damian Bz27-Dec-17 4:16

Damian Bz

27-Dec-17 4:16

Hi All,
I have just started to self learn C#, and have written my first basic application.

It is pretty simple,it has 8 text boxes that accept numerical values, which it then does some calculations on and displays 3 textbox outputs.

I worked out the calculations using Excel then translated that into C# and it all works ! as long as no one puts the wrong numbers in !

What I am trying to achieve is to validate four types of inputs:

One set of text boxes can accept whole numbers and no letters from 1 to 1000
One set of text boxes can accept whole numbers and no letters from 1 to 100

On these two types of textboxes, I have this code:

private void totalsize_TextChanged(object sender, EventArgs e)
{
    if (System.Text.RegularExpressions.Regex.IsMatch(totalsize.Text, "[^0-9]"))
    {
        MessageBox.Show("Please enter only full numbers i.e. 70  NOT  65.5");
        totalsize.Text = totalsize.Text.Remove(totalsize.Text.Length - 1);
        totalsize.Focus();
    }
}

From what I understand the regex is basically checking that the first character is not non numerical, so it sort of does one part of what I needed it to do.

I then have another input that I want to be able to validate: numbers only again, but only allow a single number with a single decimal point i.e. 7.2 3.6 but not 7.22222 or 70 so anything from 1 to 9 including a single decimal point.

private void nicstrength_TextChanged(object sender, EventArgs e)
{
        if (System.Text.RegularExpressions.Regex.IsMatch(nicstrength.Text, "insert jibberish here"))
        {
            MessageBox.Show("Please enter only numbers.");
            nicstrength.Text = nicstrength.Text.Remove(nicstrength.Text.Length - 1);
            nicstrength.Focus();
        }

    }

The last input I want to validate will be again numbers only but from 0.n to 2.n , so 0.6 or .6 - 1.2 or 2 (2 or above will probably not ever get entered)

private void finalnicstrength_TextChanged(object sender, EventArgs e)
{
    if (System.Text.RegularExpressions.Regex.IsMatch(finalnicstrength.Text, @"^[1-9]\d*(\.\d+)?$"))
    {
        MessageBox.Show("Please enter only numbers.");
        finalnicstrength.Text = finalnicstrength.Text.Remove(finalnicstrength.Text.Length - 1);
        finalnicstrength.Focus();
    }
}

I have tried zillions of combinations found on the net, plus I've used a couple of regex generators (frustratingly, some say a regex works and some say it doesn't - but none work when I put them into my code !)
I've learnt that I either need to put an @ in front of it, or use double \\ or whatever for C# to know what it is, but i'm just really struggling with this.
I am dyslexic (not looking for sympathy) so looking at regex makes my head explode !

Please can someone help me with the last two types at the very least, I know the top two are not 100% correct, but they at least stop letters and decimal points being entered.

Many thanks for reading, and even more for helping me ! Smile | :)

Damian