jQuery UI Widgets Forums Grid Datasource url for jqxgrid

This topic contains 4 replies, has 2 voices, and was last updated by  harsh 8 years, 11 months ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
  • Datasource url for jqxgrid #72955

    harsh
    Participant

    I have a jqxgrid in view as follows

    var source =
                  {
                      datatype: "json",
                      datafields: [
                           { name: 'MailBoxID', type: 'string' },
                           { name: 'TOName', type: 'string' },
                           { name: 'Subject', type: 'string' },
                           { name: 'DateCreated', type: 'date' }
                       ],
                      url: "/Mailman/Results/"                          
                         
                      };
                    var dataAdapter = new $.jqx.dataAdapter(source);
                    var imagerenderer = function (row, datafield, value) {
                        return '<img style="margin-left: 5px;"  src="/Images/props.gif' + value + '"/>';
                    }
                    // initialize jqxGrid
                    $("#jqxgrid").jqxGrid(
                        {
                            width: 700,
                            height:310,
                            source: dataAdapter,
                            pageable: true,
                            columns: [
                                { text: '', datafield: 'Image', cellsrenderer: imagerenderer },
                                { text: "To", datafield: "TOName", width: 289 },
                                { text: "Subject", datafield: "Subject", width: 281 },
                                { text: "Date", datafield: "DateCreated", cellsformat: 'M/d/yyyy', width: 100 }
                            ]
                        });
                });
            });
    
    and controller methods as follows
    
    

    public ActionResult Result()
    {
    Result res = new Result();
    List<Result> list = new List<Result>();
    list = res.GetResults();
    return View(list);
    }

    I would like to know how to give the url for jqxgrid when the data source url is something like ” localhost:49295/Mailman/Result?status=W” instead of ” localhost:49295/Mailman/Result”. Here status can be N,W,R etc depending on the web browser url.

    Datasource url for jqxgrid #72977

    Dimitar
    Participant

    Hello harshini,

    You can pass the additional parameters in the source data property, e.g.:

    var source = {
        datatype: "json",
        datafields: [{
            name: 'MailBoxID',
            type: 'string'
        }, {
            name: 'TOName',
            type: 'string'
        }, {
            name: 'Subject',
            type: 'string'
        }, {
            name: 'DateCreated',
            type: 'date'
        }],
        url: "/Mailman/Results/",
        data: {
            status: 'W'
        }
    };

    Best Regards,
    Dimitar

    jQWidgets team
    http://www.jqwidgets.com/

    Datasource url for jqxgrid #73008

    harsh
    Participant

    Thank you 🙂

    Datasource url for jqxgrid #73016

    harsh
    Participant

    Hi ,

    I have a particular scenario where the url can be
    1.http://localhost:49295/Mailman/Result?status=W
    2.http://localhost:49295/Mailman/Result?EMAILFROM=&EMAILTO=t16&keywords=&MAILNAMEJOIN=OR

    so I have given the source as follows. It works when status = W but does not for the second url. Can you please let me know if the data is correct when it has multiple parameters?

    var source = “”;
    var status = “@Request.QueryString[“status”]”;(this will be null for second url but it goes into the if block for some reason)

    if (status != null) {
    source =
    {
    datatype: “json”,
    datafields: [
    { name: ‘MailBoxID’, type: ‘string’ },
    { name: ‘TOName’, type: ‘string’ },
    { name: ‘Subject’, type: ‘string’ },
    { name: ‘DateCreated’, type: ‘date’ }

    ],
    url: “/Mailman/Results/”,
    data: {
    status: status

    }

    };
    }
    else
    {
    source =
    {
    datatype: “json”,
    datafields: [
    { name: ‘MailBoxID’, type: ‘string’ },
    { name: ‘TOName’, type: ‘string’ },
    { name: ‘Subject’, type: ‘string’ },
    { name: ‘DateCreated’, type: ‘date’ }

    ],
    url: “/Mailman/Results/”,
    data: {

    EMAILFROM: emailfrom,
    EMAILTO: emailto,
    keywords: kwywrds,
    MAILNAMEJOIN: mailnamejoin

    }

    };
    }

    • This reply was modified 8 years, 11 months ago by  harsh.
    Datasource url for jqxgrid #73021

    harsh
    Participant

    Hi,

    I got it working.

    condition to check null was incorrect.

    Thanks.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.