Create JSON Object in Web Service C#

Question

Im beginner for Web Service in C# to result data JSON. So, I have Web service to throw data with format JSON, this is my result JSON :

[{"RESULT":"2","TKN":"E952B4C5FA9","URL_HOME":"My_Url_Home"}]

How to remove Symbol "[" and "]" in My Result Json, So I want My Result JSON become this :

{"RESULT":"2","TKN":"E952B4C5FA9","URL_HOME":"My_Url_Home"}

And this is My Code :

    [WebMethod]
    [ScriptMethod(UseHttpGet = true, ResponseFormat = ResponseFormat.Json)]
    public void Create_JSON()
    {
        SqlConnection con = new SqlConnection(consString);
        SqlCommand cmd = new SqlCommand();

        DataTable dt;
        SqlDataReader reader;

        HttpContext.Current.Response.AddHeader("Access-Control-Allow-Origin", "*");

        if (HttpContext.Current.Request.HttpMethod == "OPTIONS")
        {
            //These headers are handling the "pre-flight" OPTIONS call sent by the browser
            HttpContext.Current.Response.AddHeader("Access-Control-Allow-Methods", "GET, POST, PUT, DELETE");
            HttpContext.Current.Response.AddHeader("Access-Control-Allow-Headers", "Content-Type, Accept");
            HttpContext.Current.Response.AddHeader("Access-Control-Max-Age", "1728000");
            HttpContext.Current.Response.End();
        }
        String resultJSON = "";
        JavaScriptSerializer js = new JavaScriptSerializer();
        try
        {
            Context.Response.Clear();
            Context.Response.ContentType = "application/json";

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "My_Store_Procedure";
            cmd.Connection = con;

            con.Open();
            reader = cmd.ExecuteReader();
            dt = new DataTable();
            dt.Load(reader);
            con.Close();


            JavaScriptSerializer serializer = new JavaScriptSerializer();
            List<Dictionary<String, Object>> tableRows = new List<Dictionary<string, object>>();
            Dictionary<String, Object> row;

            foreach (DataRow dr in dt.Rows)
            {
                row = new Dictionary<string, object>();
                foreach (DataColumn col in dt.Columns)
                {
                    row.Add(col.ColumnName, dr[col].ToString());
                }
                tableRows.Add(row);
            }
            resultJSON = serializer.Serialize(tableRows).ToString();

        }
        catch (Exception ex)
        {
            resultJSON = ex.Message.ToString();
        }
        Context.Response.Write(resultJSON);
    }

;

Please Help, and Thanks For All Answer.

If you remove [ and ] you won't have valid json anymore. You are serializing a list, a list will serialize to a json array and thus have angle brackets around it. — Palle Due
– Palle Due, Commented Jan 18, 2018 at 9:19

temmyraharjo · Accepted Answer · 2018-01-18 01:54:39Z

1

Should be like this right?

resultJSON = serializer.Serialize(tableRows[0]).ToString();

The problem is you tableRows type is List, but you expect to be an object.

answered Jan 18, 2018 at 1:54

temmyraharjo

765 bronze badges

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

Comments

Eva Lai · Accepted Answer · 2018-01-18 09:44:48Z

0

I don't know why you want to remove "[" and "]", cause [] are necessary for JSON.
If you have to remove [], then try this

resultJSON = serializer.Serialize(tableRows).ToString();
resultJSON = resultJSON.Substring(1, resultJSON.Length - 2);

answered Jan 18, 2018 at 9:44

Eva Lai

986 bronze badges

Collectives™ on Stack Overflow

Create JSON Object in Web Service C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related