Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>How about <a href="http://msdn.microsoft.com/en-us/library/system.web.script.serialization.javascriptserializer.aspx" rel="nofollow">JavaScriptSerializer</a>? Nice integrated solution, allowed to be expanded upon with <a href="http://msdn.microsoft.com/en-us/library/system.web.script.serialization.javascriptconverter.aspx" rel="nofollow">JavaScriptConverter</a>s.</p> <hr> <p>Demo of what you were after:</p> <pre><code>using System; using System.Web.Script.Serialization; using System.Text; public class Stop { public String place { get; set; } public Int32 KMs { get; set; } } public class Trip { public String from { get; set; } public String to { get; set; } public Stop[] stops { get; set; } } public class MyJSONObject { public Trip[] Trips { get; set; } public override String ToString() { StringBuilder sb = new StringBuilder(); foreach (Trip trip in this.Trips) { sb.AppendFormat("Trip:\r\n"); sb.AppendFormat("\t To: {0}\r\n", trip.to); sb.AppendFormat("\t From: {0}\r\n", trip.from); sb.AppendFormat("\tStops:\r\n"); foreach (Stop stop in trip.stops) { sb.AppendFormat("\t\tPlace: {0}\r\n", stop.place); sb.AppendFormat("\t\t KMs: {0}\r\n", stop.KMs); } sb.AppendLine(); } return sb.ToString(); } } public class Test { public static void Main() { String example = "{\"Trips\":[{\"from\":\"here\",\"to\":\"there\",\"stops\":[{\"place\":\"middle1\",\"KMs\":37},{\"place\":\"middle2\",\"KMs\":54}]},{\"from\":\"there\",\"to\":\"here\",\"stops\":[{\"place\":\"middle2\",\"KMs\":37},{\"place\":\"middle1\",\"KMs\":54}]}]}"; JavaScriptSerializer serializer = new JavaScriptSerializer(); // Parse the string to our custom object MyJSONObject result = serializer.Deserialize&lt;MyJSONObject&gt;(example); Console.WriteLine("Object deserialized:\r\n\r\n{0}\r\n\r\n", result); // take our custom object and dump it in to a string StringBuilder sb = new StringBuilder(); serializer.Serialize(result, sb); Console.WriteLine("Object re-serialized:\r\n\r\n{0}\r\n\r\n", sb); // check step Console.WriteLine(example.Equals(sb.ToString()) ? "MATCH" : "NO match"); } } </code></pre> <p>And the output:</p> <pre><code>Object deserialized: Trip: To: there From: here Stops: Place: middle1 KMs: 37 Place: middle2 KMs: 54 Trip: To: here From: there Stops: Place: middle2 KMs: 37 Place: middle1 KMs: 54 Object re-serialized: {"Trips":[{"from":"here","to":"there","stops":[{"place":"middle1","KMs":37},{"pl ace":"middle2","KMs":54}]},{"from":"there","to":"here","stops":[{"place":"middle 2","KMs":37},{"place":"middle1","KMs":54}]}]} MATCH Press any key to continue . . . </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POJSON in C# (preferably without third-party tools)
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USBrad Christie
    1. USBrad Christie
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POJSON in C# (preferably without third-party tools)
      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
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThis seem like the exact thing I needed. I have no idea how I missed it! Thank you so much.
      singulars
      1. PO
      1. USHejner
    2. CO@Hejner: I've added a demo for you if you're interested...
      singulars
      1. PO
      1. USBrad Christie
 

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