Convert string builder to json

Question

0.00/5 (No votes)

See more:

Hi
I have created json string using string builder and now i want to convert it to json using json.net without the use of classes.I have given example below.

Thanks in advance.

SqlCommand cmd = new SqlCommand("SELECT tcjc_ID, tcjc_JobCode, tcjc_Name, tcjc_JobDesc1 + tcjc_JobDesc2 + tcjc_JobDesc3, tco_Company_Name, tsi_Site_Name FROM tbl_CreateJobCosting LEFT JOIN tbl_Companies ON tcjc_CompanyId = tco_CompanyId LEFT JOIN tbl_Sites ON tcjc_SiteId = tsi_SiteID WHERE tcjc_ID = " + jobId, con);
sb.Append("{ \"jobId\":\"");
sb.Append(jobId);
sb.Append("\",");
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
sb.Append("\"jobcode\":\"");
sb.Append(reader.GetInt32(1));
sb.Append("\", \"name\":\"");
sb.Append(reader.GetString(2));
sb.Append("\", \"desc\":\"");
sb.Append(reader.GetString(3));
sb.Append("\", \"company\":\"");
sb.Append(reader.GetString(4));
sb.Append("\", \"site\":\"");
sb.Append(reader.GetString(5));
}

Posted 7-Apr-13 21:17pm

NeerajRathi

Add a Solution

Comments

Anurag Sinha V 8-Apr-13 3:36am

So, where are you stuck??

Prasad Khandekar 8-Apr-13 15:41pm

Hello Neeraj,

i want to convert it to json using json.net without the use of classes, is like saying Unless I learn to swim I won't get into the water. Json.Net is a library which allows you to work with JSON data structure and it also provides de/serialization services for converting object into JSON format and vice versa.

Any way without using the classes you have created the JSON string. So where is the problem?

NeerajRathi 9-Apr-13 0:53am

Hi Prasad
Thanks for suggestion.I have solve the problem using Json.Net.

Thanks
Neeraj

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)

Sandeep Singh Shekhawat · Answer 1 · 2014-12-09T00:55:00

Yes, I know its too late, but it would be helpful whenever next one come to find his solution. My solution is convert your data in json string format like:

C#

Dictionary<string,> myValues = new Dictionary<string,>();
            myValues.Add("one", "1");
            myValues.Add("two", "2");
            myValues.Add("three", "3");

            StringBuilder sb = new StringBuilder();
            sb.Append("{");

            bool first = true;

            foreach (string k in myValues.Keys)
            {
                if (!first)
                {
                    sb.Append(",");
                }
                sb.AppendFormat("\"{0}\":\"{1}\"", k, myValues[k]);
                first = false;
            }

            sb.Append("}");