grid not displayed any record

[Quest Resource Management]

Hello,

Grid not displayed any record.

I want grid with autogeneratecolumn = true.

any help would be appreciated......

public ActionResult getData([DataSourceRequest]DataSourceRequest request)

        {

            List<Class1> c1s = new List<Class1>();

 

            for (int i = 0; i < 5; i++)

            {

                Class1 c1 = new Class1();

                c1.ID = i;

                c1.Name = "Name" + i;

                c1s.Add(c1);

            }

 

            return Json(c1s.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);

        }

[Serializable]

  public class Class1

  {

      public int ID { get; set; }

      public string Name { get; set; }

  }


<div id="mygrid">

</div>

<script type="text/javascript">

    $(document).ready(function () {

        $("#mygrid").kendoGrid({

            dataSource: {

                type: "odata",

                serverPaging: true,

                serverSorting: true,

                pageSize: 100,

                transport: {

                    read: "/Home/getData"

                }

            },

            height: 280,

            scrollable: {

                virtual: true

            },

            sortable: true

        });

    });

</script>

Note : There is not any JS error.

If i tried with below read method then its works.

read: "http://demos.kendoui.com/service/Northwind.svc/Orders"

Thanks,
Jason

[Alexander Valchev]

Hi Jason,

The problem comes from the fact that the data array is not specified in the schema.data. Please add the following you your DataSource configuration:

schema: {
    data: "Data",
    total: "Total",
    aggregates: "AggregateResults",
    errors: "Errors"
}

I hope this will help.

Kind regards,
Alexander Valchev
the Telerik team

[Quest Resource Management]

Can you please explain, how to implement your changes in my code?
i have created MvcApplication1 (Default MVC4 application).

 

HomeController.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

using Kendo.Mvc.UI;

using MvcApplication1.Models;

using Kendo.Mvc.Extensions;

 

namespace MvcApplication1.Controllers

{

    public class HomeController : Controller

    {

        public ActionResult Index()

        {

            ViewBag.Message = "Modify this template to jump-start your ASP.NET MVC application.";

 

            return View();

        }

 

        public ActionResult About()

        {

            ViewBag.Message = "Your app description page.";

 

            return View();

        }

 

        public ActionResult Contact()

        {

            ViewBag.Message = "Your contact page.";

 

            return View();

        }

        public ActionResult getData([DataSourceRequest]DataSourceRequest request)

        {

            List<Class1> c1s = new List<Class1>();

 

            for (int i = 0; i < 5; i++)

            {

                Class1 c1 = new Class1();

                c1.ID = i;

                c1.Name = "Name" + i;

                c1s.Add(c1);

            }

 

            return Json(c1s.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);

        }

 

     }

}

Index.cshtml

@{

    ViewBag.Title = "Home Page";

}

<script src="@Url.Content("~/Scripts/jquery.unobtrusive-ajax.min.js")" type="text/javascript"></script>

@section featured {

    <section class="featured">

        <div class="content-wrapper">

            <hgroup class="title">

                <h1>@ViewBag.Title.</h1>

                <h2>@ViewBag.Message</h2>

            </hgroup>

            <p>

                To learn more about ASP.NET MVC visit

                <a href="http://asp.net/mvc" title="ASP.NET MVC Website">http://asp.net/mvc<;/a>.

                The page features <mark>videos, tutorials, and samples</mark> to help you get the most from ASP.NET MVC.

                If you have any questions about ASP.NET MVC visit

                <a href="http://forums.asp.net/1146.aspx/1?MVC" title="ASP.NET MVC Forum">our forums</a>.

            </p>

        </div>

    </section>

}

<h3>

    We suggest the following:</h3>

<ol class="round">

    <li class="one">

        <h5>

            Getting Started</h5>

        ASP.NET MVC gives you a powerful, patterns-based way to build dynamic websites that

        enables a clean separation of concerns and that gives you full control over markup

        for enjoyable, agile development. ASP.NET MVC includes many features that enable

        fast, TDD-friendly development for creating sophisticated applications that use

        the latest web standards. <a href="http://go.microsoft.com/fwlink/?LinkId=245151">Learn

            more…</a> </li>

    <li class="two">

        <h5>

            Add NuGet packages and jump-start your coding</h5>

        NuGet makes it easy to install and update free libraries and tools. <a href="http://go.microsoft.com/fwlink/?LinkId=245153">

            Learn more…</a> </li>

    <li class="three">

        <h5>

            Find Web Hosting</h5>

        You can easily find a web hosting company that offers the right mix of features

        and price for your applications. <a href="http://go.microsoft.com/fwlink/?LinkId=245157">

            Learn more…</a> </li>

</ol>

<div id="mygrid">

</div>

<div id="mygrid">

</div>

<script type="text/javascript">

    $(document).ready(function () {

        $("#mygrid").kendoGrid({

            dataSource: {

                type: "odata",

                serverPaging: true,

                serverSorting: true,

                pageSize: 100,

                transport: {

                    read: "/Home/getData"

                }

            },

            height: 280,

            scrollable: {

                virtual: true

            },

            sortable: true

        });

    });

</script>

i have create Class1.cs in models folder.

Class1.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

 

namespace MvcApplication1.Models

{

    [Serializable]

    public class Class1

    {

        public int ID { get; set; }

        public string Name { get; set; }

    }

  

}

[Alexander Valchev]

Hi Jason,

I believe that there is a misunderstanding.
The data returned by the server seems to be OK, you have to edit your Kendo Grid configuration.

$("#mygrid").kendoGrid({
    dataSource: {
        //type: "odata",
        serverPaging: true,
        serverSorting: true,
        pageSize: 100,
        transport: {
            read: "/Home/getData"
        },
        schema: {
            data: "Data",
            total: "Total"
        }
    },
    height: 280,
    scrollable: {
        virtual: true
    },
    sortable: true
});

For more information please check the documentation of DataSource's configuration options.
In case you need further assistance I would like to ask you to open a support ticket preferably with a sample runnable project attached. In this way I would be able to examine your case in details and assist you further.

Kind regards,
Alexander Valchev
the Telerik team

[Jayesh Goyani]

Hello,

First create Table structure then convert this in to Kendo Grid.

$(document).ready(function () {

  $("#myActivityGrid").data("kendoGrid");

//OR

("#myActivityGrid").kendoGrid({ pageable: true,

        sortable: true

            });

 });

<table id="myActivityGrid">

           <thead>

               <tr>

                       <th style="text-align: center;">Header Name

                       </th>  

               </tr>

           </thead>

           <tbody>

                   <tr>

                       @foreach (var _var in Model.YourList)

                       {

                           <td>@_var.Data</td>

                       }

                   </tr>

           </tbody>

       </table>

Thanks,
Jayesh Goyani