Hi again Tony,

our team has checked several of the MVC samples browser samples on 1.6.2, and they work fine, so it looks like the jQuery version is maybe not the issue in your case.

to isolate further the issue, i suggest you run the MVC Samples browser, and compare the view / controller definitions with your own project.

At best, some sample code snippet that you have would be of great help to us. 

Thank you

Angel

Hi Tony,

I have downloaded your sample (so you can safely remove it now), i took a look at the code, everything looks really simple and correct, but maybe the problem is in this line:

column.For(x => x.AccountNumber).DataType("int")

DataType should be either "string", "date", "number" or "bool". I suggest to change the above to "number".

I won't get a chance to run the sample until tomorrow, but in the meantime you can try to above suggestion. I'll let you know additionally, if that doesn't help. 

By the way there is no need to explicitly specify a DataType for the columns, because when the grid is configured in the view, the grid MVC code automatically determines the DataType. 

Thank you,

Angel

Well, I tried setting them all to string, then ended up removing the .DataType specifier alltogether, but I'm still getting the same error.

By the way, in this test project, the error comes up in ig.ui.min.js

In my production app, it's in a jquery file. It's the same exception though.

Hi Tony,

I ran your sample and managed to reproduce the issue you're experiencing. Basically there wasn't any data coming from the server to the client. You need to replace this line in the controller:

return Json(Models.AccountModels.GetAccountList(), JsonRequestBehavior.AllowGet);

with this one:

  return View(Models.AccountModels.GetAccountList().AsQueryable<BankAccount>());

The grid automatically resolves this and sends JSON in the response instead of HTML data. That's because of the   [GridDataSourceAction] attribute, which serves as a kind of data filter.

You can still just return Json(..) but this would mean you cannot take advantage of paging, sorting, filtering, etc., because there won't be any filter to intercept and process that . (Also in the latter case ResponseDataKey would need to be set to "" because all records would be automatically serialized in the root of the response by the MVC JSON Serializer).

By changing the above, the sample should work fine. One thing i noticed is that with the ig.uimin.js file you have referenced in the sample app, there are issues with jQuery 1.6.2. I tried replacing this reference with the latest IG code, and it seems to work fine. In the meantime i suggest to reference jQuery 1.4.4 or make sure the ig.ui.js is coming from the latest official build. 

Thank you, and hope it helps,

Angel

Here's something interesting, though I'm not sure what to make of it.

I created a third table in the database and added some data. This new table has no relationships in the database. When I added a new grid, using the new datatable through entity framework, it works the way I would expect it to; the data shows up in the grid with NO errors.

The data from tables that have a relationship, however, fails with the initial error: The remote request to fetch data has failed.

Any ideas now? I can upload a new demo if it helps. Just let me know.

Hello Anthony ,

Please let us know if Angel's suggestion helped you resolve the issue.

Feel free to ask id you need further assistance regarding this.

Ok, I'll work around the empty result issue. I'm also having to cast to a generic list for results to show up, but i can live with that. This product isn't going live until the end of the year so I look forward to seeing some issues resolved before then.

Thanks for the help.

Hello,

Here is the latest internal build.

hi,

the issue about the exception when there are no records in teh underlying datasource is not related to the jquery version (it's part of the server-side logic). That's fixed but it's not available in the first service release build. I am sure our development support team will be able to provide you with the internal build which has this fix as well.

Thank you,

Angel

Hello Tony,

Thank you for the fast update.

You are correct , the version of the jQuery the cause.

The first service release of the toolset is not officially tested with the 1.6.2 version

If you use v 1.4.4 for example you won't experience the issue. 

ok, installed the service release and updated my project.

However, I'm still getting the error for an empty result set (List<Account).

I updated the scripts, CSS, and the Infragistics.Web.Mvc.dll

Maybe it's the scripts?

    <script src="@Url.Content("~/Scripts/jquery-1.6.2.min.js")" type="text/javascript"></script>
    <script src="@Url.Content("~/Scripts/jquery-1.8.14.min.js")" type="text/javascript"></script>
    <script src="@Url.Content("~/Scripts/json2.js")" type="text/javascript"></script>
    <script src="@Url.Content("~/Scripts/jquery-ui.min.js")" type="text/javascript"></script>
    <script src="@Url.Content("~/Scripts/jquery.tmpl.js")" type="text/javascript"></script>
    
    <script src="@Url.Content("~/Scripts/ig.ui.min.js")" type="text/javascript"></script>
    <script src="@Url.Content("~/Scripts/ig.ui.grid.min.js")" type="text/javascript"></script>
    <script src="@Url.Content("~/Scripts/ig.ui.editors.min.js")" type="text/javascript"></script>

The error is in jquery-1.6.2.js

The message is: Microsoft JScript runtime error: The remote request to fetch data has failed:  (error) undefined

If there are records in the database, then I don't get the error.