[dqninh09@gmail.comParticipant]

Never mind. I figured it out.

I added a callback function for the jqxDataAdapter.loadComplete and check the length of the data adapter. It works beautifully.

[dqninh09@gmail.comParticipant]

Works like a champ! Thank you Dimitar.

[dqninh09@gmail.comParticipant]

Hi Peter,

It works, with a deep gliche. :). If you have a datatable that is grouped, the sorting of a column will mess up the group.

For example, if you have a datasource that has the following columns:

State
City
Name
Address

And you have a datatable using the above datasource, grouped by State. If you don’t have a sorted column, and the the group is displayed in order with states that has A like Arkansas, Alaska, Az first. But, if you have a sorted column, for example, on the Name, and then the order of the State group is messed up badly.

Thanks.

[dqninh09@gmail.comParticipant]

Hi Peter,

No. I still want the advanced mode, but I want to include the simple mode by having the option “search All” in the search dropdown listbox.

[dqninh09@gmail.comParticipant]

How about just one column? Can it be sorted by Name within the State group?

[dqninh09@gmail.comParticipant]

Thank you Peter.

Is there also a method that can be used to move a row up or down?

Thanks

[dqninh09@gmail.comParticipant]

I have to use cellsrenderer from another column, and the use $(#).jqxGrid() to get the value of the rendering row. However, I wonder if it’s safe to do so?

Another question is, how to I find out if a row is already selected? If selectrow() is called inside the cellsrenderer(), it will of-course create a infinite loop.

Thanks.

[dqninh09@gmail.comParticipant]

But, is there a way to set the search field to a particular column on the list?

Thanks.

[dqninh09@gmail.comParticipant]

Filtering is nice. I don’t want to disable filtering.

When there is a will, will be there a way. 🙂

[dqninh09@gmail.comParticipant]

Thanks Peter, that works.

I start liking your product. :))

[dqninh09@gmail.comParticipant]

Thanks Peter.

Finally, I figured it now. Even though that the data source is set to “xml”, it expected a string to return. I change the GetXmlData2() function to return a string type as shown below, and it works beautifully.

public string GetXmlData2()
{
this.ServiceDocument = GetData();
return View(this.ServiceDocument.Root.ToString());
}

[dqninh09@gmail.comParticipant]

For more information, here is my result method in Controller

public ActionResult GetXmlData2()
{
this.ServiceDocument = GetData();
return View(this.ServiceDocument.Root);
return View(this.ServiceDocument.Root.ToString(SaveOptions.DisableFormatting));
}

And here is my jqxDataAdapter

var source =
{
datatype: “xml”,
root: “MCNDATA”,
record: “Record”,
url: ‘@Url.Action(“GetXmlData2”, “Home”)’,
};

As soon as the url is not set to a file, it does not work. I debugged and indeed the GetXmlData2() is called correctly, and the method return a valid Xml (basically the same xml from the same file)

Thanks.

[dqninh09@gmail.comParticipant]

hi Peter,

I know that I am a pain on the neck, but the sample you gave out is of course working only if you have the data on the client site (or hard-code it locally inside the script like you did. But in the real world it does not work that way.

I know that you cannot create all scenario. But, if jqwidgets claims to work with MVC, XML, binding remotely, and then it should have at least one example for MVC. In the MVC’s world, people would read data from the controller and return view(). That is the example (and scenario) that most people would looking for.

But thank you so much anyway. You are great technical supporter.

[dqninh09@gmail.comParticipant]

Hi Peter,

So, would you confirm that there is absolutely no way to use XML data (and so JSON) with jqDataAdapter, unless the XML is written to a file first? Basically, the XML string (or JSON string) requires special handling in a HTML page. All HTML reserved characters must be converted to pre-defined string. For example, double quote must be convert to ", less than sign (<) must be converted to <, and so on… And I don’t see jqDataTable, jqGrid, jqTreeGrid, jqDataAdapter together support the conversion.

Thanks

[dqninh09@gmail.comParticipant]

Hi Peter,

Do you have sample code that set the “localdata:” to a xml string?

Thanks.

[Author]

Posts