Is there any type of grid that doesnt have the member url and can load json data

[learnerParticipant]

Hi,

I have a situation where I can’t use the member url to go and find the data instead I want to load the data in grid as soon as the function for loading the grid is invoked and I want to send the data along with the same function. If the url calls the data again I lose some data. So I don’t want to use url and send the data itself with the function.

 public ActionResult Checker(int Id)
        {
            var dataContext = new PetaPoco.Database("MessageEntity");
            var jsonOLD = dataContext.SingleOrDefault<OldData>("Select OldJson from MakerChecker2 where MakerCheckerId=@0", Id);
            var jsonNEW = dataContext.SingleOrDefault<NewData>("Select NewJson from MakerChecker2 where MakerCheckerId=@0", Id);

            MakerCheckerModel mcmodel = new MakerCheckerModel();

            mcmodel.OldJson = jsonOLD.OldJson;
            mcmodel.NewJson = jsonNEW.NewJson;
            UserModel olduser = JsonConvert.DeserializeObject<UserModel>(mcmodel.OldJson);
            UserModel newuser = JsonConvert.DeserializeObject<UserModel>(mcmodel.NewJson);

            var propertyNameList = new List<string>();
            List<PropertiesVM> model = new List<PropertiesVM>();

            foreach (PropertyInfo propertyInfo in typeof(UserModel).GetProperties())
            {
                PropertiesVM prop = new PropertiesVM();
                prop.ColumnName = propertyInfo.Name;
                prop.OldValue = propertyInfo.GetValue(olduser, null);
                prop.NewValue = propertyInfo.GetValue(newuser, null);
                model.Add(prop);
            }
           var result = JsonConvert.SerializeObject(model);
            return View(result );
        }

In this way I want to send the data along with the function and If this function is called from url:User/Checker/ I am not being able to send the Id along with. So I want to do this. Please help!

[Peter StoevKeymaster]

Hi learner,

You can take a look at: http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/bindingtojsonstring.htm?arctic for loading JSON data without url.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[learnerParticipant]

Thanks Peter for the fast response. The example you gave me uses
var data = ‘[{ “CompanyName”: “Alfreds Futterkiste”, “ContactName”: “Maria Anders”, “ContactTitle”: “Sales Representative”,…….}]’ as hard coding the data. But I cannot do this as my data is dynamically created by my function.

[Peter StoevKeymaster]

Hi learner,

It does not matter that your data is dynamic. You can dynamically set the Grid’s source property, too.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[learnerParticipant]

Thanks Peter, Ok then tell me how would I dynamically set the Grid’s source property, what I just tried was omitted the data and localdata property and inside source made the datafields according to my data. But couldn’t get the data loaded. Please help!!

[Peter StoevKeymaster]

To refresh the Grid’s source dynamically do this: $(“#grid”).jqxGrid({source: newAdapter});

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts