Thanks Mike

I have tried as you suggested but still getting the same error

--Model
public class ParentViewModel
{
  public int PId {get; set;}
  public string Name {get; set;}
  public ICollection<ChildViewModel> ChildDetails
}

Public class ChildViewModel
{
  public int CId {get; set;}
  public int PId {get; set;}
  public int CData {get; set;}
}

-- View
@model Infragistics.Web.Mvc.GridModel

(Html.Infragistics().Grid(Model))

--Controller

private GridModel GetGridModel()
{ 

            GridModel model = new GridModel();
            model.AutoGenerateColumns = false;
            model.AutoCommit = true;
            model.PrimaryKey = "PId";
            model.AutoGenerateLayouts = false;
            model.ID = "igGrid";

            model.LoadOnDemand = true;

            model.Columns.Add(new GridColumn { Key = "PId", Hidden = true, DataType = "number" });
            model.Columns.Add(new GridColumn { Key = "Name", HeaderText = "Parent Name ", DataType = "string" });
            model.DataSourceUrl = (Url.Action("BindParentDetails"));
          

            GridColumnLayoutModel childModel = GetChildGridModel();

            model.ColumnLayouts.Add(childModel);
            
            return model;
}

private GridModel GetChildGridModel()
{
            GridColumnLayoutModel childModel = new GridColumnLayoutModel();
            childModel.Key = "ChildDetails";
            childModel.PrimaryKey = "CID";
            childModel.ForeignKey = "PId";
            childModel.AutoGenerateColumns = false;
            childModel.Columns.Add(new GridColumn { Key = "CId", HeaderText = "Child ID", DataType = "number" });
            childModel.Columns.Add(new GridColumn { Key = "CData", HeaderText = "Child Data", DataType = "number" });
            childModel.DataSourceUrl = Url.Action("BindChildDetails");
            return childModel ;

}
        public JsonResult BindParentDetails()
        {
            GridModel rModel = GetGridModel();

            var p = _service.GetPDetails();

            rModel.DataSource = p.AsQueryable();
            var res = rModel.GetData();
            return res;
        }

        public JsonResult BindChildDetails(string path, string layout)
        {
            var pid = path.Substring(path.LastIndexOf(':') + 1);

            GridModel grd = GetGridModel();

            var p = _service.GetChildDetails(pId);
            grd.DataSource = p.AsQueryable();
            var res = grd.GetData(path, layout);
            return res;
        }

Hello Singh,

What are you looking for when you search the params? As I mentioned sorting is unique for each column say for example you have a column called “QuatityPerUnit” the param key would look like the following: "sort(QuantityPerUnit)"

Concerning the behavior you are seeing with the igDatePicker I am unable to reproduce this behavior. Do you have a sample that demonstrates the behavior?

Hi Mike,

Thanks for your reply above. I am still trying to do sorting in the grand child level but it doesn't seem to be working.

In Request.Params do not have any property related to sorting. I am trying to access Request.Params in my  BindGrandChildDetails(string path, string layout) method.

Can you send me any working example for this please?

Also I am trying to use Infragistics Datepicker in one of my pages like below:

in cshtml

@(Html.Infragistics().DatePicker()

.ID("Date")

.ButtonType(TextEditorButtonType.DropDown)

.AddClientEvent("valueChanged", "onChangeDate")

.Value(@ViewBag.Date)

.Render())

 and in script:

$("#Date").igDatePicker({

value: new Date(y, m, d),

dateDisplayFormat: "dd/MM/yyyy",

minValue : new Date(y -1 , m, d)

});

I am able to select date but when I hover over the dropdown of the datepicker it clears the textbox which had date in it but when I hover out it shows the date.

Can I remove this property to hide the date on hovering over the dropdown arrow?

Regards

S

Thanks Mike.

Can you please send me some links regarding sorting, paging and coloring the grid or a working example so it will be helpful.

Regarding your question:

What would be the reason you would be unable to save rows? You mean like they fail validation?

It is the requirement that if I there is a newer version of the data exists in the DB then I will not save the data therefore I would want to refresh the grid with the new data and color the row which wasn't saved.

What are the functions or property exposed by the grid to maintain the state?

Again if there are any links it will be really helpful

Regards

S

Hello Singh,

For sorting you would have to handle it in the same way of getting the info out of the request and using that to return the data you want in the order you want. Same for filtering. When you use load on demand in MVC you are responsible for returning the data. Note with sorting and filtering the key will be unique for each column.