Integrating datatables.js with asp.net gridview

Question

I am trying to implement datatables.net on my asp.net gridview. I have included the necessary js and css files.

I am applying the datatables using

$(document).ready(function(){
    $('#myGridview').dataTable();
});

but it is not working. It is showing the exception in console :

"Cannot read property 'mData' of undefined"

can anyone help me out with this ?

Thanks

//code.jquery.com/jquery-1.10.2.min.js as suggested on the datatables site — Sachin Trivedi
– Sachin Trivedi, Commented May 24, 2014 at 7:54
Then it sounds like your table doesn't have a thead or tbody tag — Sterling Archer
– Sterling Archer, Commented May 24, 2014 at 7:56
yes i read that while googling this issue. but asp.net gridview is creating the table structure itself. So how can i deal with that. Please share your views if you have implemented it on gridview. — Sachin Trivedi
– Sachin Trivedi, Commented May 24, 2014 at 7:57
datatables requires the table to have a thead and tbody section -- I'm not familiar with C# or asp.net though, so I'm not sure how to make that happen — Sterling Archer
– Sterling Archer, Commented May 24, 2014 at 7:59

Sachin Trivedi · Accepted Answer · 2014-10-10 06:35:29Z

6

Here is the work around to this problem.

This error shows up because datatables.js requires thead and tbody attributes. Now asp.net gridview does not generate the attribute itself when it is rendered as html which caused datatables.js to fail.

So in order to generate in gridview please add following code in page load which will create the attributes for gridview.

 GridView1.UseAccessibleHeader = true;

//adds <thead> and <tbody> elements

GridView1.HeaderRow.TableSection =  TableRowSection.TableHeader;

and you are good to go with datatables.js

edited Oct 10, 2014 at 6:35

answered May 24, 2014 at 8:47

Sachin Trivedi

2,0534 gold badges30 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Integrating datatables.js with asp.net gridview

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related