datatables

Transforming a list of objects into List<List<string>> of data

Hi I am trying to use the jquery DataTables plugin for my system, using a webservice to populate the data through an ajax call. What I need to return from the webservice is a List like this: List<List<string>>; I have about 120 different domain classes being used by this as the core data objects, so I need some kind of system where I ...

JTemplates table + DataTables plugin Column sorting problem

Hi All, I have a HTML table to which I am binding data using the JTemplates script and then after the "processtemplate" line I am applying the datatables effect - ".dataTables();" Everything works fine - custom pagination,custom filtering etc. The only sore point is that I am unable to sort properly when I click a header. I am having ...

dataTable.net Server-Side Processing: Not seeming to refresh.

For the site my coworkers and I are working on, we used the dataTable format from www.dataTables.net and we have to use Server-Side processing because of how much the tables grow. Here's the view: <%@ Control Language="C#" Inherits="System.Web.Mvc.ViewUserControl" %> <script type="text/javascript" charset="utf-8"> $(document).ready(f...

jQuery DataTables server-side processing using ASP.NET WebForms

Problem: jQuery DataTables server-side processing using ASP.NET WebForms. Solution: Darin Dimitrov answered the question using an example which pages and sorts, but doesn't do any searching. Here's my **basic** modification of his work to make searching work on his example: public class Data : IHttpHandler { public void ProcessRe...

jQuery dataTables plugin - how to ignore word from column sort

I have a table of books with titles, authors, publishers, and dates in it. Under the title column a lot of the book titles start with the word "The." How can I setup the sort within the jquery datatables plugin to ignore the first word if it is "The" when sorting this column? Thanks. ...

jQuery DataTables Plugin Not Alphabetizing My First Cell Column

Everything is working nicely except upon load and sort clicking for the "Product" column, it's not alphabetizing the column. Instead seems like it's grabbing the URL from the anchor href and sorting it that way. Any tips on sorting it by using the content in between the ? I'm fine with tossing a in there for easier targeting via js. ht...

jQuery DataTables Plugin: Serializing dataTables variables

(This question is very specific to the dataTables plugin) Hi, I'm using the dataTables plugin (1.70) for jQuery (1.4.2) in my web application, and I'm trying to write a custom .csv export for my tables. I've already got a fully functioning (search, pagination, filter, sort) dataTables set-up using server-side processing. What I'm tryin...

Error with jQuery dataTable plugin 1.6.0

I am using dataTable.1.6.0, below is the my code... $('#eventsPane div.genreEvents table').dataTable({ scrollHeight: 410, "aoColumns":[ {"bSortable":false}, null, {"bSortable":false}, {"sType":"date","iDataSort":4}, {"bSortable":false}, null ], "aaSorting":[[3,'asc']] }); ...

Creating Disconnected DataRows in .NET

How do you create DataRow instances that aren't tied to any particular DataTable instance? (EDIT: I know you can create DataRows using the DataTable.NewRow() method, but the problem is that I can't seem to disconnect the row from its parent table so I can pass the individual row around without having to pass the entire table around) ...

How to use DataTables jQuery object with ZendX_jQuery

Hi Everyone, I am trying to use ZendX_jQuery and Datatables for a project. In my layout file I have: if($this->jQuery()->isEnabled()){ $this->jQuery()->setLocalPath('/js/jquery/js/jquery-1.4.2.min.js') ->setUiLocalPath('/js/jquery/js/jquery-ui-1.8.4.custom.min.js') ->addStylesheet('/css/smoothness/custom.css') ->addJa...

Jquery DataTables change order to desc when it sorts

I am using DataTables to display some data and it works great but I want to customize it slightly and not sure how. What I want to do is when a user clicks on a column heading to sort that column I want it to initially order descendingly rather than ascendingly. Is there any way to do this? ...

I want to create links in record fields in DataTables from JSON data

I'm creating a dataTables table to use as an archive of pages for a site that produces a comic strip. On that archives page, I'd like to have the title of the comic be a link to the page of that comic strip. Initialization: <script type="text/javascript" charset="utf-8"> $(document).ready(function() { $('#ex...

jquery datatables updating a cell

Hi there. I have a table set out like: <table id="myTable"> <thead> <tr> <td><input type="checkbox" id="selectall" /></td> <td>Column 1</td> <td>Column 2</td> <td>Column 3</td> <td>Column 4</td> <td>Column 5</td> </tr> </thead> <tbody> </tbody> </table> Then, the javascript: var my...

Example of using datatables jquery plugin with a WCF service

Does anyone know of any samples that use the DataTables jquery plugin with a WCF service? I'm attempting to use a WCF service with the JavaScriptSerializer which unfortunately seems to return dodgy JSON by adding extra backslashes. However the DataTables would seem to provide a way to work around that given that the retrieval of the JS...

How do i specify a colspan on jquery datatables from ajaxsource?

I use the following code to fetch a json and load it as content for a blank table which is added dynamically to the DOM by: $('#a_dialog').html('<table cellpadding="0" cellspacing="0" border="0" class="display" id="tbl_random_number"></table>'); The reason for this is because I find it easier to construct a JSON object than to create a...

Javasript hammered performance

Hi There, I just started using datatables (java script) for tabular data, due to js I am able to use functionalities like search, how many rows per page, sorting and pagination. Before using js, I was simply showing data in table(used Ajax for pagination), but unable to use above functionalities (Performance in this case was g...

How do you properly escape json to be sent over ajax? (Using Datatables)

I would like to know how to properly escape my json code. I am using the datatables plugin and this is the json that is failing. "6\\\\\\\' 5\\\\\\\" Ford HD ", It originally looks like this (without the opening/closing brackets and the comma): 6\\\' 5\\\" Ford HD How would I properly escape this? ...

Struggling With DataTables in Java...

I'm a .NET Developer trying my hand at Java. My current project has a UI layer, Business logic layer, and a Data Access layer. I'm currently working on the DAL. I'm not connecting to an external database yet; I had hoped to have my DAL classes utilize in-memory dataTables until the DB is in place. In .NET it's very easy to make in-...

sAjaxSource doesn't get executed in IE

I am using jquery datatables serverside in my MVC application. When I put a break point to my controller method “FillTable” the execution only reaches on the first occasion on IE. If I go back and reload the page and the data is different the function doesn’t get called. When I try Firefox the break point is hit on each reload without an...

Has anyone got Datatables 1.7.x to actually work with ASP.NET MVC 2 ?

Hello, Is there a demo somewhere how to use Datatables 1.7.x with ASP.NET MVC 2 ? Is saw an early demo somewhere but the Datatables API has since been updated. Does anyone have working code for implementation ? Thanks! ...