Problem with StringBuilder and JSON

Question

I am trying to execute this code in C#.NET to turn an SQL table into a string with proper JSON;

json.AppendFormat("Places: [{{\"AvgDate\": \"{0}\"},\"MarkerID\": \"{1}\"}]", reader["AvgDate"], reader["MarkerID"]);

However it won't let me use the comma separation between the {0} and {1} indexes. The following works fine;

json.AppendFormat("Places: [{{\"AvgDate\": \"{0}\"}]", reader["AvgDate"], reader["MarkerID"]);

What am I doing wrong?

Nick Craver · Accepted Answer · 2010-02-22 22:07:18Z

3

Closing braces must also be doubled in a format string:

json.AppendFormat("Places: [{{\"AvgDate\": \"{0}\"}},\"MarkerID\": \"{1}\"}]", reader["AvgDate"], reader["MarkerID"]);

Notice the }} after AvgDate:

answered Feb 22, 2010 at 22:07

Nick Craver

631k138 gold badges1.3k silver badges1.2k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jerod Venema · Accepted Answer · 2010-02-22 22:08:42Z

2

You've got a missing } in there...not sure if that's your exact problem, but its a problem....

answered Feb 22, 2010 at 22:08

Jerod Venema

44.7k5 gold badges70 silver badges109 bronze badges