How to convert multiple data object into JSON string using C#?

Question

0.00/5 (No votes)

See more:

, +

hello,
I want to get convert multiple data object into JSON string using C#.
Like.. 1-I have a data table which I get from database using store procedure
and 2-I have a string("userType:1") like this.
I want to return both of data object (table and string) in my json String. How can I do it, Any Idea...?

here is my Code.

[WebMethod]
    [ScriptMethod(ResponseFormat = ResponseFormat.Json)]
    public string getLogin(string id, string password)
    {
        string json = "";
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString);
        try
        {
            con.Open();

            DataTable tblUserInfo = new DataTable();
            SqlDataAdapter da;
            da = new SqlDataAdapter("SP1_login ", con);
            da.SelectCommand.CommandType = CommandType.StoredProcedure;
            da.SelectCommand.Parameters.Add("@userId", SqlDbType.VarChar).Value = id;
            da.SelectCommand.Parameters.Add("@password", SqlDbType.VarChar).Value = password;
            da.SelectCommand.Parameters.Add("@retValue", System.Data.SqlDbType.Int).Direction = System.Data.ParameterDirection.ReturnValue;
            da.Fill(tblUserInfo);
            if (tblUserInfo.Rows.Count != 0)
            {   
                // Convert DataTable to JSON using JSON.Net DLL.         
                json = DataTableToJSONWithJSONNet(tblUserInfo);
            }
            else
            {
                string result = "2";
                json = new JavaScriptSerializer().Serialize(result);              
            }
        }
        catch (Exception ex)
        {
           
        }
        finally
        {
            con.Close();
        }
        return json;
    }

In above code JSON string contains Only data table

What I have tried:

I am trying to get data at user login.
I want return JSON such that I get login User Information that contain in table and another object is UserType like local user or Admin or any other.

At client side I want to get two data object in JSON string One is Data table and another one is UserType

Posted 9-Jan-17 19:31pm

Vikas Hire

Updated 9-Jan-17 22:47pm

Add a Solution

2 solutions

Solution 1

3 Ways to Convert DataTable to JSON String in ASP.NET C#[^]

Posted 9-Jan-17 21:08pm

#realJSOP

Comments

Vikas Hire 10-Jan-17 4:02am

Resp, John Simmons Your sol.n is not suitable for my problem, I already converted my table using third option that you suggest to me.

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)

virang_21 · Accepted Answer · 2017-01-09T22:47:00

Solution 2

If you are using JSON.NET you can call Merge on two JSON Objects.

JObject obj1 = JObject.Parse(@"{
  'field1': 'value1',
  'field2': 'value2'
}");
JObject obj2 = JObject.Parse(@"{
  'field3': 'somevalue'
}");

obj1.Merge(obj2, new JsonMergeSettings { MergeArrayHandling = MergeArrayHandling.Concat });

string json = obj1.ToString();

Posted 9-Jan-17 22:47pm

virang_21

Comments

Vikas Hire 10-Jan-17 8:17am

I think it would be work, but I get error. I already get convert the table tblUserInfo into json so this json not converting to ison object (please see my code above)