Json format on return

Question

I need to pass a json with the following format:

{rows:[
    { 
     data:[
       "1",
       "Nome teste",
       "Descricao teste"]
}]}

But when using my jsonresult action, I don’t know how to return this way

 public JsonResult Data()
    {
      var grupos= grupoService.BuscaTodos();

      return Json(new
      {
        rows = new
        {
          data = grupos
        }
      }, JsonRequestBehavior.AllowGet);
    }

he ends up returning like this:

{"rows":{
      "data":[{
             "Nome":"nome",
              "Descricao":"descricao",
              "Id":110,
              "DataCadastro":null}]
}}

Someone can tell me what I need to do?

Blue is how I want it, red is how it’s coming

Answer 1

Basically to its layout would be like this:

return Json(new
        {
            rows = new object[] {
                new {
                    data = new string[]
                    {
                        "1", "NomeTeste", "Descricao Teste"
                    }
                }
            }
        }, JsonRequestBehavior.AllowGet);

If it’s a list for example:

var dados = new object[] 
{
    new object[] {"1", "NomeTeste 1", "Descricao Teste 1" },
    new object[] {"2", "NomeTeste 2", "Descricao Teste 2" }
};

return Json(new
{
    rows = new object[] {
        new {
            data =  dados
        }
    }
}, JsonRequestBehavior.AllowGet);

Classy:

public class Exemplo
{
    public int Id { get; set; }
    public String Nome { get; set; }
    public String Descricao { get; set; }
    public DateTime? DataCadatro { get; set; }
}   

---

IList<Exemplo> dados = new List<Exemplo>();
dados.Add(new Exemplo()
{
    Id = 1,
    Nome = "NomeTeste 1",
    Descricao = "Descricao 1"
});
dados.Add(new Exemplo()
{
    Id = 2,
    Nome = "NomeTeste 2",
    Descricao = "Descricao 2"
}); 

---

return Json(new
    {
        rows = new object[] {
            new {
                data =  dados.Select(x => new object[]{
                    x.Id.ToString(), x.Nome.ToString(), x.Descricao.ToString()
                })
            }
        }
    }, JsonRequestBehavior.AllowGet);

Forcing only the first list item:

return Json(new
    {
        rows = new object[] {
            new {
                data =  dados.Select(x => new object[]{
                    x.Id, x.Nome.ToString(), x.Descricao.ToString()
                })
                .FirstOrDefault()
            }
        }
    }, JsonRequestBehavior.AllowGet);

With the New Edition made the layout clearer:

IList<Exemplo> dados = new List<Exemplo>();
dados.Add(new Exemplo()
{
    Id = 1,
    Nome = "NomeTeste 1",
    Descricao = "Descricao 1"
});
dados.Add(new Exemplo()
{
    Id = 2,
    Nome = "NomeTeste 2",
    Descricao = "Descricao 2"
});

return Json(new
{
    rows = dados.Select(x => new 
            {
                x.Id, 
                Data = new object[] { 
                    x.Id, x.Nome.ToString(), x.Descricao.ToString()
                }                            
            })                                    
}, JsonRequestBehavior.AllowGet);

Answer 2

Try this:

    public JsonResult Data()
    {
        var grupos = grupoService.BuscaTodos().Select(data => new
        {
            data.Id,
            data.Nome,
            data.Descricao
        });
        return Json(new
        {
            rows = new
            {
                data = grupos
            }
        }, JsonRequestBehavior.AllowGet);
    }